Previous Topic: Database Recovery in File-Based ModeNext Topic: Recover Complete Databases and Control Files


Recover Complete Databases

After you have completed a successful restore of a database, you must use the Oracle Server Manager Console to recover the database.

To recover complete databases

  1. Start the database instance and mount the database without opening it:

    At the SQL*Plus prompt enter:

    CONNECT SYS/SYS_PASSWORD AS SYSDBA;
    STARTUP MOUNT
    

    Note: You may use a different Oracle SYSDBA instead of SYSTEM if the SYSDBA has the proper backup and restore privileges.

  2. Start the database recovery process by entering the following command at the SQL*Plus prompt:
    RECOVER DATABASE
    

    Oracle checks for the archive redo log files it needs to apply and prompts for the names of theses archive redo log files in chronological order.

    For example, if Oracle needs the name of the archive redo log file with a sequence number of 49, the following message displays:

    ORA-00279:	Change 10727 generated at 09/15/95 16:33:17 needed for thread 1
    ORA-00289:	Suggestion : D:\ORANT|saparch\ARC00049.001
    ORA-00200:	Change 10727 for thread 1 is in sequence #49
    Specify log<<RET>=suggested : filename : AUTO : FROM logsource : CANCEL
    
  3. If you have all of the necessary archived log files, enter AUTO to apply the files. Oracle applies the log data to restore the datafiles. After Oracle finishes applying the redo log file, the following message is displayed:
    Applying suggested logfile...
    Log applied.
    

    After each log is applied, Oracle continues to apply the next redo log file until the recovery is complete.

    Note: If Oracle returns an error indicating that the log file cannot be opened, the log file may not be available. At the prompt, enter CANCEL. This command stops the complete media recovery.

    For more information about recovery and archive redo log files, see the Oracle documentation.

  4. Open the database by entering the following command:
    ALTER DATABASE OPEN;
    

    The database is now recovered to the last log file available.

Note: For the most reliable database objects recovery, you should back up archived log files using the ~ARCHIVELOG object. For more information on database recovery, see the Oracle Documentation.