Restoring a Control-M/Server Oracle or PostgreSQL database from a backup

This procedure describes how to restore the Control-M/Server Oracle or PostgreSQL database are down as the result of a crash. If this is not the case, the restore procedure fails.

NOTE: Performing this procedure has the same effect as running the ctmdbrst utility.

Before you begin

If you want to perform a restore from a Cold backup and Archive mode is active, deactivate Archive mode (using option 1 of the Database Maintenance menu) before performing the steps described below.

To restore a Control-M/Server Oracle or PostgreSQL database from a backup:

1. Shut down Control‑M/Server, and verify there are no other users or processes connected to the SQL Server.
2. Display the Control-M Main Menu by typing ctm_menu command.
3. In the Control-M Main menu, enter the number for the Maintenance option.
4. In the Maintenance menu, enter the number for the Restore Database option.

   The following prompt appears:

   Enter a destination directory name [<ctm_home_dir>]:

5. Press Enter to accept the default directory, or type the name of the directory in which the backup was saved.
6. When you are done, enter q to quit.

   Control-M performs the restore as follows:

   • If Archive mode is not active, a restore is automatically performed using information from the most recent Cold backup.
   • If Archive mode is active, a restore is automatically performed using information from the most recent Hot backup.

   (For PostgreSQL only) - If a hot restore process failed, it is possible to revert back to the file system as it existed before the restore process began. For details, see the following instructions.

   NOTE: The hot restore process uses the ctm_em/pgsql/data/pg_xlog directory to recover the database up until the point of failure. If this directory was damaged during the failure, the database can only be recovered up until the last database log switch.