How to recover an Oracle8i database when the redo log files are completely lost?

    Requires Free Membership to View

Use the following commands:

STARTUP MOUNT
ALTER DATABASE OPEN RESETLOGS;
SHUTDOWN IMMEDIATE
The OPEN RESETLOGS will re-create the missing online redo logs. After the database is shut down, take a backup of the database.

This was first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.