Accidently I lost my current redo members for group 5. And getting ORA 00312 while trying to restart my database.
What to do?
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.
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)
do a startup and shutdown, then check the alert log to make sure that database is functioning properly
perform a backup
Click Here to Expand Forum to Full Width