Re: accidentallly deleted 2 REDO logs, ora 9.2

wow, that was WAY too easy. Thank you all.

How did people solve problems before usenet? Did they actually have to learn the stuff ? ;)

Here's what I did:
1) use enterprise manager to mount the DB (DB dummies like me don't know how to mount) -sqlplus won't let you on when redo's are messed up 2) select * from v$log , find which groups are inactive - should correspond to the redo logs that are missing 3) "alter database clear logfile group 1", repeat for 2 4) restart the DB!

chris Received on Thu Nov 10 2005 - 15:31:17 CST