RMAN恢復(fù)案例之--完全恢復(fù)錯(cuò)誤案例（ControlFileError）
Jun 07, 2016 pm 02:53 PM
RMAN
恢復(fù)
案例
錯(cuò)誤
RMAN恢復(fù)案例之--完全恢復(fù)錯(cuò)誤案例(ControlFile Error） RMAN恢復(fù)案例： 用戶在做rman的恢復(fù)時(shí)遇到以下錯(cuò)誤： RMAN restore database from tag='TAG20140923T160003'; Startingrestoreat24-SEP-14allocatedchannel:ORA_DISK_1channelORA_DISK_1:sid=156devty
RMAN恢復(fù)案例之--完全恢復(fù)錯(cuò)誤案例(ControlFile Error）
RMAN恢復(fù)案例：
用戶在做rman的恢復(fù)時(shí)遇到以下錯(cuò)誤：
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
恢復(fù)失敗，提示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.
解決方法：
通過(guò)備份的controlfile進(jìn)行恢復(fù)
RMAN> list backup of controlfile;
但是通過(guò)rman查看備份的controlfile信息時(shí)，卻沒(méi)有！
還好，在磁盤上找到一個(gè)控制文件的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級(jí)數(shù)據(jù)文件備份進(jìn)行數(shù)據(jù)文件的轉(zhuǎn)儲(chǔ)！
轉(zhuǎn)儲(chǔ)控制文件：
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
轉(zhuǎn)儲(chǔ)數(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
查看轉(zhuǎn)儲(chǔ)后的數(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
對(duì)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 ，做不完全恢復(fù)！
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完成！
查看恢復(fù)后的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
打開(kāi)數(shù)據(jù)庫(kù)：
RMAN> alter database open resetlogs;
database opened
@數(shù)據(jù)庫(kù)open成功，至此，數(shù)據(jù)庫(kù)恢復(fù)完成！
本網(wǎng)站聲明
本文內(nèi)容由網(wǎng)友自願(yuàn)投稿，版權(quán)歸原作者所有。本站不承擔(dān)相應(yīng)的法律責(zé)任。如發(fā)現(xiàn)涉嫌抄襲或侵權(quán)的內(nèi)容，請(qǐng)聯(lián)絡(luò)admin@php.cn
熱AI工具
Undress AI Tool
免費(fèi)脫衣圖片
Undresser.AI Undress
人工智慧驅(qū)動(dòng)的應(yīng)用程序，用於創(chuàng)建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Clothoff.io
AI脫衣器
Video Face Swap
使用我們完全免費(fèi)的人工智慧換臉工具，輕鬆在任何影片中換臉！
熱門文章
Grass Wonder Build Guide |烏瑪媽媽漂亮的德比
4 週前
By Jack chen
<??>：在森林裡99夜 - 所有徽章以及如何解鎖
4 週前
By DDD
烏瑪?shù)姆劢z漂亮的德比橫幅日程（2025年7月）
1 個(gè)月前
By Jack chen
Rimworld Odyssey溫度指南和Gravtech
3 週前
By Jack chen
Windows安全是空白或不顯示選項(xiàng)
1 個(gè)月前
By 下次還敢
熱工具
記事本++7.3.1
好用且免費(fèi)的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強(qiáng)大的PHP整合開(kāi)發(fā)環(huán)境
Dreamweaver CS6
視覺(jué)化網(wǎng)頁(yè)開(kāi)發(fā)工具
SublimeText3 Mac版
神級(jí)程式碼編輯軟體(SublimeText3)
微信檔案過(guò)期怎麼恢復(fù) 微信的過(guò)期檔案能恢復(fù)嗎
Feb 22, 2024 pm 02:46 PM
開(kāi)啟微信，在我中選擇設(shè)置，選擇通用後選擇儲(chǔ)存空間，在儲(chǔ)存空間選擇管理，選擇要恢復(fù)檔案的對(duì)話選擇感嘆號(hào)圖示。教學(xué)適用型號(hào)：iPhone13系統(tǒng)：iOS15.3版本：微信8.0.24解析1先開(kāi)啟微信，在我的頁(yè)面中點(diǎn)選設(shè)定選項(xiàng)。 2接著在設(shè)定頁(yè)面中找到並點(diǎn)選通用選項(xiàng)。 3然後在通用頁(yè)面中點(diǎn)選儲(chǔ)存空間。 4接下來(lái)在儲(chǔ)存空間頁(yè)面中點(diǎn)選管理。 5最後選擇要恢復(fù)檔案的對(duì)話，點(diǎn)選右側(cè)的感嘆號(hào)圖示。補(bǔ)充：微信文件一般幾天過(guò)期1要是微信接收的文件並沒(méi)有點(diǎn)開(kāi)過(guò)的情況下，那在七十二鐘頭之後微信系統(tǒng)會(huì)清除掉，要是己經(jīng)查看了微信
無(wú)法完成操作（錯(cuò)誤0x0000771）印表機(jī)錯(cuò)誤
Mar 16, 2024 pm 03:50 PM
如果您在使用印表機(jī)時(shí)遇到錯(cuò)誤訊息，例如操作無(wú)法完成（錯(cuò)誤0x00000771），可能是因?yàn)橛”頇C(jī)已中斷連線。在這種情況下，您可以透過(guò)以下方法解決問(wèn)題。在本文中，我們將討論如何在Windows11/10PC上修復(fù)此問(wèn)題。整個(gè)錯(cuò)誤訊息說(shuō)：操作無(wú)法完成（錯(cuò)誤0x0000771）。指定的印表機(jī)已被刪除。修正WindowsPC上的0x00000771印表機(jī)錯(cuò)誤若要修復(fù)印表機(jī)錯(cuò)誤操作無(wú)法完成（錯(cuò)誤0x0000771），指定的印表機(jī)已在Windows11/10PC上刪除，請(qǐng)遵循下列解決方案：重新啟動(dòng)列印假脫機(jī)
Windows Update 更新提示Error 0x8024401c錯(cuò)誤的解決方法
Jun 08, 2024 pm 12:18 PM
目錄解決方法一解決方法二一、刪除Windows更新的臨時(shí)檔案二、修復(fù)受損的系統(tǒng)檔案三、檢視並修改登錄項(xiàng)目四、關(guān)閉網(wǎng)卡IPv6五、執(zhí)行WindowsUpdateTroubleshootor工具進(jìn)行修復(fù)六、關(guān)閉防火牆和其它相關(guān)的防毒軟體。七、關(guān)閉WidowsUpdate服務(wù)。解決方法三解決方法四華為電腦Windows更新出現(xiàn)「0x8024401c」報(bào)錯(cuò)問(wèn)題現(xiàn)象問(wèn)題原因解決方案仍未解決？最近web伺服器因?yàn)橄到y(tǒng)漏洞需要更新，登入伺服器之後，更新提示錯(cuò)誤碼0x8024401c解決方法一
香香腐宅app為什麼顯示錯(cuò)誤
Mar 19, 2024 am 08:04 AM
顯示錯(cuò)誤是在香香腐宅app中可能會(huì)出現(xiàn)的問(wèn)題，有些用戶還不太清楚香香腐宅app為什麼顯示錯(cuò)誤，可能是網(wǎng)絡(luò)連接問(wèn)題、後臺(tái)程序過(guò)多、註冊(cè)信息錯(cuò)誤等問(wèn)題，接下來(lái)就是小編為使用者帶來(lái)的app顯示錯(cuò)誤解決方法的介紹，有興趣的使用者快來(lái)一起看看吧！香香腐宅app為何顯示錯(cuò)誤答案：網(wǎng)路連線問(wèn)題、後臺(tái)程式過(guò)多、註冊(cè)資訊錯(cuò)誤等詳情介紹：1、【網(wǎng)路問(wèn)題】解決方法：檢視裝置連線網(wǎng)路狀態(tài)，重新連線或選擇其他網(wǎng)路連線使用即可。 2.【後臺(tái)程式過(guò)多】解決方法：關(guān)閉正在運(yùn)作的其他程序，釋放系統(tǒng)，可以加快軟體的運(yùn)作。 3、【註冊(cè)資訊錯(cuò)
解讀Oracle錯(cuò)誤3114：原因及解決方法
Mar 08, 2024 pm 03:42 PM
標(biāo)題：分析Oracle錯(cuò)誤3114：原因及解決方法在使用Oracle資料庫(kù)時(shí)，常常會(huì)遇到各種錯(cuò)誤代碼，其中錯(cuò)誤3114是比較常見(jiàn)的一個(gè)。此錯(cuò)誤一般涉及資料庫(kù)連結(jié)的問(wèn)題，可能導(dǎo)致存取資料庫(kù)時(shí)出現(xiàn)異常狀況。本文將對(duì)Oracle錯(cuò)誤3114進(jìn)行解讀，探討其造成的原因，並給出解決該錯(cuò)誤的具體方法以及相關(guān)的程式碼範(fàn)例。 1.錯(cuò)誤3114的定義Oracle錯(cuò)誤3114通
抖音怎麼恢復(fù)聊天火花
Mar 16, 2024 pm 01:25 PM
在抖音這個(gè)充滿創(chuàng)意與活力的短影片平臺(tái)上，我們不僅可以欣賞到各種精彩內(nèi)容，還能與志同道合的朋友展開(kāi)深入的交流。其中，聊天火花作為衡量雙方互動(dòng)熱度的重要指標(biāo)，常常在不經(jīng)意間點(diǎn)燃我們與好友之間的情感連結(jié)。然而，有時(shí)由於一些原因，聊天火花可能會(huì)斷開(kāi)，那麼如果我們想要恢復(fù)聊天火花究竟該如何操作呢，這篇教程攻略就將為大家?guī)?lái)詳細(xì)的內(nèi)容攻略介紹，希望能幫助到大家。抖音聊天火花斷了怎麼恢復(fù)？ 1.開(kāi)啟抖音的訊息頁(yè)面，選擇好友聊天。 2、互發(fā)訊息聊天。 3.連續(xù)發(fā)送訊息3天，就可以獲得火花標(biāo)識(shí)。在3天基礎(chǔ)上，互發(fā)圖片或視
小米雲(yún)相簿怎麼恢復(fù)到本地
Feb 24, 2024 pm 03:28 PM
小米雲(yún)相簿怎麼恢復(fù)到本地?小米雲(yún)相簿APP中是可以恢復(fù)到本地，但是多數(shù)的小伙伴不知道小米雲(yún)相冊(cè)如何恢復(fù)到本地中，接下來(lái)就是小編為用戶帶來(lái)的小米雲(yún)相冊(cè)恢復(fù)到本地方法圖文教程，有興趣的用戶快來(lái)一起看看吧！小米雲(yún)相簿怎麼恢復(fù)到本地1、先打開(kāi)小米手機(jī)中的設(shè)定功能，主介面選擇【個(gè)人頭像】;2、然後進(jìn)入到小米帳號(hào)的介面，點(diǎn)選【雲(yún)端服務(wù)】功能;3、接著跳到小米雲(yún)端服務(wù)的功能，選擇其中的【雲(yún)端備份】;4、最後在如下圖所示的介面，點(diǎn)選【雲(yún)端相簿】即可恢復(fù)相簿到本地。
emmo日記刪除如何恢復(fù)
Feb 27, 2024 pm 04:40 PM
Emmo日記是專為記錄心情而設(shè)計(jì)的軟體，它為你提供了一個(gè)私密的日記空間，讓你能夠記錄下每天的重要或瑣碎的事情。透過(guò)獨(dú)特的情緒辨識(shí)技術(shù)，Emmo日記還能幫助你更能理解和處理自己的情緒。但是有的時(shí)候發(fā)現(xiàn)自己日記被誤刪了以後卻不知道該如何恢復(fù)，那麼這篇教程攻略就將為大家?guī)?lái)詳細(xì)的恢復(fù)攻略介紹，希望能幫助到各位有需要的小伙伴們。 emmo怎麼找回之前的日記？ 1.在emmo選擇畫(huà)面左下角【設(shè)定】圖標(biāo)點(diǎn)擊進(jìn)入；2、選擇畫(huà)面【資料備份與恢復(fù)】圖標(biāo)，進(jìn)入操作即可。
