Restoring and Recovering Data › Restore Manager › Restore Databases and Database Objects

Restore Databases and Database Objects

To restore a complete database backed up offline or online

Note: Before starting the Restore Manager, be sure to start Arcserve Backup.

1. Open the Restore Manager, select the Source tab, and then select the Restore by File System view.
2. Expand the Linux Agent, and then expand the Oracle host under the Linux Agent.
3. Select the database you want to restore, or select the database objects to restore.
4. Select the Destination tab, and expand the Linux Agent.
5. Click the plus sign to the left of the Oracle SID under the Linux Agent.

   The Login dialog opens.

   If you did not click the plus sign to the left of the Oracle SID and you clicked directly on Oracle SID instead, you must enter the Oracle User Name and Password on the Oracle Options tab. These two fields are mandatory. In addition, since the Use RMAN catalog (Recommended) option is checked by default, you must enter the Owner Name and Owner Password of the RMAN catalog, unless the box is unchecked.

   If information from one of the mandatory fields is missing during the registration of the job, a dialog will display allowing you to enter the missing information. If you do not enter the missing information, the job will not be registered.

6. Enter the system user name and password and click OK.
7. Click the plus sign to the left of the Oracle database you want to restore.

   The database Login dialog opens.

8. Enter the Oracle dba user name and password and click OK.

   Note: Be sure that the Oracle user name and password you use to connect to Oracle has the permission to connect to Oracle using the as sysdba clause. You must be able to connect with and without this clause.

9. To set restore options, select the Source tab and then click the Oracle Options tab:

   You can select the following Restore Options:

   Note: You can choose any combination of the options.

   • If you want RMAN to speed up the restore process when there are numerous tapes involved, choose the Number of Channels (Streams) option. Select more than one channel and RMAN will accept this value as the maximum number of channels to use during the restore.
   • If you want to restore using the latest available backup, choose the Restore From Latest Backup option.
   • If you want to restore a backup with a specific date and time, select the Restore From Backup Made On option. Note that RMAN will perform the operation on files up to, but not including, the specified time.
   • If you want to restore a backup with a tag you used during the backup process, select Restore From Backup Tag option.
   • If the archived redo logs are damaged or were removed as a result of a previous backup that used the Purge Log option, select one of the options (except Do Not Restore, which is the default) in the Archived Logs Selection section of the Advanced Oracle Options tab. This overwrites the archived redo logs.

     Note: If your archived redo log files are not lost or corrupted, generally you should not overwrite them. By keeping the archived redo logs, you can recover your database to the latest usable version that existed before your system or database failed.

   • If you want to restore the control files, you must select the Include Control File option on the Advanced Oracle Option tab.

     Note: Restore control files only when necessary, such as when they are missing or corrupted.

   In addition to the Restore Options, you can select these Recovery Options:

   • If you do not want to perform a recovery after restoring the data, select the No Recovery option.

     Note: This option is checked automatically.

   • If you want to recover the database as closely as possible to the present time, select the Until the End of Logs option.
   • If you want your database objects to be available as soon as recovery is complete, select the Put Restored Object(s) Online After Recovery option.

   Note: For more information about other recovery types, see Restore Manager.

10. Click Submit.

    The Submit Job dialog opens.

11. Schedule the job to run now or at a later time.

    Click OK to submit the job.

    The job is submitted. You can monitor job in the Job Status Manager.

When the job is completed, the database objects are restored to the Oracle server. For instructions on recovering the Oracle database, see Database Recovery. For more information about submitting restore jobs, see the Administration Guide.