Veeam: restore a database from a backup
Restore methods for an Oracle or SQL Server database with Veeam Backup & Replication 12 and the Database restore wizard.
Memo on restoring a database (Oracle or SQL Server) from a Veeam Backup & Replication 12 backup.
Restore methods
- Restore the entire virtual machine (handled by the infrastructure team).
- Restore the database from the Veeam console (wizard described below).
- Restore with RMAN (wizard or command line) for Oracle.
Restore a database from the Veeam console
The restore is done from a machine that has the Veeam, Oracle and SQL Server clients.
- Connect to the Veeam Backup & Replication console, giving the backup server, the service port (9392 by default) and an account.
- Click Restore in the ribbon, then choose Restore from backup.
- In the wizard, choose Database restore: it restores a database to a point in time, to the original server or to a different one.
Notes
- On AIX, do not forget the NFS configuration for Oracle.
- The steps after choosing "Database restore" (database, restore point, target) were not in the note.