Control-M Hot backup

Control-M archiving requires to be turned on in order to be able to take hot backup of database. Hot database backups jobs can also be created and scheduled by Control-M administrator so that backup is taken periodically and without any manual intervention.

Below is the steps to turn on Archiving ON and take Hot backup.

In order to take hot backup, archiving must be on. So first steps is to turn archiving on. You need to give path of a directory where archiving files will be getting created periodically. So Prior to turn Archiving on make sure you have created folder where you want your archiving files to be stored.

Steps to turn archiving on:

a.       Run command prompt as an administrator

b.      Run “ctm_menu” from command prompt. Select “database menu” from list of available options

a.       Select “management”

Select “Set Database Archive Mode” . In Mode give “ON” in Archive Directory option give “<path of your directory where you want to keep archive files>”.

You need to restart database for changes to take effect. So select “stop database” and after that select “start database” so that database restarts.

Now select "q" to quit and go back to previous options. Select "maintenance" and you will be presented with the below options:

Select "Hot Database Backup". It will ask for the Backup directory and database administrator password. Provide those details so that backup is successfully initiated. Hot backup generally does not take more than 15 minutes for medium sized environment.

Note: Control-M hot backup does not take require any downtime. 

Hope it helps. Please comment if you need any help.