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
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
No comments:
Post a Comment