Search This Blog

Friday, March 7, 2014

RMAN-06026: some targets not found - aborting restore & RMAN-03002 while restoring

While doing restore database I got below errors:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/07/2014 22:17:33
RMAN-06026: some targets not found - aborting restore

Cause: I unexpectedly RMAN> catalog start with '/nfs/orafra/prod/PROD_C/backupset/2014_03_08/' noprompt; which is not yet available

It cataloged very old files as below

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /nfs/orafra/webdb0/STG3/archivelog/PROD/archivelog/2013_10_11/o1_mf_1_1_95kgmq5h_.arc
File Name: /nfs/orafra/webdb0/STG3/archivelog/PROD/autobackup/2013_10_11/o1_mf_n_828561497_95kgpty2_.bkp

searching for all files that match the pattern /nfs/orafra/prod/PROD_C/backupset/2014_03_08/
no files found to be unknown to the database


Trying to restore the data base using below commands and got mentioned errors

RUN {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
restore database;
recover database;
release channel d1;
release channel d2;
release channel d3;
release channel d4;

}
exit;

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 03/07/2014 22:17:33
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 79 found to restore
RMAN-06023: no backup or copy of datafile 78 found to restore





Solution Followed:


RMAN> list incarnation of database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       PROD 3555113110       PARENT  8242472798304 24-JUL-09
2       2       PROD 3555113110       PARENT  8242490168035 25-JUL-09
3       3     PROD 3555113110       PARENT  8506956585999 03-OCT-13
4       4     PROD 3555113110       CURRENT 8507435956232 11-OCT-13

RMAN> reset database to incarnation 3;

database reset to incarnation 3

RMAN> list incarnation of database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1    PROD 3555113110       PARENT  8242472798304 24-JUL-09
2       2      PROD 3555113110       PARENT  8242490168035 25-JUL-09
3       3       PROD 3555113110       CURRENT 8506956585999 03-OCT-13
4       4     PROD 3555113110       ORPHAN  8507435956232 11-OCT-13

RMAN> exit
and initiated the restore with no issues



 

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...