FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 17, '11 at 1:37p
activeAug 17, '11 at 1:37p
posts1
users1
websiteoracle.com

1 user in discussion

Bill Zakrzewski: 1 post

People

Translate

site design / logo © 2022 Grokbase