RMAN Issue
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Aug 2011 09:37:05 -0400
Oracle 10.2.0.5.0
Linux RHEL 5
Using RMAN to backup my physical standby database using the following script....
run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'WEBDB1_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag
'WEBDB1_LEVEL_0' database;
]
On Monday the files were recovered....
connected to target database: WEBDB1 (DBID=2364427377, not open)
RMAN>
connected to recovery catalog database
RMAN> 2> 3> 4> 5>
allocated channel: oem_disk_backup
channel oem_disk_backup: sid=1074 devtype=DISK
Starting recover at 15-AUG-11
channel oem_disk_backup: starting incremental datafile backupset restore
channel oem_disk_backup: specifying datafile copies to recover
recovering datafile copy fno=00001 name=/data3/oradata/flash_recovery_area/WEBDB
On Tuesday the files were not found.....
connected to target database: WEBDB1 (DBID=2364427377, not open)
RMAN>
connected to recovery catalog database
RMAN> 2> 3> 4> 5>
allocated channel: oem_disk_backup
channel oem_disk_backup: sid=1078 devtype=DISK
Starting recover at 16-AUG-11
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
On Wednesday the files were recovered again....
connected to target database: WEBDB1 (DBID=2364427377, not open)
RMAN>
connected to recovery catalog database
RMAN> 2> 3> 4> 5>
allocated channel: oem_disk_backup
channel oem_disk_backup: sid=1078 devtype=DISK
Starting recover at 17-AUG-11
channel oem_disk_backup: starting incremental datafile backupset restore
channel oem_disk_backup: specifying datafile copies to recover
recovering datafile copy fno=00001 name=/data3/oradata/flash_recovery_area/WEBDB
Anybody ever have this issue, I have 2 sets of datafiles one set that was
restored on Aug 17th and one that was taken on Aug 16th.
Thanks,
Bill--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RMAN Issue - Bill Zakrzewski
