RMAN backup, no backup of copy of datafile
In the process of RMAN off-machine recovery, I first made an incomplete recovery, and then prompted an error when I recovered:
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 files and find that they all exist and there is no problem at all. Finally, the check found that it was the problem with incarnation, because I did an incomplete recovery of the database and did a resetlogs operation.
Solution:
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 10 to "/ home/u01/oracle/oradata/CWERPDB/cosmos01.dbf"
Set newname for datafile 11 to "/ home/u01/oracle/oradata/CWERPDB/cosmos02.dbf"
Set newname for datafile 12 to "/ home/u01/oracle/oradata/CWERPDB/cosmos03.dbf"
Set newname for datafile 13 to "/ home/u01/oracle/oradata/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01.DBF"
Set newname for datafile 14 to "/ 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 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 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 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 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 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 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 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 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 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 10 switched to datafile copy
Input datafile copy RECID=24 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos01.dbf
Datafile 11 switched to datafile copy
Input datafile copy RECID=25 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos02.dbf
Datafile 12 switched to datafile copy
Input datafile copy RECID=26 STAMP=899746534 file name=/home/u01/oracle/oradata/CWERPDB/cosmos03.dbf
Datafile 13 switched to datafile copy
Input datafile copy RECID=27 STAMP=899746534 file name=/home/u01/oracle/oradata/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01.DBF
Datafile 14 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 not 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 12939484174407
RMAN > alter database open resetlogs
Database opened
