Menu

Database Backup

Oracle Server Restore

Choose from time-based recovery or complete recovery options to restore your Oracle database.

The Oracle server Restore feature allows you to restore your Oracle server databases from your IBackup account.

Features
  • Authentication of Oracle server database for restore.
  • Provision to restore the Oracle database using Complete and Incomplete recovery methods.
  • Provision to report the progress of the restore process.
  • Enhanced security as data is transferred and stored using 256-bit AES encryption with a user-defined key that is not stored anywhere on the IBackup servers.
  • Provision to generate the log files for each restore session.
Requirements for restore
  • Install the IBackup application on the computer where the Oracle 9i/10g 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 application has been installed

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

Enabling ARCHIVELOG Mode

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:
  1. Login to the IBackup application and click the ‘Restore’ tab.
  2. Locate and select the ‘IBOracleBackup' folder in your IBackup account.
  3. Click the 'Restore Now' button, to restore the ‘IBOracleBackup' folder to the local computer.
    Note: The 'IBORACLEBackup' folder selected for restore should be in the same path as it was while performing the backup operation.
  4. Once the folder has been successfully restored, click the ‘Server Backup’ tab.
  5. Under Oracle Server section, click 'Restore'.
  6. Provide the relevant Oracle Server authentication information when prompted.
  7. The ‘Oracle Server backup/restore’ screen is displayed.
  8. Browse and select the 'IBOracleBackup' folder from your local computer (the location where the folder was restored earlier from your IBackup account).
  9. Click the Restore button.
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.

  1. Login to the IBackup application and click the ‘Restore’ tab.
  2. Locate and select the ‘IBOracleBackup' folder in your IBackup account.
  3. Click the 'Restore Now' button, to restore the ‘IBOracleBackup' folder to the local computer.
    Note: The 'IBORACLEBackup' folder selected for restore should be in the same path as it was while performing the backup operation.
  4. Once the folder has been successfully restored, click the ‘Server Backup’ tab.
  5. Under Oracle Server section, click 'Restore'.
  6. Provide the relevant Oracle Server authentication information when prompted.
  7. The ‘Oracle Server backup/restore’ screen is displayed.
  8. Select the ‘Incomplete Recovery’ option, and specify the date and then the time. 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.
  9. Click the 'Restore' button.


View the steps to backup Oracle server.