Setting up a new Control-M/Server mirror database

This procedure describes how to set up a new Control-M/Server mirror database. After Control-M/Server has been installed, Control-M/Server mirror database can be set up at any time.

NOTE: BMC recommends that the primary and mirror databases should be hosted on separate servers.

NOTE: If you want build your mirror database using Oracle DB Link (fast copy), you must contact your DBA to grant the right schema permissions to Control-M/Server.

Before you begin

Ensure the following:

• The new database complies with the relevant Database parameters. You can prepare the secondary database server from the CD provided with the product, or from a Control-M/Server that is not your primary Control-M/Server (for a third-party database, you should prepare it in the same way as the primary database).
• The new database server is running.
• (Oracle databases only) The listener is running.

To set up a new Control-M/Server mirror database:

1. On the host computer, shut down the primary Configuration Agent and Control-M/Server by typing the following commands:
   • shut_ca
   • shut_ctm
2. In Control-M/Server, type the ctm_menu command.

   The Control-M Main Menu appears.

3. Type the number for Database Mirroring.

   The Database Mirroring Menu appears.

4. Type the number for Initialize Mirroring.
5. Do one of the following:
   • To build a new database, type b.
   • To copy an existing database, type c.

   NOTE: If you plan to build a mirror database, you need the password of the database system administrator.

6. At the prompts, type the relevant Mirroring parameters.

   NOTE: Ensure that you do not change the values of the parameters. If you do change the parameters, they cannot be implemented until you shut down and restart the SQL Server.

7. If you need to install, type i and confirm.
8. Perform any post-processing that the interactive utility instructs.
9. To check Mirroring status, repeat steps 2 and 3 and type the number for Check Mirroring Status.
10. On the host computer, restart the primary Configuration Agent and Control-M/Server by typing the following commands:
    • start_ctm
    • start_ca

    All processing is executed on the primary and mirror database.