Restoring a backed-up database returns the database to the state it was in when the backup procedure was performed. Transactions that occurred after the backup are lost once you restore the database.
You must have the Administrator role to restore a database.
Note: | Use transaction logging and replay, along with database backup and restore, to capture ongoing transactions that can be used to recover the database to its most recent state, not just to the state the database was in when it was backed up. |
To restore archived databases:
From Enterprise View or a custom view, right-click a database and select Restore Database.
Select the database archive file to be restored from the list or enter the path and filename of the archive file.
Optional: If the database used disk volumes, click Advanced.
You can restore the database to the same disk volumes or you can enter different disk volume names.
The number of disk volumes used and the space required for the restored database must be the same as for the database before it was backed up. Only the name of disk volumes can be modified. For example, you can replace disk volume “C” with “F” and “D” with “G.”
If the names of the backed up database and application are not the same as the application and database to which you are restoring data, select Force restore.
Optional: To continue working in the console while the restore operation is performed, select Restore in the background.
Click OK.
“Retrieving Archive File Information” in the Oracle Essbase Database Administrator's Guide
alter database (MaxL) in the Oracle Essbase Technical Reference