ctmdbrst

The ctmdbrst utility restores the Control‑M/Server database in the following cases:

  • Control-M/Server was installed by using a dedicated PostgreSQL database server. Do not use this utility if Control-M/Server was installed with an Oracle database (either existing or dedicated) or an existing PostgreSQL database.

  • To restore an existing Oracle database or a PostgreSQL database, use the ctm_restore_bcp utility, as described on ctm_restore_bcp.

  • Control-M/Server was installed by using an MSSQL database server.

For more information about backup types, see Database Operation and Maintenance.

To restore the Control-M/Server database, see Restoring the Control-M/Server Database.

Running the ctmdbrst Utility

This procedure describes how to run the ctmdbrst utility, which restores the Control-M/Server database.

Begin

  1. Do one of the following:

    • UNIX: Log in to a Control-M/Server account.

    • Windows: Open a command prompt window where Control-M/Server is installed.

  2. Do one of the following:

    • To invoke the ctmdbrst utility for Control-M/Server installed with MSSQL, enter the following command:

      ctmdbrst
      [ -f<administrator password file>]

      [ -d<full path of backup directory/file>]

      [ -m H/C]

    • (UNIX only) To invoke the ctmdbrst utility for Control-M/Server installed with PostgreSQL, run the following command:

      ctmdbrst [ -p<administrator password>]

      [ -f<administrator password file>]

      [ -d<full path of backup directory/file>]

      [ -a<full path of archive directory>]

      [ -m<restore mode H/C>]

    • (Windows only)Enter the following command at the command prompt to use the interactive menu:

      ctmdbrst

Restoring the Control-M/Server Database

This procedure explains how to restore the Control-M/Server database by using the ctmdbrst utility.

Begin

  1. Shut down Control-M/Server and the Configuration Agent before invoking this utility. Make sure that no other users or processes are connected to the SQL server.

  2. Do one of the following:

    • UNIX: Log in to a Control-M/EM database account

    • WINDOWS: Open a command prompt window where Control-M/EM is installed.

  3. Enter the following:

    ctmdbrst

    Continue the restore procedure by following the prompts.

For MSSQL – you are prompted for the backup device (<backupDevice>). This device was used to back up the Control‑M/Server database.

Running the ctmdbrst in silent mode

This procedure describes how to run the ctmdbrst utility in silent mode.

Begin

  1. Do one of the following:

    • UNIX: Log in to a Control-M/Server account

    • Windows: Open a command prompt window where Control-M/Server is installed.

  2. Enter the following command:

    ctmdbrst -pmanager –d<restoreDirector> -m<H/C> -a<archive Director>

    The following command causes the Control-M/Server database to be restored from the default backup device:

    ctmdbrst