DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: B/r

  1. #1
    Join Date
    Mar 2003
    Posts
    34

    B/r

    The DB is in NoArchive Log mode & all the Online Redo Log Files are lost. How to recover whole db. What files need to be restored.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Here are some questions that will help you troubleshoot and solve your situation.

    Logs were lost when? Database open or closed? What is a cold backup? Are online redo logs copied for a cold backup? If you think not, then why do you need the current ones? If you think so, how can you recover a database using commands that involve manipulating redo logs? How do you make new online redo logs?

    http://tahiti.oracle.com
    Do a search on backup, cold backup

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    if you are sure the db was shut down cleanly before the logs were lost
    you can issue

    recover database until cancel using backup controlfile;

    alter database open resetlogs;
    I'm stmontgo and I approve of this message

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