? ? ?我們備份的數(shù)據(jù)文件,可以通過oacle自帶的dbv工具來查看是否是好的。
下面實驗如下:
環(huán)境:oracle10.2.0.1
?
1.檢查數(shù)據(jù)文件是否有壞塊
[oracle@app orcl]$ dbv DBVERIFY: Release 10.2.0.1.0 - Production on Fri Nov 22 20:59:01 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Keyword Description (Default) ---------------------------------------------------- FILE File to Verify (NONE) START Start Block (First Block of File) END End Block (Last Block of File) BLOCKSIZE Logical Block Size (8192) LOGFILE Output Log (NONE) FEEDBACK Display Progress (0) PARFILE Parameter File (NONE) USERID Username/Password (NONE) SEGMENT_ID Segment ID (tsn.relfile.block) (NONE) HIGH_SCN Highest Block SCN To Verify (NONE) (scn_wrap.scn_base OR scn)
[oracle@app orcl]$ dbv file=users01.dbf feedback=100 DBVERIFY: Release 10.2.0.1.0 - Production on Fri Nov 22 21:01:11 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = users01.dbf ....... DBVERIFY - Verification complete Total Pages Examined : 640 Total Pages Processed (Data) : 25 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 2 Total Pages Failing (Index): 0 Total Pages Processed (Other): 32 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 581 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 1377014 (0.1377014)
主要關注Total Pages Failing (Seg) : 0 ?--------這一行
?
?
2.檢查segment是否有壞塊
SQL> desc sys_dba_segs Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER VARCHAR2(30) SEGMENT_NAME VARCHAR2(81) PARTITION_NAME VARCHAR2(30) SEGMENT_TYPE VARCHAR2(18) SEGMENT_TYPE_ID NUMBER TABLESPACE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BLOCKSIZE NUMBER HEADER_FILE NUMBER HEADER_BLOCK NUMBER BYTES NUMBER BLOCKS NUMBER EXTENTS NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER RELATIVE_FNO NUMBER BUFFER_POOL_ID NUMBER SEGMENT_FLAGS NUMBER SEGMENT_OBJD NUMBER SQL> col segment_name format a30 SQL> select segment_name,tablespace_id,header_file,header_block from sys_dba_segs where owner='YN'; SEGMENT_NAME TABLESPACE_ID HEADER_FILE HEADER_BLOCK ------------------------------ ------------- ----------- ------------ FRUIT 4 4 59 SQL>
[oracle@app orcl]$ dbv userid=system/yn segment_Id=4.4.59 DBVERIFY: Release 10.2.0.1.0 - Production on Fri Nov 22 21:05:05 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : SEGMENT_ID = 4.4.59 DBVERIFY - Verification complete Total Pages Examined : 8 Total Pages Processed (Data) : 5 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 2 Total Pages Processed (Seg) : 1 Total Pages Failing (Seg) : 0 Total Pages Empty : 0 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 1377014 (0.1377014) [oracle@app orcl]$
注:其中的segment_Id=4.4.59 是通過上面sql查詢出來的。
?
另外:dbv只能檢查數(shù)據(jù)文件。
?
?
更多文章、技術交流、商務合作、聯(lián)系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯(lián)系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
