Lost Current redo member -- ORA00312
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Lost Current redo member -- ORA00312

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    163
    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width