實(shí)例講解Oracle 9i數(shù)據(jù)壞塊的處理
筆者在一臺(tái)生產(chǎn)用測(cè)試庫(kù)上SELECT一個(gè)表時(shí)出現(xiàn)ORA-01578，一個(gè)塊損壞，以前學(xué)習(xí)過塊損壞怎么處理，到還真沒遇到過，今天總算讓我遇到了，還是一臺(tái)生產(chǎn)用測(cè)試庫(kù)，就不用很緊張了。
數(shù)據(jù)庫(kù)版本是9.2.0.4，Oracle9i的RMAN有一個(gè)blockrecover命令，可以在線修復(fù)壞塊，以下就是使用RMAN修復(fù)壞塊的過程。
|
報(bào)ORA-01578數(shù)據(jù)塊損壞，以下使用RMAN命令查詢是否可以使用blockrecover命令恢復(fù)以及怎樣恢復(fù)
使用rman登錄catalog數(shù)據(jù)庫(kù)
|
查找最近datafile 15的全備份，今天下午剛做了一次RMAN的全備份
RMAN> list backup of datafile 15;
List of Backup Sets
===================BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
643 Full 64K DISK 00:00:27 16-MAR-09
BP Key: 650 Status: AVAILABLE Tag: TAG20090316T154352
Piece Name: /d02/fullbackup/20090316_data_24_1
List of Datafiles in backup set 643
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
15 Full 11856250905 16-MAR-09 /d01/app/oracle/oradata/dpa/dpa01.dbf
查找SCN 11856250905 以后的archivelog是否有備份
|
查找sequence 110 以后的archivelog是否有備份
|
從以上查詢中可以看出datafile 15有一次最近的全備份，有全備份以來的所有archivelog，online redo log
下面開始blockreocver，其實(shí)命令很簡(jiǎn)單
RMAN> blockrecover datafile 15 block 18;
Starting blockrecover at 16-MAR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=16 devtype=DISK
channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00015
channel ORA_DISK_1: restored block(s) from backup piece 1
piece handle=/d02/fullbackup/20090316_data_24_1 tag=TAG20090316T154352 params=NULL
channel ORA_DISK_1: block restore completestarting media recovery
archive log thread 1 sequence 111 is already on disk as file /d02/arch/1_111.dbf
archive log thread 1 sequence 112 is already on disk as file /d02/arch/1_112.dbf
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=109
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=110
channel ORA_DISK_1: restored backup piece 1
piece handle=/d02/fullbackup/20090316_arch_28 tag=TAG20090316T154731 params=NULL
channel ORA_DISK_1: restore complete
media recovery complete
Finished blockrecover at 16-MAR-09
SQL> select * from dpa_history;
PRODLINEID BARCODE PA
---------- ------------------------------ --
7 S*33040-D8311050149512B 03
7 S*33040-D8311050143512B 03
7 S*33040-D8311050140512B 03
7 S*33040-D8311050144512B 03
7 S*33040-D8311050151512B 03
7 S*33040-D8311050262512B 03
7 S*33040-D8311050552512B 03
7 S*33040-D8311050345512B 03
7 S*33040-D8311050170512B 03
【編輯推薦】
