How to restore Oracle database from backup?

This article contains information on how to restore the Oracle database from a backup.

How to restore the Oracle database from the backup?

The first thing, you need to do to restore the Oracle database from the backup is to restore the database files from the storage to the temporary directory, from which these will be imported to the Oracle database environment.

Read the following article to get information on how to restore files backed up using a file-level backup plan.

File-level backup recovery

Xopero recommends restoring the database files to the original directory! The reason for this is the possibility of problems with permissions to another location.

If the database files are restored to the temporary directory, execute the following command using CLI:

/opt/XoperoONEBackupAgent/Xopero.Device.App --oracle-restore database_ID backupuser /home/backupuser/oracle/oracle_database_dump

where:

• /opt/XoperoONEBackupAgent/Xopero.Device.App - path to the Xopero ONE app

• --oracle-restore - parameter responsible to restore Oracle database

• database_ID - ID of the database, which you want to restore

• backupuser - the user, which has the database backup permission

• /home/backupuser/oracle/oracle_database_dump - path to the directory with the restored database files

If the restore process is successfully finished, the information about the successfully running database will appear on the screen:

See also:

Oracle database backup

Known problems

Restoring the database to the source host, in case of the part of database unavailability

If the part of the database is currently unavailable (e.g. user deletes one table) the restoring process described above may not work, because the table deletion operation is a more recent operation for the database.

The solution is to execute the modified command:

/opt/XoperoONEBackupAgent/Xopero.Device.App --oracle-restore database_ID backupuser /home/backupuser/oracle/oracle_database_dump true

where the last (optional) parameter (which is not required, when restoring the database to the other than the source host) should be set to true. Then restoring with Xopero will set the SCN (System Change Number) to the value corresponding to the moment after the backup.

Setting this parameter will resolve the problem with the unrestored part of the database.

The present form of restoration will still work (described in this article above), but it should be borne in mind that it will not always have the effect expected by the user.