前言:
眼前小伙伴们对“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如何查询坏块