Restore System, or Undo Tablespaces or Data Files

You can restore system, or undo tablespaces or data files. Before you restore, you must locate the file. When you locate the files, ensure that the database is in the Open state.

Follow these steps:

1. Log into the computer where you want to restore system or undo tablespaces or datafiles.
2. Locate the user tablespaces or datafiles using the following command:

SQL> SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_DATA_FILES;

3. Change the state of the database to mount, or nomount, or shutdown before you restore the tablespaces or datafiles.

SQL> STARTUP MOUNT;

SQL> STARTUP NOMOUNT;

SQL> SHUTDOWN IMMEDIATE;

4. Log into the Arcserve UDP Console.
5. Restore the tablespaces or datafiles using the Restore Wizard. For more information on the restore process, see How to Restore From a Recovery Point.
6. Log into the destination computer.
7. Navigate to the specific folders and verify that the system, or undo tablespaces or datafiles are restored.
8. Recover the tablespace or data files.
• To recover a tablespace, enter the following command at the SQL*Plus prompt screen:

SQL> RECOVER TABLESPACE "tablespace_name";

• To recover a data file, enter the following command at the SQL*Plus prompt screen:

SQL> RECOVER DATAFILE 'path';

9. Oracle checks for the archive redo log files that it needs to apply and displays the names of the files in a sequence.
9. Enter AUTO in the SQL*Plus prompt screen to apply the files.
10. Oracle applies the log files to restore the data files. After Oracle finishes applying the redo log file, it displays the following messages:

Applying suggested logfile

Log applied

11. After each log is applied, Oracle continues to apply the next redo log file until the recovery is complete.
10. Enter the following command to bring the tablespace online:

SQL> ALTER TABLESPACE "tablespace_name" ONLINE;

The tablespace is now recovered to the last available log file.