Using Arcserve UDP Agent (Windows) › Perform a Restore › How to Restore an Oracle Database › Restore the Tablespaces or Data Files

Restore the Tablespaces or Data Files

You can restore the tablespace 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. If the database is open, use the ALTER TABLESPACE. OFFLINE statement to take the tablespaces or datafiles offline before you begin the restore process.

Follow these steps:

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

   SQL> SELECT FILE_NAME, TABLESPACE_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 in to 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 in to the destination computer.
7. Navigate to the specific folders and verify that the 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';
     

     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.

   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
   

   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.