nobleit
asked on
location of backup
For a backup like this where is the location of backup.
How can we recover?
C:\Documents and Settings\Mathew>rman target /
Recovery Manager: Release 11.1.0.6.0 - Production on Fri Mar 25 01:30:40 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1274448917, not open)
RMAN> backup database plus archivelog;
Starting backup at 25-MAR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=154 device type=DISK
specification does not match any archived log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 25-MAR-11
Starting backup at 25-MAR-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\MATHEW\ORADATA \ORCL\SYST EM01.DBF
input datafile file number=00002 name=C:\APP\MATHEW\ORADATA \ORCL\SYSA UX01.DBF
input datafile file number=00005 name=C:\APP\MATHEW\ORADATA \ORCL\EXAM PLE01.DBF
input datafile file number=00003 name=C:\APP\MATHEW\ORADATA \ORCL\UNDO TBS01.DBF
input datafile file number=00004 name=C:\APP\MATHEW\ORADATA \ORCL\USER S01.DBF
channel ORA_DISK_1: starting piece 1 at 25-MAR-11
channel ORA_DISK_1: finished piece 1 at 25-MAR-11
piece handle=C:\APP\MATHEW\FLASH _RECOVERY_ AREA\ORCL\ BACKUPSET\ 2011_03_25 \O1_MF_N
NNDF_TAG20110325T013113_6R RR74J3_.BK P tag=TAG20110325T013113 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 25-MAR-11
channel ORA_DISK_1: finished piece 1 at 25-MAR-11
piece handle=C:\APP\MATHEW\FLASH _RECOVERY_ AREA\ORCL\ BACKUPSET\ 2011_03_25 \O1_MF_N
CSNF_TAG20110325T013113_6R RRCS6C_.BK P tag=TAG20110325T013113 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-MAR-11
Starting backup at 25-MAR-11
using channel ORA_DISK_1
specification does not match any archived log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 25-MAR-11
RMAN>
Thanks
How can we recover?
C:\Documents and Settings\Mathew>rman target /
Recovery Manager: Release 11.1.0.6.0 - Production on Fri Mar 25 01:30:40 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1274448917, not open)
RMAN> backup database plus archivelog;
Starting backup at 25-MAR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=154 device type=DISK
specification does not match any archived log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 25-MAR-11
Starting backup at 25-MAR-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\MATHEW\ORADATA
input datafile file number=00002 name=C:\APP\MATHEW\ORADATA
input datafile file number=00005 name=C:\APP\MATHEW\ORADATA
input datafile file number=00003 name=C:\APP\MATHEW\ORADATA
input datafile file number=00004 name=C:\APP\MATHEW\ORADATA
channel ORA_DISK_1: starting piece 1 at 25-MAR-11
channel ORA_DISK_1: finished piece 1 at 25-MAR-11
piece handle=C:\APP\MATHEW\FLASH
NNDF_TAG20110325T013113_6R
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 25-MAR-11
channel ORA_DISK_1: finished piece 1 at 25-MAR-11
piece handle=C:\APP\MATHEW\FLASH
CSNF_TAG20110325T013113_6R
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-MAR-11
Starting backup at 25-MAR-11
using channel ORA_DISK_1
specification does not match any archived log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 25-MAR-11
RMAN>
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Who's speaking about a point in time recovery ?
P
P
@slightwv : +1
You're right ! Used to call both commands everyday, so I didn't pay attention...
No need for the 'RECOVER...' line.
P
You're right ! Used to call both commands everyday, so I didn't pay attention...
No need for the 'RECOVER...' line.
P
This implies it performed a cold backup. Without archive logs you cannot do a point in time recovery.