RMAN Backup, no backup of copy of DataFile

During the Rman machine recovery process, I first made an incomplete recovery, and then recovered when prompted by the error:

Starting restore at 29-dec-15

Using channel Ora_disk_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============

RMAN-00571: ===========================================================

Rman-03002:failure of Restore command at 12/29/2015 16:56:34

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

Check the backup file, the discovery is there, there is no problem at all. The final check was incarnation, because I did an incomplete recovery of the database and did a resetlogs operation.

Workaround:

List of Database incarnations

DB Key Inc key DB Name db ID STATUS reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 1 cwerpdb 490184294 PARENT 1 24-aug-13

2 2 cwerpdb 490184294 PARENT 925702 27-jul-15

3 3 cwerpdb 490184294 current 12939483587242 24-dec-15

Rman> Reset database to incarnation 2;

Database Reset to incarnation 2

Run

{Set newname for datafile 4 to "/home/u01/oracle/oradata/cwerpdb/users.259.886161065";

Set newname for DataFile 3 to "/home/u01/oracle/oradata/cwerpdb/undotbs1.258.886161065";

Set newname for datafile 2 to "/home/u01/oracle/oradata/cwerpdb/sysaux.257.886161065";

Set newname for datafile 1 to "/home/u01/oracle/oradata/cwerpdb/system.256.886161065";

Set newname for datafile 5 to "/home/u01/oracle/oradata/cwerpdb/proframe.dbf";

Set newname for datafile 6 to "/home/u01/oracle/oradata/cwerpdb/proframe01.dbf";

Set newname for datafile 7 to "/HOME/U01/ORACLE/ORADATA/CWERPDB/COSMOS_IN01.DBF";

Set newname for DataFile 8 to "/home/u01/oracle/oradata/cwerpdb/cosmos_in02.dbf";

Set newname for DataFile 9 to "/home/u01/oracle/oradata/cwerpdb/cosmos_in03.dbf";

Set newname for DataFile "/HOME/U01/ORACLE/ORADATA/CWERPDB/COSMOS01.DBF";

Set newname for datafile one to "/home/u01/oracle/oradata/cwerpdb/cosmos02.dbf";

Set newname for DataFile "/HOME/U01/ORACLE/ORADATA/CWERPDB/COSMOS03.DBF";

Set newname for DataFile "/HOME/U01/ORACLE/ORADATA/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01. DBF ";

Set newname for DataFile "/HOME/U01/ORACLE/ORADATA/CWERPDB/STATLOG.DBF";

Restore database;

3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> switch datafile all;}

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Executing Command:set NEWNAME

Starting restore at 29-dec-15

Using channel Ora_disk_1

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00008 to/home/u01/oracle/oradata/cwerpdb/cosmos_in02.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3iqq1v45_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3iqq1v45_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:35

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00009 to/home/u01/oracle/oradata/cwerpdb/cosmos_in03.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3jqq1v45_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3jqq1v45_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:35

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00010 to/home/u01/oracle/oradata/cwerpdb/cosmos01.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3kqq1v48_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3kqq1v48_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:45

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00011 to/home/u01/oracle/oradata/cwerpdb/cosmos02.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3lqq1v48_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3lqq1v48_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:35

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00012 to/home/u01/oracle/oradata/cwerpdb/cosmos03.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3mqq1v4n_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3mqq1v4n_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:05

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00007 to/home/u01/oracle/oradata/cwerpdb/cosmos_in01.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3oqq1v4v_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3oqq1v4v_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:05

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00005 to/home/u01/oracle/oradata/cwerpdb/proframe.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3nqq1v4n_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3nqq1v4n_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:07:05

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00006 to/home/u01/oracle/oradata/cwerpdb/proframe01.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3pqq1v52_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3pqq1v52_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:06:25

Channel ora_disk_1:starting datafile backup set restore

Channel ora_disk_1:specifying DataFile (s) to the restore from backup set

Channel ora_disk_1:restoring datafile 00001 to/home/u01/oracle/oradata/cwerpdb/system.256.886161065

Channel ora_disk_1:restoring datafile 00002 to/home/u01/oracle/oradata/cwerpdb/sysaux.257.886161065

Channel ora_disk_1:restoring datafile 00003 to/home/u01/oracle/oradata/cwerpdb/undotbs1.258.886161065

Channel ora_disk_1:restoring datafile 00004 to/home/u01/oracle/oradata/cwerpdb/users.259.886161065

Channel ora_disk_1:restoring datafile 00013 to/home/u01/oracle/oradata/cwerpdb/apporacleoradatapgscmexample01. Dbf

Channel ora_disk_1:restoring datafile 00014 to/home/u01/oracle/oradata/cwerpdb/statlog.dbf

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/data_3qqq1vfr_1_1.bak

Channel Ora_disk_1:piece Handle=/home/oracle/level0/data_3qqq1vfr_1_1.bak tag=db0

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:02:15

Finished restore at 29-dec-15

DataFile 1 switched to datafile copy

Input datafile copy recid=15 stamp=899746532 file name=/home/u01/oracle/oradata/cwerpdb/system.256.886161065

DataFile 2 switched to datafile copy

Input datafile copy recid=16 stamp=899746532 file name=/home/u01/oracle/oradata/cwerpdb/sysaux.257.886161065

