Anno Domini 7-4-2005 18:29, Srini sprak aldus:
>Hi All,
>
>I am facing a grim situation, where no backups are available and temp,
>all redo, one rbs datafiles are corrupted.
>
>dat, idx and sys files are ok (checked with dbv)
>
>Tried to recover with different options and could not be successful.
>
>Do you have any suggestions/solution for this challenge?
>
>Thanks,
>Srini
>
>
>
How can temp and redo get corrupted?
- shouldn´t you be able to fix the redo logs with an alter system switch
logfile or if your database is down an alter database open resetlogs?
- can you drop and recreate the temporary tablespace
- can you delete the rollback entries out of the init.ora so that after
a restart of the database you are left only with system rollback?
- what does the alterlog say?
- is your database up or down at the moment
- are you sure that all off the datafiles are in the controlfile. Check
your V$-views after a startup mount.
Received on Thu Apr 07 2005 - 14:56:09 CDT
