Salvage data from database with data dictionary corruptions
Hi,
A database has experienced some damages - finally we have a running instance (with things like _allow_resetlogs_corruption=true).
- We can only connect to the database as sys (works through network too). Connection as ordinary user doesn't work (results in ORA-01033)
- Export doesn't work (since some data dictionary objects are not available)
- Creating new objects, granting some privileges - doesn't work either
- We can select data from some of the application tables (i.e. they have not been completely damaged)
- 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.
0