Places a database in read-only mode for archiving.
Syntax
BEGINARCHIVE App DB file| Parameter | Description |
|---|---|
App | Name of the application. |
DB | Name of the database. |
file | File to contain the archive. |
Notes
Changing the server mode to Read-only allows the database administrator to use an archiving program to back up files on the server. This also prevents writing to files during backup.
The server's Read-only state persists until it is changed back to Read-write with the ENDARCHIVE command. Unless you reset the Read-only state, it persists even after termination of the current session.
The database files to back up are listed in the application\database directory specified by the filename parameter. The archived data overwrites the information in the specified file, if the file already exists. See the Oracle Essbase Database Administrator's Guide for more information about restructuring and backup files.
Example
BEGINARCHIVE "Sample" "Sales" "June";
See Also