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
-
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.
-
-
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
-
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.
-
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.
-
-
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
-
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.
-
-
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