Database Backup and Recovery (MOSC)

MOSC Banner

Error reCreating the Controlfile

edited Jul 12, 2009 11:22AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
Hi all

After several failed intents to open a 10g database runnig on a AIX 5.3 box (most likely cause for a corruption of OS security level files), my client dicided to recreate the database controlfile with the resetlogs option but forgot to include all data and indexes datafiles as part of the create stmt, and now the database is open but empty, all data and index datafiles appearing as MISSING xx OFFLINE.

After that We've tried to recreate the controlfile adding all missing datafiles but oracle says : ORA-01189 file is from a different RESETLOGS than previews files, and controlfile recreation does not succeeded.

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