-
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
Nwcomer
Student
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|