on ‎2010 Mar 20 12:33 PM
Hi,
I got block corrupt on development server(Test system also on same area),i got this error in checkDB and verifyDB
VerifyDB:
BR0278W Command output of 'D:\oracle\DCE\102\BIN\dbv file=I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4 blocksize=8192
DBVERIFY: Release 10.2.0.4.0 - Production on Sat Mar 20 13:14:07 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4
Block Checking: DBA = 21204988, Block Type = KTB-managed data block
data header at 0x2c8625c
kdbchk: row locked by non-existent transaction
table=0 slot=37
lockid=82 ktbbhitc=2
Page 233468 failed with check code 6101
DBVERIFY - Verification complete
Total Pages Examined : 258560
Total Pages Processed (Data) : 46893
Total Pages Failing (Data) : 1
Total Pages Processed (Index): 47654
Total Pages Failing (Index): 0
Total Pages Processed (Other): 20247
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 143766
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 1251807644 (0.1251807644)
BR0398E DBVERIFY has detected corrupt blocks in I:\ORACLE\DCE\SAPDATA3\DCE_4\DCE.DATA4
checkDB:
ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []
BR0976W Database message alert - level: ERROR, line: 834150, time: 2010-03-18 16.47.26, me
ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []
kindly help
Regards
Sreekar
Request clarification before answering.
Hi Sreekar
another option is to use rman to verify files
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup005.htm
Using RMAN to Validate Database Files
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.