GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

System data block got corrupted

edited Jun 26, 2018 9:35AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

Hi,
analyze table AQ$_QUEUE_TABLE_AFFINITIES VALIDATE STRUCTURE;
analyze table AQ$_QUEUE_TABLE_AFFINITIES VALIDATE STRUCTURE
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 1, block # 8082)
ORA-01110: data file 1: '/u07/oradata/..../system01.dbf'

]$ dbv file=/u07/oradata/..../system01.dbf feedback=10000 blocksize=8192

DBVERIFY: Release 9.2.0.6.0 - Production on Fri Jan 17 01:15:32 2014

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

DBVERIFY - Verification starting : FILE = /u07/oradata/..../system01.dbf

DBV-00200: Block, dba 4202386, already marked corrupted
........

DBVERIFY - Verification complete

Total Pages Examined         : 76800
Total Pages Processed (Data) : 43009
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 9052
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1947
Total Pages Processed (Seg)  : 0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center