Introducing CA ARCserve Backup Agents and Options › Using Options › Enterprise Option for SAP R/3 for Oracle › Using the Option with Agent for Oracle › Database Recovery › Recover Complete Databases with Backed Up Control Files

Recover Complete Databases with Backed Up Control Files

You must also use the Oracle Server Manager or Oracle SQL*Plus to perform the recovery procedure.

To recover the complete database

1. Start and mount the database and recover the database. At the SQL*Plus prompt, enter the following commands:

   CONNECT SYS/SYS_PASSWORD AS SYSDBA;
   STARTUP MOUNT;
   RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
   

2. You are prompted to enter the log file names.

   Oracle first looks for the archive log files, and automatically supplies the correct names for the files that exist. If it cannot find the necessary archive log files, you must manually apply the online redo logs.

3. Enter the complete path and file name for the online redo logs. If you enter an incorrect log, re-enter the command:

   RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
   

   Now enter the correct online redo log file name at the prompt. Continue this procedure until all logs have been successfully applied.

4. To bring the database back online and reset the logs, enter the following command at the SQL*Plus prompt:

   ALTER DATABASE OPEN RESETLOGS;
   

5. In the directories where the archived redo logs are stored, delete all of the log files.
6. To bring any tablespaces that are still offline back online, enter the following command at the SQL*Plus prompt:

   ALTER TABLESPACE TABLESPACE_NAME ONLINE;