Database Backup Procedures › Recover from an Upgrade Failure

Recover from an Upgrade Failure

Restore the CA Performance Center database from a backup archive after a software upgrade that fails to complete. If an error occurs during an upgrade of the CA Performance Center software, you must restore the database and then update the schema.

Note: Database restoration is not required after an upgrade unless a failure occurs.

Follow these steps:

1. Log in to the server as root, or use the sudo account you configured for the installation.
2. Stop all of the CA Performance Center services, using the following commands:

   /etc/init.d/caperfcenter_eventmanager stop
   /etc/init.d/caperfcenter_devicemanager stop
   /etc/init.d/caperfcenter_sso stop
   /etc/init.d/caperfcenter_console stop
   

   The services are stopped.

3. Change to the directory where you saved the backup archive. For example:

   cd /$backupDir
   

4. Uncompress the database backup archives for CA Performance Center and Event Manager by executing the following commands:

   tar zxvf netqosportal.tgz
   tar zxvf em.tgz
   

5. Import the uncompressed CA Performance Center backup file:

   mysql netqosportal -e ‘source $backupDir/netqosportal.sql’
   

6. Import the uncompressed Event Manager backup file:

   mysql em -e ‘source $backupDir/em.sql'
   

7. Change to the installation directory:

   cd /opt/CA/PerformanceCenter/Tools/bin
   

8. Run the database migration script:

   ./npcshell.sh dbmigrate -xmlMigrateFile /opt/CA/
   PerformanceCenter/SQL/_portal_upgrade.xml
   

9. Start all of the CA Performance Center services:

   /etc/init.d/caperfcenter_eventmanager start
   /etc/init.d/caperfcenter_devicemanager start
   /etc/init.d/caperfcenter_sso start
   /etc/init.d/caperfcenter_console start
   

10. Delete the uncompressed archive files to save space:

    rm netqosportal.sql
    

    rm em.sql
    

11. Log in to CA Performance Center as an administrator.
12. Verify that your configuration data appears in Admin pages.