[oracle@oracle11g ORCL10G]$ dbv file=system01.dbf feedback=100 blocksize=8192
DBVERIFY: Release 10.2.0.5.0 - Production on Wed Feb 15 14:51:29 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBV-00600: Fatal Error - [21] [2] [0] [0]
To fix the issue,
1. Make sure that dbverify is ran with the same version as the database or higher. A lower dbverify is not allowed. Thereby the dbverify must be run from the Oracle home of the database.
2. Use the fully qualified path of the datafile.
[oracle@oracle11g ORCL10G]$ dbv file=/u01/oradata/ORCL10G/users01.dbf feedback=100 blocksize=8192
Code: Select all
[oracle@oracle11g ORCL10G]$ dbv file=/u01/oradata/ORCL10G/users01.dbf feedback=100 blocksize=8192
DBVERIFY: Release 10.2.0.5.0 - Production on Wed Feb 15 14:53:19 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/oradata/ORCL10G/users01.dbf
.......
DBVERIFY - Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 15
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 2
Total Pages Failing (Index): 0
Total Pages Processed (Other): 26
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 597
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 442362 (0.442362)
[oracle@oracle11g ORCL10G]$