Recovering and restoring the POM database

Last Updated : Oct 27, 2025 |

About this task

If you use an Oracle database, use this procedure to do the following:

  • Recover the backup file of the POM database.

  • Restore the backup file on a POM server.

Before you begin

Ensure that you have SYSDBA user privileges.

Procedure

  1. To connect to the POM database as a user with SYSDBA privileges, run the following command:

    sqlplus / as sysdba

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

    shutdown abort;

  3. To delete all CTL files and DBF files, run the following command:

    oradata\pomdb

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

    rman target /

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

    startup nomount;

  6. To reconnect RMAN to the POM database, run the following command:

    rman target /

  7. To restore the control file, run the following command:

    restore controlfile from ‘control_file_name’;

  8. To mount an instance of the POM database, run the following command:

    alter database mount;

  9. To restore the POM database, run the following command:

    restore database;

  10. To recover the POM database, run the following command:

    recover database;

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

    alter database open resetlogs;