Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Oracle › Using the Agent in File-Based Mode › Restore Using the Agent for Oracle in File-based Mode › Restore Complete Databases, Tablespaces, Data Files, or Control Files

Restore Complete Databases, Tablespaces, Data Files, or Control Files

You can restore complete databases, tablespaces, data files, or control files.

To restore complete databases, tablespaces, data files, or control files

1. Shut down the Oracle server. If you prefer not to shut down the Oracle server and you are restoring only a tablespace or data file, that the tablespace offline.
2. Start Arcserve Backup and open the Restore Manager.
3. On the Restore Manager Source tab, expand the Oracle server and select the objects that you want to restore using the Restore by Tree option.

   Note: The oracle database objects are restored automatically to their original locations. If you are restoring to the original locations, you do not need to select a destination.

   Remember these considerations when selecting the objects that you want to restore:

   • To restore the control file, select the ~CONTROLFILE object. The restore process saves the control file as CONTROL.SIDNAME in the agent home directory. You can then use the MS-DOS copy command to copy the restored control files to the appropriate directory.

     Important! You must overwrite all default database control files with the restored ones using the format

     copy CONTROL.ORCL path\CONTROL01.CTL
     

     For more information about restoring a control file, see the Oracle documentation.

   • To restore either the system tablespace or a tablespace containing rollback segments, shut down the database and perform a full database restore.
   • In Tree view, to restore an older session of a tablespace, click Recovery Point and select the session you want to restore. After you have selected a session, click OK, and then finish the rest of the restore procedure.
   • If your current control files and the archived redo log files are not damaged, you may not want to recover the backed up control files and overwrite the current control files. Keeping the current control files allows you to restore your database to the latest usable version.
4. If you are restoring to a different server than the original server, click the Destination tab.

   In the Destination tab, first select the Windows System, and then select the file directory on the server to which you want to restore.

   Note: You may need to move the Oracle files into their proper locations manually after the restore is finished. If the Oracle database has multiple archived log directories and archived log files are restored, copy the restored files to all of the archived log directories to synchronize them.

   You cannot browse the individual tablespaces within the database, because you must restore database objects to the parent container and not to the individual objects themselves.

5. Click the Schedule tab for scheduling options.
6. Click Submit.

   The Session User Name and Password dialog opens.

7. To enter or change the user name and password (including the session password) for the computer on which the source Oracle server is running, select the session and click Edit.
8. Enter the user name SYSTEM (for Oracle 9i, 10g, 11g, or 12c), or a user with SYSDBA equivalent privileges and the password for your Oracle server.

   Click OK.

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