Mani's Blog

November 4, 2011

RMAN-00571 RMAN-00569 RMAN-06026 RMAN-06023: no backup or copy of datafile 4 found to restore

Filed under: Backup,Oracle,RMAN — mani @ 6:22 pm

Issue: I tried to restore one of our RMAN backups to our standby server to make sure the backups are good to recover.  I ran into below errors.

Error:

released channel: d1
released channel: d2
released channel: d3
released channel: d4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/04/2011 16:48:56
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Fix: As usual tried checking permission on ASM, access to backup files, CROSSCHECK backupset, Delete obsolete and few others.  Finally noticed that database was set to incorrect incarnation.  I had to reset it to the correct one.  Run “LIST INCARNATION;” on RMAN prompt.  Then choose the right incarnation. After the reset of database to right incarnation, restore and recover went well.
RMAN> reset database to incarnation 2;

database reset to incarnation 2

RMAN> run {
allocate channel d1 device type disk;
allocate channel d2 device type disk;
allocate channel d3 device type disk;
allocate channel d4 device type disk;
restore database;
switch datafile all;
switch tempfile all;
recover database;
}

allocated channel: d1
channel d1: SID=10980 device type=DISK

allocated channel: d2
channel d2: SID=10983 device type=DISK

allocated channel: d3
channel d3: SID=10986 device type=DISK

allocated channel: d4
channel d4: SID=10981 device type=DISK

Starting restore at 04-NOV-11

channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 00002 to +XN_DATA/xnodbcor/datafile/sysaux.257.715025373
channel d1: restoring datafile 00003 to +XN_DATA/xnodbcor/datafile/undotbs1.258.715025373
channel d1: restoring datafile 00004 to +XN_DATA/xnodbcor/datafile/users.286.766341725
channel d1: restoring datafile 00006 to +XN_DATA/xnodbcor/datafile/undotbs3.265.715025525
channel d1: restoring datafile 00012 to +XN_DATA/xnodbcor/datafile/xn_opensocial.266.715203251
channel d1: restoring datafile 00013 to +XN_DATA/xnodbcor/datafile/content_data.271.715203641
channel d1: restoring datafile 00017 to +XN_DATA/xnodbcor/datafile/xn_index.275.715221723
channel d1: reading from backup piece /local/data/oracle/nfs/XNODBCOR/backupset/2011_11_04/o1_mf_nnndf_BKP_XNODBCOR_FULL_11_7c6rtl40_.bkp
channel d2: starting datafile backup set restore
channel d2: specifying datafile(s) to restore from backup set

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: