RMAN恢复案例之--完全恢复错误案例(ControlFileError）RMAN恢复案例：用户在做rman的恢复时遇到以下错误：RMANrestoredatabasefromtag=TAG20140923T160003;Start
RMAN恢复案例之--完全恢复错误案例(ControlFile Error）
RMAN恢复案例：
用户在做rman的恢复时遇到以下错误：
RMAN> restore database from tag='TAG20140923T160003';
Starting restore at 24-SEP-14allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=156 devtype=DISKallocated channel: ORA_DISK_2channel ORA_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/undotbs01.dbfrestoring 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/lv0_PROD_112_859046404.bakchannel ORA_DISK_1: restored backup piece 1piece handle=/backup/rman_bak/lv0_PROD_112_859046404.bak tag=TAG20140923T160003channel ORA_DISK_1: restore complete, elapsed time: 00:00:35channel ORA_DISK_2: restored backup piece 1piece handle=/backup/rman_bak/lv0_PROD_111_859046404.bak tag=TAG20140923T160003channel ORA_DISK_2: restore complete, elapsed time: 00:00:35Finished restore at 24-SEP-14RMAN> recover database;
Starting recover at 24-SEP-14using channel ORA_DISK_1using 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 1piece handle=/backup/rman_bak/lvl1_PROD_118_859047306.bak tag=TAG20140923T161506channel ORA_DISK_1: restore complete, elapsed time: 00:00:01channel 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_125_859048203.bakchannel ORA_DISK_1: restored backup piece 1piece handle=/backup/rman_bak/lvl1_PROD_125_859048203.bak tag=TAG20140923T163003channel ORA_DISK_1: restore complete, elapsed time: 00:00:01channel ORA_DISK_2: restored backup piece 1piece handle=/backup/rman_bak/lvl1_PROD_119_859047306.bak tag=TAG20140923T161506channel ORA_DISK_2: restore complete, elapsed time: 00:00:03channel 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_132_859049103.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_126_859048203.bakchannel ORA_DISK_1: restored backup piece 1piece handle=/backup/rman_bak/lvl1_PROD_132_859049103.bak tag=TAG20140923T164503channel ORA_DISK_1: restore complete, elapsed time: 00:00:01channel ORA_DISK_2: restored backup piece 1piece handle=/backup/rman_bak/lvl1_PROD_126_859048203.bak tag=TAG20140923T163003channel ORA_DISK_2: restore complete, elapsed time: 00:00:01channel 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 1piece handle=/backup/rman_bak/lvl1_PROD_133_859049103.bak tag=TAG20140923T164503channel ORA_DISK_1: restore complete, elapsed time: 00:00:01starting media recoveryarchive log thread 1 sequence 90 is already on disk as file /arch/1_90_858969934.dbfarchive log thread 1 sequence 91 is already on disk as file /arch/1_91_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 would 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恢复失败，提示undo tablespace recover failure！
查看告警日志：