Database Backup and Recovery (MOSC)

MOSC Banner

Salvage data from database with data dictionary corruptions

edited Nov 9, 2011 7:03AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
Hi,
A database has experienced some damages - finally we have a running instance (with things like _allow_resetlogs_corruption=true).
  1. We can only connect to the database as sys (works through network too). Connection as ordinary user doesn't work (results in ORA-01033)
  2. Export doesn't work (since some data dictionary objects are not available)
  3. Creating new objects, granting some privileges - doesn't work either
  4. We can select data from some of the application tables (i.e. they have not been completely damaged)
  5. We can't use some of the data dictionary views (e.g. dba_data_files, dba_segments fail). Others seem to work - e.g. dba_tables, dba_objects.

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