Previous Topic: Restore Archive LogsNext Topic: Restore a Database Backed Up Offline

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 a System Tablespace

Restore a System Tablespace

Use the following procedure to restore system tablespace.

To restore a system tablespace

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

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

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

    The Session User Name and Password dialog opens.

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

    Click OK.

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