Recover Old Databases

Introducing 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 Old Databases

Recover Old Databases

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

To recover a database with current control files

Start the database instance, and mount the database without opening it.
Now 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.
Begin 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
```
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.
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 Oracle documentation.