Enabling archiving of a Control-M/Server database (Oracle and PostgreSQL only)

This procedure describes how to archive database log files when they become full.

NOTE: If a database crash occurs, you can use the archived files to restore the database up until the most recent SQL transaction. Hot backups require that archive mode be enabled, but the backup procedure automatically sets archive mode if it was not previously set. For more information about hot backups, see Database backup and restore.

To enable archiving of a Control-M/Server database:

1. Display the Control-M Main Menu by typing the ctm_menu command.
2. In the Control-M Main menu, enter the number for the Database Menu option.

   The Database Utilities Menu appears.

3. In the Database Utilities Menu, enter the number for the Management option.

   The Management Menu appears.

4. In the Management Menu, enter the number for Set Database Archive Mode option.
5. At the prompt for the mode, type ON.
6. At the prompt for the destination directory, enter the name of the destination for archived log files.
7. When you are done, enter q to quit.