Friday, April 1, 2011

DBV-00600: Fatal Error - [21] [2] [0] [0]

While I was performing a test restore of one of the datafiles, encountered the  following error when  checking the integrity of the file.
NODE:TEST:/ora/admin/testrestore>dbv  file=TEST_get_file_test.f

DBVERIFY: Release 10.2.0.5.0 - Production on Fri Apr 1 09:47:34 2011

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

DBV-00600: Fatal Error - [21] [2] [0] [0]

I have searched metalink for 10.2.0.5  nothing turned  up there is a solution for the same Bug if it appears in 11.1.0.6  - [ID 731546.1]

But I have found the below solution for 10.2.0.5 and it worked.

Solution: 
Provide the full path of  the file even though you are in the same location doesnt matter  you mention the blocksize or not but good to mention

NODE:TEST:/ora/admin/testrestore>dbv file=/ora/admin/testrestore/TEST_get_file_test.f blocksize=8192

DBVERIFY: Release 10.2.0.5.0 - Production on Fri Apr 1 09:59:16 2011

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

DBVERIFY - Verification starting : FILE = /ora/admin/testrestore/TEST_get_file_test.f


DBVERIFY - Verification complete

Total Pages Examined         : 64000
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 14
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 63986
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 249167 (0.249167)

.

No comments:

Post a Comment