Friday, November 14, 2008

Backup Corruptions - DBV

While getting a copy of a production DB to a test/dev box, you will need to rename the DB.
Obviously you will run something like the following:

RECOVER AUTOMATIC DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
ORA-00283: recovery session canceled due to errors
ORA-01115: IO error reading block from file 248 (block # 358418)
ORA-01110: data file 248: '/u03/oracledbf/dbsidnum/datafe12.dbf'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192

This hints to a Corruption... you can verify that using the following:
$ dbv file=/u03/oracledbf/dbsidnum/datafe12.dbf logfile=datasm_dbv.log feedback=100

If clean output would look like the following:
DBVERIFY - Verification complete

Total Pages Examined : 108800
Total Pages Processed (Data) : 79168
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 24
Total Pages Failing (Index): 0
Total Pages Processed (Other): 11894
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 17714
Total Pages Marked Corrupt : 0 <<<--------------------
Total Pages Influx : 0
Highest block SCN : 474949797 (2250.474949797)

No comments: