成人免费xxxxx在线视频软件_久久精品久久久_亚洲国产精品久久久_天天色天天色_亚洲人成一区_欧美一级欧美三级在线观看

實例講解Oracle 9i數據壞塊的處理

作者：jason_wang2002
運維 數據庫運維 Oracle
本文是作者在生產中碰到的一個實際案例，表現ORA-01578問題，下面是作者的詳細解決過程。

筆者在一臺生產用測試庫上SELECT一個表時出現ORA-01578，一個塊損壞，以前學習過塊損壞怎么處理，到還真沒遇到過，今天總算讓我遇到了，還是一臺生產用測試庫，就不用很緊張了。

數據庫版本是9.2.0.4，Oracle9i的RMAN有一個blockrecover命令，可以在線修復壞塊，以下就是使用RMAN修復壞塊的過程。

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'

報ORA-01578數據塊損壞，以下使用RMAN命令查詢是否可以使用blockrecover命令恢復以及怎樣恢復

使用rman登錄catalog數據庫

[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有一次最近的全備份，有全備份以來的所有archivelog，online redo log
下面開始blockreocver，其實命令很簡單

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


 

【編輯推薦】

  1. 用Instant client批量安裝Oracle客戶端
  2. Oracle 11g中實現自我調整功能
  3. Oracle數據塊原理深入剖析
責任編輯：彭凡 來源： ITPUB
ORA-01578壞塊Oracle
相關推薦

2011-05-17 15:41:51

oracle 9i卸載

2010-04-27 17:58:17

Oracle 9i

2010-04-13 10:29:12

Oracle 9i

2010-04-14 09:25:08

Oracle 9i創建

2010-04-19 13:12:36

Oracle 9i數據

2010-04-16 14:30:13

Oracle 9i

2009-11-03 14:22:07

Oracle密碼

2009-01-06 09:14:08

8i9ioracle

2010-04-13 11:31:02

Oracle 9i e

2010-04-14 09:16:39

Oracle 9i

2010-04-22 11:41:55

Oracle 9i

2010-04-12 14:08:09

Oracle 9i R

2010-04-14 16:22:42

Oracle 9i

2010-05-05 16:11:53

Oracle 9i

2010-04-13 09:09:14

Oracel 9i

2011-08-01 18:14:21

AIX5LOracle 9i

2010-04-14 16:45:29

Oracle 9i全索

2018-01-24 19:59:03

數據庫Oracle壞塊

2011-05-13 11:14:18

2021-12-06 08:31:18

Oracle數據庫后端開發
點贊
收藏

51CTO技術棧公眾號

主站蜘蛛池模板： 天天天久久久 | 久久国产精品一区二区 | 欧美日韩高清在线观看 | 成年人黄色一级片 | 91视频免费在观看 | 国产蜜臀97一区二区三区 | 久久精彩视频 | 北条麻妃一区二区三区在线观看 | 中日韩av | 亚洲欧美日韩中文在线 | 在线欧美亚洲 | 日韩中文字幕在线 | 99久久婷婷国产综合精品电影 | 国产成人免费视频网站视频社区 | 国产二区在线播放 | 国产乱精品一区二区三区 | 欧美日韩在线免费观看 | 日韩a视频 | 成人精品一区二区三区 | 91视频在线看 | 久久久久久成人 | 91久久国产综合久久 | 91在线区| 国产精品久久久久一区二区三区 | 综合久久99 | 黄网站在线观看 | 亚洲精品无人区 | 国产久| av网站免费 | a级在线免费 | 免费久久99精品国产婷婷六月 | 麻豆av在线 | 国内毛片毛片毛片毛片 | 一区二区av | 精品九九九 | 国产在线观看一区二区三区 | 日韩一区二区三区在线视频 | 久久久久亚洲国产| 国产精品99久久久久久久久 | 手机在线观看av | 中文字幕在线视频免费观看 |