Hey guys, I have a quick question for a scnerio...
Currently running Oracle 11g
Lets say I get an error saying corrupted redo logfile..
From my reading and search this is what i came up with and want to make sure I am on the right path
Since I am in archive log mode and each redo log group has two members who are mirroring to each other. The mirror copy is stored in lets say dev2 and the primary is in dev1.
Once i get the error and database is up and running
can i just do
alter database clear logfile group 3(if group number)
or alter system checkpoint
or must i shut the database down...and take the mirror copy in dev2 put it in dev1 use restore database?
The question might seem to be vague but Im trying to have the thought process cleared.