You can back up a block storage database at a particular point in time and later restore the database to that same state. In backing up a database, Essbase writes a copy of the database files to a single archive file. The database archive file contains information about the database that was backed up, such as the application and database name, the time the backup was performed, and disk volume names. When needed, you can restore the database from the archive file.
To back up a database, you must have the Administrator role.
Note: | Oracle recommends that you use database backup and restore with transaction logging and replay, as part of a comprehensive backup and recovery strategy. |
To archive databases:
From Enterprise View or a custom view, right-click a database and select Archive Database.
Enter the path and filename of the archive file to be created.
The path must be to an existing directory on the Essbase Server computer. Oracle recommends that you name the file with a .arc extension. The size of the archive file is limited only by disk space.
Note:
The archive file must be saved to a file system that supports large files. For Windows, the file system must be formatted as NTFS. For UNIX, large file support must be enabled. See your operating system documentation.
Optional: To continue working in the console while the archive operation is performed, select Archive 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
query archive_file (MaxL) in the Oracle Essbase Technical Reference