asm 的dbv 文件检查方法

3020阅读 0评论2012-11-10 ora-00900
分类:Oracle

SQL> col file_name for a40
SQL> select file_name,tablespace_name,bytes/1024/1024 "M" from dba_data_files;

FILE_NAME                                TABLESPACE_NAME                         M
---------------------------------------- ------------------------------ ----------
+DG1/rac/datafile/users.259.783018573    USERS                                   5
+DG1/rac/datafile/sysaux.257.783018569   SYSAUX                                270
+DG1/rac/datafile/undotbs1.258.783018571 UNDOTBS1                               30
+DG1/rac/datafile/system.256.783018565   SYSTEM                                480
+DG1/rac/datafile/example.264.783018999  EXAMPLE                               100
+DG1/rac/datafile/undotbs2.265.783019457 UNDOTBS2                               25

[oracle@rac-one ~]$ dbv file='+DG1/rac/datafile/example.264.783018999' userid=root/098765

DBVERIFY: Release 10.2.0.1.0 - Production on Sat Nov 10 00:25:41 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = +DG1/rac/datafile/example.264.783018999


DBVERIFY - Verification complete

Total Pages Examined         : 12800
Total Pages Processed (Data) : 4409
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 1264
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1539
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 5588
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 0 (0.0)
上一篇:查看oracle有无非法连接
下一篇:Oracle 错误表