Menu

Oracle Server Restore

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 IDrive 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 IDrive servers.
  • Provision to generate the log files for each restore session.
Requirements for restore
  • Install the IDrive application on the computer where the Oracle 9i/10g server/client is available
  • The 'IDOracleBackup' 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 IDrive 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 IDrive application and click the ‘Restore’ tab.
  2. Locate and select the ‘IDOracleBackup' folder in your IDrive account.
  3. Click 'Restore Now', to restore the ‘IDOracleBackup' folder to the local computer.
    Note: The 'IDORACLEBackup' 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 choose the 'IDOracleBackup' folder (restored earlier from your IDrive account).
  9. Click Restore.
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 IDrive application and click the ‘Restore’ tab.
  2. Locate and select the ‘IDOracleBackup' folder in your IDrive account.
  3. Click 'Restore Now', to restore the ‘IDOracleBackup' folder to the local computer.
    Note: The 'IDORACLEBackup' 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 'Restore'.
View the steps to backup Oracle server.