ORACLE技术论坛–请到ask.orasos.com提问

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
dbv 全部显示 0
2016 年 09 月 03 日
21:37
惜分飞
Admin
Forum Posts: 344
Member Since:
2010 年 07 月 31 日
Offline

# uname -a
AIX ndbsvr1 3 5 00C502E24C00

ndbsvr1:/home/oracle$ dbv userid=sys/oracle file=+DATA/ndb/datafile/chinadem.314.921346457

DBVERIFY: Release 10.2.0.4.0 – Production on Thu Sep 1 10:43:34 2016

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

DBVERIFY – Verification starting : FILE = +DATA/ndb/datafile/chinadem.314.921346457

DBVERIFY – Verification complete

Total Pages Examined : 0
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 0
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 0 (0.0)
ndbsvr1:/home/oracle$ dbv userid=sys/oracle file=+DATA/ndb/datafile/chinadem.314.921346457 blocksize=16384

DBVERIFY: Release 10.2.0.4.0 – Production on Thu Sep 1 10:43:59 2016

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

DBVERIFY – Verification starting : FILE = +DATA/ndb/datafile/chinadem.314.921346457

DBVERIFY – Verification complete

Total Pages Examined : 271616
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 4
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 271612
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 0 (0.0)
ndbsvr1:/home/oracle$

SQL> show parameter db_block_size;

NAME TYPE VALUE
———————————— ———-- ——————————
db_block_size integer 16384

在asm环境中,由于blocksize不对,导致dbv显示全部为0

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。