Introducing Arcserve Backup Agents and Options › Using Options › Enterprise Option for SAP R/3 for Oracle › Using the Option with Agent for Oracle › Database Restore with the Option › Best Practices for Restoring Data › Restore the System Tablespace

Restore the System Tablespace

You can use the following procedure to restore the system tablespace.

To restore the system tablespace

1. Shut down the database.
2. Open the Restore Manager.
3. On the Source tab, select the Restore by Tree view and select the tablespace you want to restore.

   Note: The Oracle database objects are automatically restored to their original locations. You do not need to select a destination.

4. Click the Schedule tab and select the scheduling options you want to apply to this job.
5. Click Submit.

   The Session User Name and Password dialog opens.

6. To enter or change the user name and password (and the session password) for the machine on which the Oracle server is running, select the session and click Edit.
7. Enter the user name and password:
   • For Oracle 9i and 10g, enter the user name SYSTEM.
   • For any version, the user name can also be any account with SYSDBA equivalent privileges.
8. Click OK.

   The job is submitted to the queue and can be monitored from the Job Queue Manager.