Re: RMAN restore question
Date: Thu, 6 Oct 2011 06:30:12 -0700 (PDT)
Message-ID: <1317907812.75535.YahooMailNeo_at_web113207.mail.gq1.yahoo.com>
The old datafile copy should not impact your recovery at all. You can confirm this if you like by using the restore validate command.
You will want to crosscheck the datafile copy, not backups. Use the crosscheck copy of command to crosscheck your datafile copy and mark it as obsolete.
RF
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is just the opinion of one Oracle employee. I can be wrong, have been wrong in the past and will be wrong in the future. If your problem is a critical production problem, you should always contact Oracle support for assistance. Statements in this email in no way represent Oracle Corporation or any subsidiaries and reflect only the opinion of the author of this email.
From: P D <pdba1966_at_hotmail.com>
To: jvmster_at_gmail.com
Cc: oracle-l_at_freelists.org
Sent: Wednesday, October 5, 2011 8:57 PM Subject: RE: RMAN restore question
I am not sure I understand. I may want to restore from a Level 0 backup that was taken 3 days ago. When I did a CROSSCHECK BACKUP it showed it as AVAILABLE.
In the log however I found where there is also a datafile copy (actually controlfile backup) that is several months old that is showing up as mismatched which therefore couldn't be deleted from disk channel. I am trying to figure out if old copy will interfere or prevent me from restoring from the backup that was taken 3 days ago? Or when it says something like that is mismatched does it basically mean it is like a ghost copy in catalog that just needs to be cleaned up but won't interfere with restore of current copy.
Date: Thu, 6 Oct 2011 09:10:02 +0530
Subject: Re: RMAN restore question
From: jvmster_at_gmail.com
To: pdba1966_at_hotmail.com
CC: oracle-l_at_freelists.org
hi,
pleas try to use until sequence option....based on sequence numer u will get that.
On Thu, Oct 6, 2011 at 8:31 AM, P D <pdba1966_at_hotmail.com> wrote:
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-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 06 2011 - 08:30:12 CDT