Database Administration (MOSC)

MOSC Banner

Recreating a corrupt index

edited Dec 30, 2012 2:40PM in Database Administration (MOSC) 14 commentsAnswered

I am having problems with redo logs not applying to a standby database. Getting the error 'redo is inconsistent with data block'. I traced the error to a corrupted index on the standby machine.

I tried recreating the index on the standby database, but am unable to do so. I keep getting the message 'database is read-only'. I tried making the database read/write, but each time I try to recreate

the corrupted index I keep getting the 'database is read-only' so I am not able to recreate the index. Is there a way to drop/recreate an index on a standby database?

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