Oracle Server Restore

Requirements for restore

Enabling ARCHIVELOG Mode

Following are the prerequisites for Oracle server restore:

• Install the IBackup for Windows application on the computer where the Oracle 9i/10g/11g server/client is available
• The 'IBOracleBackup' folder selected for restore should be in the same path as it was while performing the backup operation
• The database must be in ARCHIVELOG Mode
• The Oracle server user should have SYSDBA privilege
• Oracle Recovery Manager (RMAN) should be available on the computer where the IBackup for Windows application has been installed

Consult your Oracle DBA before you perform the Oracle server restore operation.

To enable ARCHIVELOG Mode using Oracle Recovery Manager (RMAN), follow the steps given below:

• RMAN> connect target <username>/<PWD>@<SID> [connect to your Oracle database];
• RMAN> shutdown immediate;
• RMAN> startup mount;
• RMAN> sql 'alter database archivelog';
• RMAN> alter database open;

To restore the Oracle server database, follow the steps listed below:

Step 1:
From the main application menu, go to
Backup-Restore > Oracle Server > Oracle Server Restore.
Or
From the application Tool bar, go to
Wizards > Advanced Backup > Oracle Server > Oracle Server Restore.

Step 2:
The 'Oracle Server Restore Wizard' is displayed, as shown below. Click the 'Next' button.

Step 3:
Enter the authentication information and login to the Oracle server database.

Step 4:
Using the 'Browse' button, select the 'IBOracleBackup' folder where the Oracle server database files were backed up.

Note: The restore folder 'IBOracleBackup' that you have selected should be in the same path as it was while performing the backup operation. In case you have deleted the folder, then create a folder with the same name and in the same path, as it existed during the backup operation.

Step 5:
Click the 'Restore' button to commence the restore process. A message, as shown below appears. Click 'Yes' to proceed with the operation.

Incomplete Recovery

Incomplete Recovery is a time-based recovery of the Oracle databases, which restores the files as of a particular date and time, specified during the operation.

To perform the Incomplete Recovery of your Oracle database(s).

Perform the above-mentioned steps till Step 3

Step 4:
On the Oracle restore screen, select the option 'Incomplete Recovery' and double-click the database name. A dialog appears from which you can choose the date and time.

Click the drop-down arrow, a Calendar appears. Here, select the date and then the time using the up-down arrow keys or by just entering the time and click the 'Save' button.

The date and time selected for 'Incomplete Recovery' of the databases should not be less than the database creation time or reset logs creation time.

Click the 'Restore' button and follow the procedure as detailed in Step 5.