Hi All,
Accidently I lost my current redo members for group 5. And getting ORA 00312 while trying to restart my database.
What to do?
Thanks
Vis
Printable View
Hi All,
Accidently I lost my current redo members for group 5. And getting ORA 00312 while trying to restart my database.
What to do?
Thanks
Vis
You have to do an incomplete recovery if there is a loss of current and/or inactive nonarchived redo logs. You can only recover up to the point of failure.
connect internal
shutdown
startup mount
recover database until cancel
apply archive logs up to the point of loss
alter database open resetlogs
alter system switch logfile (make sure things work again)
shutdown
do a startup and shutdown, then check the alert log to make sure that database is functioning properly
perform a backup