RMAN Issue
Date: Wed, 17 Aug 2011 09:37:05 -0400
Message-Id: <601A5340-6B06-4F61-8684-EA2CE3762FB4_at_intactus.com>
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--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 17 2011 - 08:37:05 CDT