You have the option to either recover or restore Oracle tablespaces or datafiles. If you recover the datafiles, Backup Professional will ensure that the tablespace or datafile is offline, restore the data to its original place, recover the data and place the datafiles online again. This cannot be done with the System tablespace since it has to be online when you restore it.

The first step is to retrieve the files that you want to restore from the Storage Platform.

1. Click on the Restore tab and select the dump folder from the specific backup date.
2. From the File menu, click Restore.
3. Select a restore location and restore the files. Do not recreate the directory structure.

1. After you have selected the recovery folder (the folder to where you restored the data) click on Retrieve Tablespaces. A list of the available tablespaces will be displayed. Restore control files must be enabled when you do a full restore.
2. When you click on Restore, the Backup Client will remind you to make sure that the database is offline. If you are only restoring a few datafiles, make sure that they are offline before continuing.
3. Change the necessary settings and click on Restore.
4. The Backup Client will restore the selected files to their original location but they will not be recovered.
   After the client has restored the files, you have to manually recover the files and start the database.

The following examples provide some help if you prefer to restore the data using SQL Plus.

Recovering a Closed Database

Media or hardware failure

1. Determine which datafile or datafiles need to be recovered.
2. Shutdown immediately
3. Open the Backup Client and restore the dump directory from the Storage Platform. Open the Oracle Restore tab and select the files that you want to restore. Click on Restore.
4. Open SQL Plus with the following command: sqlplus /nolog
5. Connect / as sysdba
6. Mount the database with the startup mount; command
7. Recover datafile 'c:\data\datafile1.dbf'; or recover tablespace tablespacename; or recover database;
8. Open database

Recovering an Opened Database

Media or hardware failure (Not the System Tablespace)

1. Determine the datafile or datafiles that need to be recovered.
2. Open sqlplus /nolog and connect /as sysdba
3. Take the datafile offline alter database datafile 'filename' offline;
4. Open the Backup Client and restore the dump directory. Select the datafile that you want to restore.
5. Recover datafile 'c:\data\datafile1.dbf'; or recover tablespace tablespacename;
6. Bring the tablespace or datafile online (Step 16 in the next section – Recovery/Full Recovery)
7. Recover datafile 'c:\data\datafile1.dbf'; or recover tablespace tablespacename;
8. Recovering a Database
9. Media or hardware failure (System Tablespace)
10. Unlike other tablespaces, the SYSTEM tablespace must be available in order to open the database. Therefore, if any members of the system tablespace are damaged, they must be restored now. Before doing this, make sure that the database is not open. It may be mounted. To make sure, run the following command on the mounted, closed database.
    
11. C:\Oracle\Ora92\bin>sqlplus / nolog
12. connect / as sysdba
13. select status from v$instance;

The following will be displayed:

STATUS

MOUNTED 1 row selected.

14. If the database is not open, restore the damaged files from the most recent backup available restore dump directory and select the datafiles. Once all damaged files in the system tablespace are restored, run the following command on the mounted, closed database:
    • recover tablespace system;
    • alter database open;
    • quit

Full Media Recovery - Recovery to the same location

1. Open SQL Plus and stop the database with the shutdown abort; command.
2. Open the Backup Client and Restore the entire dumpfolder from the Storage Platform.
3. Open the Oracle Restore tab and restore all files including the control files.
4. Mount the database in SQL Plus: startup mouna
5. Recover database using backup controlfile; Accept the default path that is suggested
6. When restoring the log files. If the last log file cannot be located run the recover database using backup controlfile; command again and supply the path to the redo folder that you restored as well as the filename of the redo log file within that folder.
7. Alter database open resetlogs;
8. The Oracle database will be opened and ready.