An Oracle database can be restored to its original location or to a new temporary directory.

How to restore an Oracle database from backup

The first step in restoring an Oracle database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the Oracle database environment.

To restore files backed up using a file-level backup plan follow this guide.

If the database files are restored to a temporary directory, run the following command in the CLI:

• /opt/XoperoONEBackupAgent/Xopero.Device.App — path to the Xopero ONE application

• --oracle-restore — parameter used to restore the Oracle database

• database_ID — ID of the database to be restored

• backupuser — user with permission to restore the database

• /home/backupuser/oracle/oracle_database_dump — path to the directory containing the restored database files

If the restore completes successfully, information about the restored database will be displayed on the screen:

Restoring the database to the source host when part of it is unavailable

If part of the database is currently unavailable (for example, if a user deleted a table), the restoration process described above may fail, as the deletion is a more recent operation in the database.

The solution is to run the modified command:

The last optional parameter, required only when restoring to the source host, should be set to true. This ensures Xopero sets the SCN (System Change Number) to the point immediately after the backup.

Setting this parameter resolves issues with unrestored parts of the database. The restoration method described in the first section of this article will still work, but it may not always produce the expected results.

Microsoft SQL database can be restored to its original location or to a new temporary directory.

How to restore Microsoft SQL database from backup

The first step in restoring a Microsoft SQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the Microsoft SQL database environment.

To restore files backed up using a file-level backup plan follow this guide. If your database was backed up using an image-level backup, use granular recovery to restore it as described in this article.

Once the database files are restored, the next step is to import them into the Microsoft SQL environment.

1

Open the Microsoft SQL Management Studio.

2

Log in to the directory tree, right-click Databases, and select the Restore Database option.

3

In the opened window, select Device as the backup source and provide the path to the folder containing the *.bak database dump file.

4

After selecting the *.bak file, click OK.

5

The database has been successfully restored and is now listed in the directory tree.

PostgreSQL database can be restored to its original location or to a new temporary directory.

How to restore PostgreSQL database from backup

The first step in restoring a PostgreSQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the PostgreSQL database environment.

To restore files backed up using a file-level backup plan follow this guide. If your database was backed up using an image-level backup, use granular recovery to restore it as described in this article.

Once the database files are restored, the next step is to import them into the PostgreSQL environment.

MySQL database can be restored to its original location or to a new temporary directory.

How to restore MySQL database from backup

The first step in restoring a MySQL database from backup is to restore the database files from storage to a temporary directory. These files will then be imported into the MySQL database environment.

To restore files backed up using a file-level backup plan follow this guide. If your database was backed up using an image-level backup, use granular recovery to restore it as described in this article.

Once the database files are restored, the next step is to import them into the MySQL environment. To restore the database to the MySQL server, use a database management tool.

mysql -h SERVER_ADDRESS -u USER -p

USE DATABASE_NAME

CREATE DATABASE DATABASE_NAME

SOURCE PATH_TO_FILE

Useful links and items