Backing up the POM database

Last Updated : Oct 27, 2025 |

About this task

If you use an Oracle database, use this procedure to enable Oracle Recovery Manager (RMAN) to take a backup of the POM database.

After you take a backup, ensure that you take an incremental backup of the POM database.

Before you begin

Ensure that:

  • POM does not run any active imports.

  • The POM database is in the ARCHIVELOG mode.

  • You have the SYSDBA privileges such as sqlplus or sysdba.

Do the following:

  • Stop all the running campaigns on the POM server.

  • Log off all the agents.

  • Connect RMAN to the POM database.

Procedure

  1. Open an SSH session to the POM server.

    You can use an application such as PuTTY.

  2. To shut down the running instance of the POM database, run the following command:

    shutdown immediate;

  3. To start the instance and mount the POM database, run the following command:

    startup mount;

  4. To place the POM database in the ARCHIVELOG mode, run the following command:

    alter database archivelog;

  5. To open the POM database, run the following command:

    alter database open;

  6. Run the following command:

    archive log list;

  7. To identify the name of a POM database, run the following commands:

    ORACLE_SID;

    set ORACLE_SID=pomdb

    echo %ORACLE_SID%

  8. To connect RMAN to the POM database, run the following command:

    RMAN rman target /

  9. To back up the POM database, run the following command:

    BACKUP DATABASE PLUS ARCHIVELOG

  10. To take an incremental backup of the POM database, run the following command:

    BACKUP INCREMENTAL LEVEL 0 DATABASE;