RMAN recovery case -- Case of full recovery error (ControlFileError)

RMAN recovery case -- Case of full recovery error (ControlFileError) RMAN recovery case: the user encounters the following error during rman recovery: RMANrestoredatabasefromtagTAG20140923T160003; Start

RMAN recovery case -- Case of full recovery error (ControlFileError) RMAN recovery case: the user encounters the following error during rman recovery: RMANrestoredatabasefromtag = TAG20140923T160003; Start

RMAN recovery case -- Case of full recovery Error (ControlFile Error)

RMAN recovery case:

When recovering rman, the user encounters the following error:

RMAN> restore database from tag = 'tag20140923t160003 ';

Starting restore at destination channel: incluora_disk_1: sid = 156 devtype = destination channel: incluora_disk_2: sid = 147 devtype = DISKchannel ORA_DISK_2: starting datafile backupset restorechannel ORA_DISK_2: specifying datafile (s) to restore from backup setrestoring datafile 00001 to/u01/app/oracle/oradata/prod/system01.dbfrestoring datafile 00004 to/u01/app/oracle/oradata/prod/users01.dbfchannel ORA_DISK_2: reading from backup piece/backup/rman_bak/lv0_PROD_111_859046404.bakchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile (s) to restore from backup setrestoring datafile 00002 to/u01/app/oracle/oradata/prod/export datafile 00003 to/u01/app/oracle/oradata/prod/sysaux01.dbfrestoring datafile 00005 to/u01 /app/oracle/oradata/prod/example01.dbfchannel ORA_DISK_1: reading from backup piece/backup/rman_bak/export ORA_DISK_1: restored backup piece 1 piece handle =/backup/rman_bak/export tag = export ORA_DISK_1: restore complete, elapsed time: 00: 00: 35 channel ORA_DISK_2: restored backup piece 1 piece handle =/backup/rman_bak/container tag = parallel ORA_DISK_2: restore complete, elapsed time: 00: 00: 35 Finished restore at 24-SEP-14

RMAN> recover database;

Starting recover at 24-SEP-14using channel using channel ORA_DISK_2channel ORA_DISK_1: starting incremental datafile backupset restorechannel ORA_DISK_1: specifying datafile (s) to restore from backup setdestination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbfdestination for restore of datafile 00004:/u01/app/oracle/oradata/prod/users01.dbfchannel ORA_DISK_1: reading from backup piece/backup/rman_bak/lvl1_PROD_118_859047306.bakchannel ORA_DISK_2: starting incremental datafile backupset restorechannel ORA_DISK_2: specifying datafile (s) to restore from backup setdestination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbfdestination for restore of datafile 00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbfchannel ORA_DISK_2: reading from backup piece/backup/rman_bak/lvl1_PROD_119_859047306.bakchannel ORA_DISK_1: restored backup piece 1 piece handle =/backup/rman_bak/shard tag = export ORA_DISK_1: restore complete, elapsed time: 00: 00: 01 channel ORA_DISK_1: starting incremental datafile backupset restorechannel ORA_DISK_1: specifying datafile (s) from backup setdestination for restore of datafile 00001:/u01/app/oracle/oradata/prod/system01.dbfdestination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbfchannel ORA_DISK_1: reading from backup piece/backup/rman_bak/lvl1_PROD_125_859048203.bakchannel ORA_DISK_1: restored backup piece 1 piece handle =/backup/rman_bak/shard tag = TAG20140923T163003channel ORA_DISK_1: restore complete, elapsed time: 00: 00: 01 channel ORA_DISK_2: restored backup piece 1 piece handle =/backup/rman_bak/shard tag = export ORA_DISK_2: restore complete, elapsed time: 00: 00: 03 channel ORA_DISK_1: starting incremental datafile backupset restorechannel ORA_DISK_1: specifying datafile (s) from backup setdestination for restore of datafile 00001:/u01/app/oracle/oradata/prod/system01.dbfdestination for restore of datafile 00004: /u01/app/oracle/oradata/prod/MAID: reading from backup piece/backup/rman_bak/FIG: starting incremental datafile backupset restorechannel ORA_DISK_2: specifying datafile (s) to restore from backup setdestination for restore of datafile 00002:/u01/app/oracle/oradata/prod/undotbs01.dbfdestination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbfdestination for restore of datafile 00005:/u01/app/oracle/oradata/prod/example01.dbfchannel ORA_DISK_2: reading from backup piece/backup/rman_bak/export ORA_DISK_1: restored backup piece 1 piece handle =/backup/rman_bak/export tag = export ORA_DISK_1: restore complete, elapsed time: 00: 00: 01 channel ORA_DISK_2: restored backup piece 1 piece handle =/backup/rman_bak/container tag = TAG20140923T163003channel ORA_DISK_2: restore complete, elapsed time: 00: 00: 01 channel ORA_DISK_1: starting incremental datafile backupset restorechannel ORA_DISK_1: specifying datafile (s) to restore from backup setdestination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbfdestination for restore of datafile 00003:/u01/app/oracle/oradata/prod/sysaux01.dbfdestination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbfchannel ORA_DISK_1: reading from backup piece/backup/rman_bak/lvl1_PROD_133_859049103.bakchannel ORA_DISK_1: restored backup piece 1 piece handle =/backup/rman_bak/lvl1_PROD_133_859049103.bak tag = tag20140923t162133channel ORA_DISK_1: restore complete, elapsed time: 00: 00: 01 starting media recoveryarchive log thread 1 sequence 90 is already on disk as file/arch/slow log thread 1 sequence 91 is already on disk as file/arch/12791_858969934.dbfarchive log thread 1 sequence 92 is already on disk as file/disk1/prod/redo01.logarchive log thread 1 sequence 93 is already on disk as file/disk1/prod/redo02.logOracle Error: ORA-01547: warning: RECOVER succeeded but open resetlogs wowould get error belowORA-01152: file 2 was not restored from a sufficiently old backup ORA-01110: data file 2: '/u01/app/oracle/oradata/prod/undotbs01.dbf' RMAN-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03002: failure of recover command at 09/24/2014 17: 34: 18RMAN-06053: unable to perform media recovery because of missing logRMAN-06025: no backup of log thread 1 seq 89 lowscn 647354 found to restoreRMAN-06025: no backup of log thread 1 seq 88 lowscn 647258 found to restoreRMAN-06025: no backup of log thread 1 seq 87 lowscn 647242 found to restoreRMAN-06025: no backup of log thread 1 seq 86 lowscn 646972 found to restoreRMAN-06025: no backup of log thread 1 seq 85 lowscn 646637 found to restoreRMAN-06025: no backup of log thread 1 seq 84 lowscn 646623 found to restoreRMAN-06025: no backup of log thread 1 seq 83 lowscn 646593 found to restoreRMAN-06025: no backup of log thread 1 seq 82 lowscn 645884 found to restoreRMAN-06025: no backup of log thread 1 seq 81 lowscn 645864 found to restoreRMAN-06025: no backup of log thread 1 seq 80 lowscn 645835 found to restoreRMAN-06025: no backup of log thread 1 seq 79 lowscn 645431 found to restoreRMAN-06025: no backup of log thread 1 seq 78 lowscn 645415 found to restore

Recovery failed. The error message "undo tablespace recover failure" is displayed!

View alarm logs: