日韩无码专区无码一级三级片|91人人爱网站中日韩无码电影|厨房大战丰满熟妇|AV高清无码在线免费观看|另类AV日韩少妇熟女|中文日本大黄一级黄色片|色情在线视频免费|亚洲成人特黄a片|黄片wwwav色图欧美|欧亚乱色一区二区三区

筆者在一臺(tái)生產(chǎn)用測(cè)試庫(kù)上SELECT一個(gè)表時(shí)出現(xiàn)ORA-01578，一個(gè)塊損壞，以前學(xué)習(xí)過(guò)塊損壞怎么處理，到還真沒(méi)遇到過(guò)，今天總算讓我遇到了，還是一臺(tái)生產(chǎn)用測(cè)試庫(kù)，就不用很緊張了。

創(chuàng)新互聯(lián)建站是一家專業(yè)提供雙遼企業(yè)網(wǎng)站建設(shè),專注與網(wǎng)站制作、網(wǎng)站設(shè)計(jì)、H5開(kāi)發(fā)、小程序制作等業(yè)務(wù)。10年已為雙遼眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專業(yè)網(wǎng)站設(shè)計(jì)公司優(yōu)惠進(jìn)行中。

數(shù)據(jù)庫(kù)版本是9.2.0.4，Oracle9i的RMAN有一個(gè)blockrecover命令，可以在線修復(fù)壞塊，以下就是使用RMAN修復(fù)壞塊的過(guò)程。

SQL> conn owi/owi
Connected.
SQL> select * from dpa_history;
select * from dpa_history
              *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 15, block # 18)
ORA-01110: data file 15: '/d01/app/oracle/oradata/dpa/dpa01.dbf'

報(bào)ORA-01578數(shù)據(jù)塊損壞，以下使用RMAN命令查詢是否可以使用blockrecover命令恢復(fù)以及怎樣恢復(fù)

使用rman登錄catalog數(shù)據(jù)庫(kù)

[ora9@rmanserver ~]$ rman target sys/oracle@dpa catalog rman/rman
Recovery Manager: Release 9.2.0.8.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
connected to target database: DPA (DBID=843495022)
connected to recovery catalog database
 

查找最近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是否有備份

RMAN> list backup of archivelog scn from 11856250905

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
680     265K       DISK        00:00:00     16-MAR-09      
        BP Key: 681   Status: AVAILABLE   Tag: TAG20090316T154731
        Piece Name: /d02/fullbackup/20090316_arch_28

  List of Archived Logs in backup set 680
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    109     11856250805 16-MAR-09 11856251483 16-MAR-09
  1    110     11856251483 16-MAR-09 11856251487 16-MAR-09

查找sequence 110 以后的archivelog是否有備份

RMAN> list copy of archivelog from sequence 110;
List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
694     1    111     A 16-MAR-09 /d02/arch/1_111.dbf
695     1    112     A 16-MAR-09 /d02/arch/1_112.dbf
查詢online archive log
SQL> select sequence#,members,archived,status from v$log;
 SEQUENCE#    MEMBERS ARC STATUS
---------- ---------- --- ----------------
       113          1 NO  CURRENT
       111          1 YES INACTIVE
       112          1 YES INACTIVE

從以上查詢中可以看出datafile 15有一次最近的全備份，有全備份以來(lái)的所有archivelog，online redo log
下面開(kāi)始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 complete
starting 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

  再SELECT一下表DPA_HISTORY  

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