DataFile 3 switched to datafile copy

Input datafile copy recid=17 stamp=899746532 file name=/home/u01/oracle/oradata/cwerpdb/undotbs1.258.886161065

DataFile 4 switched to datafile copy

Input datafile copy recid=18 stamp=899746532 file name=/home/u01/oracle/oradata/cwerpdb/users.259.886161065

DataFile 5 switched to datafile copy

Input datafile copy recid=19 stamp=899746532 file name=/home/u01/oracle/oradata/cwerpdb/proframe.dbf

DataFile 6 switched to datafile copy

Input datafile copy recid=20 stamp=899746532 file name=/home/u01/oracle/oradata/cwerpdb/proframe01.dbf

DataFile 7 switched to datafile copy

Input datafile copy recid=21 stamp=899746533 file name=/home/u01/oracle/oradata/cwerpdb/cosmos_in01.dbf

DataFile 8 switched to datafile copy

Input datafile copy recid=22 stamp=899746533 file name=/home/u01/oracle/oradata/cwerpdb/cosmos_in02.dbf

DataFile 9 switched to datafile copy

Input datafile copy recid=23 stamp=899746533 file name=/home/u01/oracle/oradata/cwerpdb/cosmos_in03.dbf

DataFile switched to datafile copy

Input datafile copy recid=24 stamp=899746533 file name=/home/u01/oracle/oradata/cwerpdb/cosmos01.dbf

DataFile switched to datafile copy

Input datafile copy recid=25 stamp=899746533 file name=/home/u01/oracle/oradata/cwerpdb/cosmos02.dbf

DataFile switched to datafile copy

Input datafile copy recid=26 stamp=899746534 file name=/home/u01/oracle/oradata/cwerpdb/cosmos03.dbf

DataFile switched to datafile copy

Input datafile copy recid=27 stamp=899746534 file name=/home/u01/oracle/oradata/cwerpdb/ APPORACLEORADATAPGSCMEXAMPLE01. Dbf

DataFile switched to datafile copy

Input datafile copy recid=28 stamp=899746534 file name=/home/u01/oracle/oradata/cwerpdb/statlog.dbf

rman> ALTER DATABASE open;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============

RMAN-00571: ===========================================================

Rman-03002:failure of Alter DB command at 12/29/2015 17:36:35

Ora-01589:must use Resetlogs or noresetlogs option for database open

rman> ALTER DATABASE open resetlogs;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============

RMAN-00571: ===========================================================

Rman-03002:failure of Alter DB command at 12/29/2015 17:36:42

Ora-01152:file 5 was wasn't restored from a sufficiently old backup

Ora-01110:data file 5: '/HOME/U01/ORACLE/ORADATA/CWERPDB/PROFRAME.DBF '

rman> Recover database;

Starting recover at 29-dec-15

Using channel Ora_disk_1

Starting Media recovery

Channel ora_disk_1:starting archived log restore to default destination

Channel ora_disk_1:restoring archived Log

Archived Log thread=1 sequence=2710

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/arc_cwerpdbx_20151229_3tqq1vj0_1_1

Channel Ora_disk_1:piece Handle=/home/oracle/level0/arc_cwerpdbx_20151229_3tqq1vj0_1_1 tag=TAG20151229T164208

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:00:01

Archived log File name=/home/u01/oracle/fast_recovery_area/cwerpdb/cwerpdb/archivelog/2015_12_29/o1_mf_1_2710_ C84o213s_.arc thread=1 sequence=2710

Channel default:deleting archived log (s)

Archived log File name=/home/u01/oracle/fast_recovery_area/cwerpdb/cwerpdb/archivelog/2015_12_29/o1_mf_1_2710_ C84o213s_.arc recid=2730 stamp=899746625

Channel ora_disk_1:starting archived log restore to default destination

Channel ora_disk_1:restoring archived Log

Archived Log thread=1 sequence=2711

Channel ora_disk_1:reading from backup Piece/home/oracle/level0/arc_cwerpdbx_20151229_3uqq1vj0_1_1

Channel Ora_disk_1:piece Handle=/home/oracle/level0/arc_cwerpdbx_20151229_3uqq1vj0_1_1 tag=TAG20151229T164208

Channel ora_disk_1:restored backup Piece 1

Channel Ora_disk_1:restore complete, elapsed time:00:00:01

Archived log File name=/home/u01/oracle/fast_recovery_area/cwerpdb/cwerpdb/archivelog/2015_12_29/o1_mf_1_2711_ C84o23go_.arc thread=1 sequence=2711

Channel default:deleting archived log (s)

Archived log File name=/home/u01/oracle/fast_recovery_area/cwerpdb/cwerpdb/archivelog/2015_12_29/o1_mf_1_2711_ C84o23go_.arc recid=2731 stamp=899746627

Unable to find archived log

Archived Log thread=1 sequence=2712

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============

RMAN-00571: ===========================================================

Rman-03002:failure of recover command at 12/29/2015 17:37:09

Rman-06054:media recovery requesting unknown archived log for thread 1 with sequence 2712 and starting SCN of 12939484174 407

rman> ALTER DATABASE open resetlogs;

Database opened

RMAN Backup, no backup of copy of DataFile