FAQ
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.

Search Discussions

  • P D at Oct 6, 2011 at 3:58 am
    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@gmail.com
    To: pdba1966@hotmail.com
    CC: oracle-l@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 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.
  • Robert Freeman at Oct 6, 2011 at 1:31 pm
    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@hotmail.com>
    To: jvmster@gmail.com
    Cc: oracle-l@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@gmail.com
    To: pdba1966@hotmail.com
    CC: oracle-l@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 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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 6, '11 at 3:02a
activeOct 6, '11 at 1:31p
posts3
users2
websiteoracle.com

2 users in discussion

P D: 2 posts Robert Freeman: 1 post

People

Translate

site design / logo © 2022 Grokbase