RMAN恢復案例之--完全恢復錯誤案例（ControlFileError）
Jun 07, 2016 pm 02:53 PM
RMAN
recover
Case
mistake
RMAN恢復案例之--完全恢復錯誤案例(ControlFile Error） RMAN恢復案例： 用戶在做rman的恢復時遇到以下錯誤： RMAN restore database from tag='TAG20140923T160003'; Startingrestoreat24-SEP-14allocatedchannel:ORA_DISK_1channelORA_DISK_1:sid=156devty
RMAN恢復案例之--完全恢復錯誤案例(ControlFile Error）
RMAN恢復案例：
用戶在做rman的恢復時遇到以下錯誤：
RMAN> restore database from tag='TAG20140923T160003';
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;
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！
查看告警日志：
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';
cataloged backuppiece backup piece handle=/backup/rman_bak/ctl1_166.bak recid=191 stamp=859138553
RMAN> list backup of controlfile;
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 ;
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級數(shù)據(jù)文件備份進行數(shù)據(jù)文件的轉儲！
轉儲控制文件：
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
轉儲數(shù)據(jù)文件：
RMAN> alter database mount;
database mounted released channel: ORA_DISK_1 released channel: ORA_DISK_2
RMAN> restore database from tag='TAG20140923T170004';
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
查看轉儲后的數(shù)據(jù)文件和控制文件的checkpoint：
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;
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 ，做不完全恢復！
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-14recover完成！
查看恢復后的database checkpoint：
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
打開數(shù)據(jù)庫：
RMAN> alter database open resetlogs;
database opened
@數(shù)據(jù)庫open成功，至此，數(shù)據(jù)庫恢復完成！
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Grass Wonder Build Guide | Uma Musume Pretty Derby
3 weeks ago
By Jack chen
Roblox: 99 Nights In The Forest - All Badges And How To Unlock Them
3 weeks ago
By DDD
Uma Musume Pretty Derby Banner Schedule (July 2025)
4 weeks ago
By Jack chen
Today's Connections hint and answer 3rd July for 753
1 months ago
By Jack chen
Windows Security is blank or not showing options
4 weeks ago
By 下次還敢
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to recover expired WeChat files? Can expired WeChat files be recovered?
Feb 22, 2024 pm 02:46 PM
Open WeChat, select Settings in Me, select General and then select Storage Space, select Management in Storage Space, select the conversation in which you want to restore files and select the exclamation mark icon. Tutorial Applicable Model: iPhone13 System: iOS15.3 Version: WeChat 8.0.24 Analysis 1 First open WeChat and click the Settings option on the My page. 2 Then find and click General Options on the settings page. 3Then click Storage Space on the general page. 4 Next, click Manage on the storage space page. 5Finally, select the conversation in which you want to recover files and click the exclamation mark icon on the right. Supplement: WeChat files generally expire in a few days. If the file received by WeChat has not been clicked, the WeChat system will clear it after 72 hours. If the WeChat file has been viewed,
Unable to complete operation (Error 0x0000771) Printer error
Mar 16, 2024 pm 03:50 PM
If you encounter an error message when using your printer, such as the operation could not be completed (error 0x00000771), it may be because the printer has been disconnected. In this case, you can solve the problem through the following methods. In this article, we will discuss how to fix this issue on Windows 11/10 PC. The entire error message says: The operation could not be completed (error 0x0000771). The specified printer has been deleted. Fix 0x00000771 Printer Error on Windows PC To fix Printer Error the operation could not be completed (Error 0x0000771), the specified printer has been deleted on Windows 11/10 PC, follow this solution: Restart Print Spool
Solution to Windows Update prompt Error 0x8024401c error
Jun 08, 2024 pm 12:18 PM
Table of Contents Solution 1 Solution 21. Delete the temporary files of Windows update 2. Repair damaged system files 3. View and modify registry entries 4. Turn off the network card IPv6 5. Run the WindowsUpdateTroubleshooter tool to repair 6. Turn off the firewall and other related anti-virus software. 7. Close the WidowsUpdate service. Solution 3 Solution 4 "0x8024401c" error occurs during Windows update on Huawei computers Symptom Problem Cause Solution Still not solved? Recently, the web server needs to be updated due to system vulnerabilities. After logging in to the server, the update prompts error code 0x8024401c. Solution 1
Why does the Xiangxiangfuzhai app display an error?
Mar 19, 2024 am 08:04 AM
The display error is a problem that may occur in the Xiangxiang Fuzhai app. Some users are not sure why the Xiangxiang Fuzhai app displays errors. It may be due to network connection problems, too many background programs, incorrect registration information, etc. Next, This is the editor’s introduction to how to solve app display errors for users. Interested users should come and take a look! Why does the Xiangxiang Fuzhai app display an error answer: network connection problem, too many background programs, incorrect registration information, etc. Details: 1. [Network problem] Solution: Check the device connection network status, reconnect or choose another network connection to use. Can. 2. [Too many background programs] Solution: Close other running programs and release the system, which can speed up the running of the software. 3. [Incorrect registration information
Interpreting Oracle error 3114: causes and solutions
Mar 08, 2024 pm 03:42 PM
Title: Analysis of Oracle Error 3114: Causes and Solutions When using Oracle database, you often encounter various error codes, among which error 3114 is a relatively common one. This error generally involves database link problems, which may cause exceptions when accessing the database. This article will interpret Oracle error 3114, discuss its causes, and give specific methods to solve the error and related code examples. 1. Definition of error 3114 Oracle error 3114 pass
How to restore chat spark on TikTok
Mar 16, 2024 pm 01:25 PM
On Douyin, a short video platform full of creativity and vitality, we can not only enjoy a variety of exciting content, but also have in-depth communications with like-minded friends. Among them, chat sparks are an important indicator of the intensity of interaction between the two parties, and they often inadvertently ignite the emotional bonds between us and our friends. However, sometimes due to some reasons, the chat spark may be disconnected. So what should we do if we want to restore the chat spark? This tutorial guide will bring you a detailed introduction to the content strategy, hoping to help everyone. How to restore the spark of Douyin chat? 1. Open the Douyin message page and select a friend to chat. 2. Send messages and chat to each other. 3. If you send messages continuously for 3 days, you can get the spark logo. On a 3-day basis, send pictures or videos to each other
How to restore Xiaomi Cloud photo album to local
Feb 24, 2024 pm 03:28 PM
How to restore Xiaomi Cloud Photo Album to local? You can restore Xiaomi Cloud Photo Album to local in Xiaomi Cloud Photo Album APP, but most friends don’t know how to restore Xiaomi Cloud Photo Album to local. The next step is to restore Xiaomi Cloud Photo Album to local. Local method graphic tutorials, interested users come and take a look! How to restore Xiaomi cloud photo album to local 1. First open the settings function in Xiaomi phone and select [Personal Avatar] on the main interface; 2. Then enter the Xiaomi account interface and click the [Cloud Service] function; 3. Then jump to Xiaomi For the function of cloud service, select [Cloud Backup]; 4. Finally, in the interface as shown below, click [Cloud Album] to restore the album to local.
How to recover deleted emmo diary
Feb 27, 2024 pm 04:40 PM
Emmo Diary is a software specially designed for recording your mood. It provides you with a private diary space, allowing you to record important or trivial things every day. Through unique emotion recognition technology, Emmo Diary can also help you better understand and deal with your emotions. But sometimes I find that my diary has been deleted by mistake and I don’t know how to restore it. So this tutorial guide will bring you a detailed recovery guide, hoping to help everyone in need. How can emmo retrieve his previous diary? 1. Click the [Settings] icon in the lower left corner of the emmo selection screen to enter; 2. Select the [Data Backup and Restore] icon on the screen and enter the operation.
