ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dbverify Utility

dbverify Utility

原创 Linux操作系统 作者:ygzhou518 时间:2012-03-05 17:05:19 0 删除 编辑
1、check datafile: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=35512.1
(1)
SQL> show parameter db_block_size
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_size                        integer     8192
(2)
SQL> select file#,name,bytes/8912 from v$datafile;
 
     FILE# NAME                                               BYTES/8912
---------- -------------------------------------------------- ----------
         1 /data1/stream/ygzhou01/datafile/system01.dbf       58829.4434
         2 /data1/stream/ygzhou01/datafile/sysaux01.dbf       51769.9102
         3 /data1/stream/ygzhou01/datafile/ygzhou01.dbf       3850387.07
         4 /data1/stream/ygzhou01/datafile/users01.dbf        23531.7774
         5 /data1/stream/ygzhou01/datafile/stream01.dbf       1176.58887
         6 /data1/stream/ygzhou01/datafile/undotbs1.dbf       3186202.66
         7 /data1/stream/ygzhou01/datafile/ygzhou02.dbf         67653.86
         8 /data1/stream/ygzhou01/datafile/block01.dbf        180606.391
         9 /data1/stream/ygzhou01/datafile/block02.dbf        1176.58887
        10 /data1/stream/ygzhou01/datafile/archivelog01.dbf   889501.185
        11 /data1/stream/ygzhou01/datafile/archivelog02.dbf   838907.864
 
     FILE# NAME                                               BYTES/8912
---------- -------------------------------------------------- ----------
        12 /data1/stream/ygzhou01/datafile/ygzhou03.dbf        1247184.2
 
12 rows selected.
(3)
datafile]$ dbv file=ygzhou01.dbf blocksize=8192 logfile=ygzhou.log feedback=500000
(4)
[oracle@swhagral6db02 datafile]$ strings ygzhou.log
DBVERIFY: Release 11.2.0.2.0 - Production on Mon Mar 5 16:34:49 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
DBVERIFY - Verification starting : FILE = /data1/stream/ygzhou01/datafile/ygzhou01.dbf
DBVERIFY - Verification complete
Total Pages Examined         : 4188800
Total Pages Processed (Data) : 733215
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 718674
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 10649
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 2726262
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 22430714 (0.22430714)
[oracle@swhagral6db02 datafile]$
 
2、check object or segment: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=139962.1
(1)
SQL> select t.ts#, s.header_file, s.header_block from v$tablespace t, dba_segments s where s.segment_name='DBVCHECK' and t.name = s.tablespace_name;
 
       TS# HEADER_FILE HEADER_BLOCK
---------- ----------- ------------
         7           3       456737
(2)
[oracle@swhagral6db02 ygzhou01]$ dbv userid=ygzhou/ygzhou segment_id=7.3.456737
 
DBVERIFY: Release 11.2.0.2.0 - Production on Mon Mar 5 16:50:38 2012
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
DBVERIFY - Verification starting : SEGMENT_ID = 7.3.456737
 
 
DBVERIFY - Verification complete
 
Total Pages Examined         : 64512
Total Pages Processed (Data) : 29598
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 30592
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 225
Total Pages Processed (Seg)  : 1
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 4096
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 15631271 (0.15631271)
[oracle@swhagral6db02 ygzhou01]$
 
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24867586/viewspace-717745/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORACLE數據恢復
请登录后发表评论 登录
全部评论

注册时间:2011-02-11

  • 博文量
    167
  • 访问量
    358909