RMAN恢复案例之--完全恢复错误案例(备份Error）

t4fewq

RMAN恢复案例：
用户在做rman的恢复时遇到以下错误：
RMAN> restore database from tag='TAG20140923T160003';

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Starting restore at 24-SEP-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=156 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=147 devtype=DISK channel ORA_DISK_2: starting datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/app/oracle/oradata/prod/system01.dbf restoring datafile 00004 to /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lv0_PROD_111_859046404.bak channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00002 to /u01/app/oracle/oradata/prod/undotbs01.dbf restoring datafile 00003 to /u01/app/oracle/oradata/prod/sysaux01.dbf restoring datafile 00005 to /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lv0_PROD_112_859046404.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lv0_PROD_112_859046404.bak tag=TAG20140923T160003 channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lv0_PROD_111_859046404.bak tag=TAG20140923T160003 channel ORA_DISK_2: restore complete, elapsed time: 00:00:35 Finished restore at 24-SEP-14

RMAN> recover database;

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80

Starting recover at 24-SEP-14 using channel ORA_DISK_1 using channel ORA_DISK_2 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbf destination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_118_859047306.bak channel ORA_DISK_2: starting incremental datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set destination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbf destination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbf destination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lvl1_PROD_119_859047306.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_118_859047306.bak tag=TAG20140923T161506 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbf destination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_125_859048203.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_125_859048203.bak tag=TAG20140923T163003 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_119_859047306.bak tag=TAG20140923T161506 channel ORA_DISK_2: restore complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbf destination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_132_859049103.bak channel ORA_DISK_2: starting incremental datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set destination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbf destination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbf destination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lvl1_PROD_126_859048203.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_132_859049103.bak tag=TAG20140923T164503 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_126_859048203.bak tag=TAG20140923T163003 channel ORA_DISK_2: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbf destination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbf destination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_133_859049103.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_133_859049103.bak tag=TAG20140923T164503 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 starting media recovery archive log thread 1 sequence 90 is already on disk as file /arch/1_90_858969934.dbf archive log thread 1 sequence 91 is already on disk as file /arch/1_91_858969934.dbf archive log thread 1 sequence 92 is already on disk as file /disk1/prod/redo01.log archive log thread 1 sequence 93 is already on disk as file /disk1/prod/redo02.log Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-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:18 RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of log thread 1 seq 89 lowscn 647354 found to restore RMAN-06025: no backup of log thread 1 seq 88 lowscn 647258 found to restore RMAN-06025: no backup of log thread 1 seq 87 lowscn 647242 found to restore RMAN-06025: no backup of log thread 1 seq 86 lowscn 646972 found to restore RMAN-06025: no backup of log thread 1 seq 85 lowscn 646637 found to restore RMAN-06025: no backup of log thread 1 seq 84 lowscn 646623 found to restore RMAN-06025: no backup of log thread 1 seq 83 lowscn 646593 found to restore RMAN-06025: no backup of log thread 1 seq 82 lowscn 645884 found to restore RMAN-06025: no backup of log thread 1 seq 81 lowscn 645864 found to restore RMAN-06025: no backup of log thread 1 seq 80 lowscn 645835 found to restore RMAN-06025: no backup of log thread 1 seq 79 lowscn 645431 found to restore RMAN-06025: no backup of log thread 1 seq 78 lowscn 645415 found to restore

恢复失败，提示undo tablespace  recover failure！
查看告警日志：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93

The input backup piece /backup/rman_bak/lv0_PROD_111_859046404.bak is in compressed format. Wed Sep 24 17:32:41 2014 The input backup piece /backup/rman_bak/lv0_PROD_112_859046404.bak is in compressed format. Wed Sep 24 17:32:42 2014 Full restore complete of datafile 4 /u01/app/oracle/oradata/prod/users01.dbf.  Elapsed time: 0:00:01   checkpoint is 642397 Wed Sep 24 17:32:48 2014 Full restore complete of datafile 2 /u01/app/oracle/oradata/prod/undotbs01.dbf.  Elapsed time: 0:00:07   checkpoint is 642399 Wed Sep 24 17:33:02 2014 Full restore complete of datafile 5 /u01/app/oracle/oradata/prod/example01.dbf.  Elapsed time: 0:00:20   checkpoint is 642399 Full restore complete of datafile 3 /u01/app/oracle/oradata/prod/sysaux01.dbf.  Elapsed time: 0:00:25   checkpoint is 642399 Wed Sep 24 17:33:14 2014 Full restore complete of datafile 1 /u01/app/oracle/oradata/prod/system01.dbf.  Elapsed time: 0:00:33   checkpoint is 642397 Wed Sep 24 17:34:12 2014 The input backup piece /backup/rman_bak/lvl1_PROD_118_859047306.bak is in compressed format. Wed Sep 24 17:34:12 2014 The input backup piece /backup/rman_bak/lvl1_PROD_119_859047306.bak is in compressed format. Wed Sep 24 17:34:13 2014 Incremental restore complete of datafile 4 /u01/app/oracle/oradata/prod/users01.dbf   checkpoint is 642881 Wed Sep 24 17:34:13 2014 Incremental restore complete of datafile 5 /u01/app/oracle/oradata/prod/example01.dbf   checkpoint is 642883 Wed Sep 24 17:34:13 2014 Incremental restore complete of datafile 1 /u01/app/oracle/oradata/prod/system01.dbf   checkpoint is 642881 Wed Sep 24 17:34:13 2014 Incremental restore complete of datafile 2 /u01/app/oracle/oradata/prod/undotbs01.dbf   checkpoint is 642883 Wed Sep 24 17:34:14 2014 The input backup piece /backup/rman_bak/lvl1_PROD_125_859048203.bak is in compressed format. Incremental restore complete of datafile 4 /u01/app/oracle/oradata/prod/users01.dbf   checkpoint is 643340 Wed Sep 24 17:34:14 2014 Incremental restore complete of datafile 3 /u01/app/oracle/oradata/prod/sysaux01.dbf   checkpoint is 642883 Wed Sep 24 17:34:14 2014 Incremental restore complete of datafile 1 /u01/app/oracle/oradata/prod/system01.dbf   checkpoint is 643340 The input backup piece /backup/rman_bak/lvl1_PROD_132_859049103.bak is in compressed format. Wed Sep 24 17:34:15 2014 The input backup piece /backup/rman_bak/lvl1_PROD_126_859048203.bak is in compressed format. Wed Sep 24 17:34:15 2014 Incremental restore complete of datafile 4 /u01/app/oracle/oradata/prod/users01.dbf   checkpoint is 643737 Wed Sep 24 17:34:15 2014 Incremental restore complete of datafile 5 /u01/app/oracle/oradata/prod/example01.dbf   checkpoint is 643342 Wed Sep 24 17:34:15 2014 Incremental restore complete of datafile 1 /u01/app/oracle/oradata/prod/system01.dbf   checkpoint is 643737 Wed Sep 24 17:34:15 2014 Incremental restore complete of datafile 3 /u01/app/oracle/oradata/prod/sysaux01.dbf   checkpoint is 643342 Incremental restore complete of datafile 2 /u01/app/oracle/oradata/prod/undotbs01.dbf   checkpoint is 643342 Wed Sep 24 17:34:16 2014 The input backup piece /backup/rman_bak/lvl1_PROD_133_859049103.bak is in compressed format. Incremental restore complete of datafile 5 /u01/app/oracle/oradata/prod/example01.dbf   checkpoint is 643739 Incremental restore complete of datafile 3 /u01/app/oracle/oradata/prod/sysaux01.dbf   checkpoint is 643739 Incremental restore complete of datafile 2 /u01/app/oracle/oradata/prod/undotbs01.dbf   checkpoint is 643739 Wed Sep 24 17:34:17 2014 alter database recover datafile list clear Wed Sep 24 17:34:17 2014 Completed: alter database recover datafile list clear Wed Sep 24 17:34:17 2014 alter database recover datafile list 1 , 2 , 3 , 4 , 5 Completed: alter database recover datafile list 1 , 2 , 3 , 4 , 5 Wed Sep 24 17:34:17 2014 alter database recover if needed start until cancel using backup controlfile Media Recovery Start parallel recovery started with 3 processes ORA-279 signalled during: alter database recover if needed start until cancel using backup controlfile ... Wed Sep 24 17:34:18 2014 alter database recover cancel Signalling error 1152 for datafile 2! ORA-1547 signalled during: alter database recover cancel... Wed Sep 24 17:34:56 2014 control file header validation failure for file /backup/rman_bak/ctl1_166.bak Wed Sep 24 17:35:53 2014 The input backup piece /backup/rman_bak/ctl1_166.bak is in compressed format.

解决方法：

通过备份的controlfile进行恢复

RMAN> list backup of controlfile;
但是通过rman查看备份的controlfile信息时，却没有！
还好，在磁盘上找到一个控制文件的backup piece！
加载到rman metadata中：
RMAN> catalog backuppiece '/backup/rman_bak/ctl1_166.bak';

1 2	cataloged backuppiece backup piece handle=/backup/rman_bak/ctl1_166.bak recid=191 stamp=859138553

RMAN> list backup of controlfile;

1 2 3 4 5 6 7 8

List of Backup Sets =================== BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 162     Full    1.06M      DISK        00:00:01     23-SEP-14               BP Key: 191   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T174510         Piece Name: /backup/rman_bak/ctl1_166.bak   Control File Included: Ckp SCN: 645423       Ckp time: 23-SEP-14

查看备份信息：
RMAN> list backup of database ;

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170

List of Backup Sets =================== BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 107     Incr 0  36.22M     DISK        00:06:19     23-SEP-14               BP Key: 107   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T160003         Piece Name: /backup/rman_bak/lv0_PROD_112_859046404.bak   List of Datafiles in backup set 107   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    0  Incr 642399     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    0  Incr 642399     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    0  Incr 642399     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 108     Incr 0  81.68M     DISK        00:06:30     23-SEP-14               BP Key: 108   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T160003         Piece Name: /backup/rman_bak/lv0_PROD_111_859046404.bak   List of Datafiles in backup set 108   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    0  Incr 642397     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    0  Incr 642397     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 114     Incr 1  216.00K    DISK        00:00:01     23-SEP-14               BP Key: 114   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T161506         Piece Name: /backup/rman_bak/lvl1_PROD_118_859047306.bak   List of Datafiles in backup set 114   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    1  Incr 642881     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    1  Incr 642881     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 115     Incr 1  1.09M      DISK        00:00:05     23-SEP-14               BP Key: 115   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T161506         Piece Name: /backup/rman_bak/lvl1_PROD_119_859047306.bak   List of Datafiles in backup set 115   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    1  Incr 642883     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    1  Incr 642883     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    1  Incr 642883     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 121     Incr 1  168.00K    DISK        00:00:01     23-SEP-14               BP Key: 121   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T163003         Piece Name: /backup/rman_bak/lvl1_PROD_125_859048203.bak   List of Datafiles in backup set 121   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    1  Incr 643340     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    1  Incr 643340     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 122     Incr 1  240.00K    DISK        00:00:01     23-SEP-14               BP Key: 122   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T163003         Piece Name: /backup/rman_bak/lvl1_PROD_126_859048203.bak   List of Datafiles in backup set 122   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    1  Incr 643342     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    1  Incr 643342     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    1  Incr 643342     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 128     Incr 1  192.00K    DISK        00:00:01     23-SEP-14               BP Key: 128   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T164503         Piece Name: /backup/rman_bak/lvl1_PROD_132_859049103.bak   List of Datafiles in backup set 128   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    1  Incr 643737     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    1  Incr 643737     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 129     Incr 1  240.00K    DISK        00:00:01     23-SEP-14               BP Key: 129   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T164503         Piece Name: /backup/rman_bak/lvl1_PROD_133_859049103.bak   List of Datafiles in backup set 129   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    1  Incr 643739     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    1  Incr 643739     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    1  Incr 643739     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 135     Incr 0  36.26M     DISK        00:01:40     23-SEP-14               BP Key: 135   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T170004         Piece Name: /backup/rman_bak/lv0_PROD_140_859050004.bak   List of Datafiles in backup set 135   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    0  Incr 644121     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    0  Incr 644121     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    0  Incr 644121     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 138     Incr 0  81.69M     DISK        00:02:18     23-SEP-14               BP Key: 138   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T170004         Piece Name: /backup/rman_bak/lv0_PROD_139_859050004.bak   List of Datafiles in backup set 138   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    0  Incr 644119     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    0  Incr 644119     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 142     Incr 1  112.00K    DISK        00:00:01     23-SEP-14               BP Key: 142   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T171504         Piece Name: /backup/rman_bak/lvl1_PROD_146_859050904.bak   List of Datafiles in backup set 142   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    1  Incr 644562     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    1  Incr 644562     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 143     Incr 1  1.09M      DISK        00:00:02     23-SEP-14               BP Key: 143   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T171504         Piece Name: /backup/rman_bak/lvl1_PROD_147_859050904.bak   List of Datafiles in backup set 143   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    1  Incr 644564     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    1  Incr 644564     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    1  Incr 644564     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 149     Incr 1  152.00K    DISK        00:00:01     23-SEP-14               BP Key: 149   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T173003         Piece Name: /backup/rman_bak/lvl1_PROD_153_859051804.bak   List of Datafiles in backup set 149   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    1  Incr 645007     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    1  Incr 645007     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 150     Incr 1  240.00K    DISK        00:00:01     23-SEP-14               BP Key: 150   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T173003         Piece Name: /backup/rman_bak/lvl1_PROD_154_859051804.bak   List of Datafiles in backup set 150   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    1  Incr 645009     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    1  Incr 645009     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    1  Incr 645009     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 156     Incr 1  232.00K    DISK        00:00:01     23-SEP-14               BP Key: 156   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T174503         Piece Name: /backup/rman_bak/lvl1_PROD_161_859052703.bak   List of Datafiles in backup set 156   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   2    1  Incr 645407     23-SEP-14 /u01/app/oracle/oradata/prod/undotbs01.dbf   3    1  Incr 645407     23-SEP-14 /u01/app/oracle/oradata/prod/sysaux01.dbf   5    1  Incr 645407     23-SEP-14 /u01/app/oracle/oradata/prod/example01.dbf BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 157     Incr 1  128.00K    DISK        00:00:01     23-SEP-14               BP Key: 157   Status: AVAILABLE  Compressed: YES  Tag: TAG20140923T174503         Piece Name: /backup/rman_bak/lvl1_PROD_160_859052703.bak   List of Datafiles in backup set 157   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1    1  Incr 645405     23-SEP-14 /u01/app/oracle/oradata/prod/system01.dbf   4    1  Incr 645405     23-SEP-14 /u01/app/oracle/oradata/prod/users01.dbf

控制文件的备份是在9月23日，17：45分，选择9月23日17：00的0级数据文件备份进行数据文件的转储！

  
转储控制文件：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

RMAN> shutdown abort; Oracle instance shut down RMAN> startup nomount; connected to target database (not started) Oracle instance started Total System Global Area     570425344 bytes Fixed Size                     2022480 bytes Variable Size                184550320 bytes Database Buffers             377487360 bytes Redo Buffers                   6365184 bytes RMAN> restore controlfile from '/backup/rman_bak/ctl1_166.bak'; Starting restore at 24-SEP-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=156 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=155 devtype=DISK channel ORA_DISK_2: skipped, autobackup already found channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:11 output filename=/u01/app/oracle/oradata/prod/control01.ctl output filename=/disk1/prod/control02.ctl output filename=/disk2/prod/control03.ctl Finished restore at 24-SEP-14

转储数据文件：
RMAN> alter database mount;

1 2 3

database mounted released channel: ORA_DISK_1 released channel: ORA_DISK_2

RMAN> restore database from tag='TAG20140923T170004';

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Starting restore at 24-SEP-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=155 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=156 devtype=DISK channel ORA_DISK_2: starting datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/app/oracle/oradata/prod/system01.dbf restoring datafile 00004 to /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lv0_PROD_139_859050004.bak channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00002 to /u01/app/oracle/oradata/prod/undotbs01.dbf restoring datafile 00003 to /u01/app/oracle/oradata/prod/sysaux01.dbf restoring datafile 00005 to /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lv0_PROD_140_859050004.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lv0_PROD_140_859050004.bak tag=TAG20140923T170004 channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lv0_PROD_139_859050004.bak tag=TAG20140923T170004 channel ORA_DISK_2: restore complete, elapsed time: 00:00:35 Finished restore at 24-SEP-14

查看转储后的数据文件和控制文件的checkpoint：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

SQL> col name for a50 SQL> r   1* select name ,checkpoint_change# from v$datafile NAME                                               CHECKPOINT_CHANGE# -------------------------------------------------- ------------------ /u01/app/oracle/oradata/prod/system01.dbf                      645405 /u01/app/oracle/oradata/prod/undotbs01.dbf                     645407 /u01/app/oracle/oradata/prod/sysaux01.dbf                      645407 /u01/app/oracle/oradata/prod/users01.dbf                       645405 /u01/app/oracle/oradata/prod/example01.dbf                     645407 SQL> select name ,checkpoint_change# from v$datafile_header; NAME                                               CHECKPOINT_CHANGE# -------------------------------------------------- ------------------ /u01/app/oracle/oradata/prod/system01.dbf                      644119 /u01/app/oracle/oradata/prod/undotbs01.dbf                     644121 /u01/app/oracle/oradata/prod/sysaux01.dbf                      644121 /u01/app/oracle/oradata/prod/users01.dbf                       644119 /u01/app/oracle/oradata/prod/example01.dbf                     644121

对database做recover：
RMAN> recover database;

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72

Starting recover at 24-SEP-14 using channel ORA_DISK_1 using channel ORA_DISK_2 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbf destination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_146_859050904.bak channel ORA_DISK_2: starting incremental datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set destination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbf destination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbf destination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lvl1_PROD_147_859050904.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_146_859050904.bak tag=TAG20140923T171504 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbf destination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_153_859051804.bak channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_147_859050904.bak tag=TAG20140923T171504 channel ORA_DISK_2: restore complete, elapsed time: 00:00:02 channel ORA_DISK_2: starting incremental datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set destination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbf destination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbf destination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lvl1_PROD_154_859051804.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_153_859051804.bak tag=TAG20140923T173003 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_154_859051804.bak tag=TAG20140923T173003 channel ORA_DISK_2: restore complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /u01/app/oracle/oradata/prod/system01.dbf destination for restore of datafile 00004: /u01/app/oracle/oradata/prod/users01.dbf channel ORA_DISK_1: reading from backup piece /backup/rman_bak/lvl1_PROD_160_859052703.bak channel ORA_DISK_2: starting incremental datafile backupset restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set destination for restore of datafile 00002: /u01/app/oracle/oradata/prod/undotbs01.dbf destination for restore of datafile 00003: /u01/app/oracle/oradata/prod/sysaux01.dbf destination for restore of datafile 00005: /u01/app/oracle/oradata/prod/example01.dbf channel ORA_DISK_2: reading from backup piece /backup/rman_bak/lvl1_PROD_161_859052703.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_160_859052703.bak tag=TAG20140923T174503 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_2: restored backup piece 1 piece handle=/backup/rman_bak/lvl1_PROD_161_859052703.bak tag=TAG20140923T174503 channel ORA_DISK_2: restore complete, elapsed time: 00:00:01 starting media recovery archive log thread 1 sequence 92 is already on disk as file /disk1/prod/redo01.log archive log thread 1 sequence 93 is already on disk as file /disk1/prod/redo02.log channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=77 channel ORA_DISK_1: reading from backup piece /backup/rman_bak/arch1_165.bak channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman_bak/arch1_165.bak tag=TAG20140923T174507 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 archive log filename=/arch/1_77_858969934.dbf thread=1 sequence=77 unable to find archive log archive log thread=1 sequence=78 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 09/24/2014 17:44:48 RMAN-06054: media recovery requesting unknown log: thread 1 seq 78 lowscn 645415

recover failure，提示缺少archivelog ，做不完全恢复！

1 2 3 4 5 6 7 8 9 10 11

RMAN> run { 2> set until sequence 78; 3> recover database; 4> } executing command: SET until clause Starting recover at 24-SEP-14 using channel ORA_DISK_1 using channel ORA_DISK_2 starting media recovery media recovery complete, elapsed time: 00:00:01 Finished recover at 24-SEP-14

recover完成！
查看恢复后的database checkpoint：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

SQL> select name ,checkpoint_change# from v$datafile; NAME                                               CHECKPOINT_CHANGE# -------------------------------------------------- ------------------ /u01/app/oracle/oradata/prod/system01.dbf                      645415 /u01/app/oracle/oradata/prod/undotbs01.dbf                     645415 /u01/app/oracle/oradata/prod/sysaux01.dbf                      645415 /u01/app/oracle/oradata/prod/users01.dbf                       645415 /u01/app/oracle/oradata/prod/example01.dbf                     645415 SQL> select name ,checkpoint_change# from v$datafile_header; NAME                                               CHECKPOINT_CHANGE# -------------------------------------------------- ------------------ /u01/app/oracle/oradata/prod/system01.dbf                      645415 /u01/app/oracle/oradata/prod/undotbs01.dbf                     645415 /u01/app/oracle/oradata/prod/sysaux01.dbf                      645415 /u01/app/oracle/oradata/prod/users01.dbf                       645415 /u01/app/oracle/oradata/prod/example01.dbf                     645415

打开数据库：
RMAN> alter database open resetlogs;
database opened
@数据库open成功，至此，数据库恢复完成！