RMAN restore question
From: P D <pdba1966_at_hotmail.com>
Date: Wed, 5 Oct 2011 23:01:19 -0400
Message-ID: <SNT115-W3406E870BB8C4D6D9CE300D0F90_at_phx.gbl>
Will receiving the following error affect a restore from a backup taken 3 days ago if the Datafile Copy that the warning is referring to is actually very old.
Date: Wed, 5 Oct 2011 23:01:19 -0400
Message-ID: <SNT115-W3406E870BB8C4D6D9CE300D0F90_at_phx.gbl>
Will receiving the following error affect a restore from a backup taken 3 days ago if the Datafile Copy that the warning is referring to is actually very old.
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN-06211: ========================== RMAN-06212: Object Type Filename/Handle RMAN-06213: --------------- --------------------------------------------------- RMAN-06214: Datafile Copy /u03/backup/prod_nmnr/20100419/Fri_controlfile.bkp
The backup script itself runs a Level 0 backup using target database control file instead of recovery catalog. The recovery manager backup from 3 days ago completed.
The script then connects to the catalog and does the following:
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup of database;
delete noprompt obsolete;
Ran a CROSSCHECK BACKUP command and the backup from 3 days ago is showing up as AVAILABLE.
Was just wondering what the affect of the warning for the old controlfile might have on a restore.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 05 2011 - 22:01:19 CDT