龙空技术网

Oracle数据库:Oracle 数据库使用DBV工具检查文件坏块信息(五)

小刘伢子 353

前言:

眼前小伙伴们对“oracle如何查询坏块”大致比较讲究,我们都想要剖析一些“oracle如何查询坏块”的相关资讯。那么小编也在网摘上网罗了一些有关“oracle如何查询坏块””的相关内容,希望大家能喜欢,同学们一起来学习一下吧!

点击“和我一起走吧”关注

请点击关注与分享 每天学习一点点

一、查看dbv使用帮助

[oracle@UL01 ~]$ dbv help=y

DBVERIFY: Release 11.2.0.4.0 - Production on Sun Oct 29 03:56:37 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. 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@UL01 ~]$

SQL> show parameter db_block_size;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_block_size integer 8192

SQL>

SQL> select BYTES/2048 from v$datafile where FILE#=5;

BYTES/2048

----------

51200

SQL>

二、查看asm上的文件

SQL> select file_name from dba_data_files;

FILE_NAME

--------------------------------------------------------------------------------

+DATA/ul01/datafile/system.260.950733727

+DATA/ul01/datafile/sysaux.261.950733753

+DATA/ul01/datafile/undotbs1.262.950733771

+DATA/ul01/datafile/users.264.950733795

+DATA/ul01/datafile/ul01.265.950841221

SQL>

三、使用dbv检查数据文件

[oracle@UL01 ~]$ dbv file='+DATA/ul01/datafile/system.260.950733727' userid=sys/Ipnet123

DBVERIFY: Release 11.2.0.4.0 - Production on Sun Oct 29 04:08:29 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

DBVERIFY - Verification starting : FILE = +DATA/ul01/datafile/system.260.950733727

DBVERIFY - Verification complete

Total Pages Examined : 89600

Total Pages Processed (Data) : 37650

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 7788

Total Pages Failing (Index): 0

Total Pages Processed (Other): 3077

Total Pages Processed (Seg) : 1

Total Pages Failing (Seg) : 0

Total Pages Empty : 41085

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

Total Pages Encrypted : 0

Highest block SCN : 0 (0.0)

四、分享完毕 。

标签: #oracle如何查询坏块