Tuesday, June 15, 2010

DB Verify

Check that a datafile has no currupt blocks



dbv file=+DATA/orcl/datafile/users.309.716629587

DBVERIFY: Release 11.2.0.1.0 - Production on Tue Jun 15 07:52:42 2010

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

DBVERIFY - Verification starting : FILE = +DATA/rskdus_atl/datafile/users.309.716629587


DBVERIFY - Verification complete

Total Pages Examined : 813920
Total Pages Processed (Data) : 426413
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 326394
Total Pages Failing (Index): 0
Total Pages Processed (Other): 13269
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 47844
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 0 (0.0)



******************************************
keywords: dbv dbverify
******************************************
rdbms version: 11g
******************************************

No comments: