Sep 20, 2024 | Retail Pro Prism
Backup and Recovery of Retail Pro Prism Database (Disaster Recovery)
Backup and Recovery of Retail Pro Prism Database (a.k.a. Disaster Recovery)
This article will first explain how to perform a backup of the Retail Pro Prism database, in order to restore the database in case a serious error with the Retail Pro Prism system occurs. This article will then explain how to perform a restoration of the database (from the backup), in 2 different scenarios.
Scenario 1 will describe the steps to take when something goes wrong with your RP Prism system. This will include restoring a previously created database backup, and restarting the RP Prism services. In this scenario, the assumption is that the issue is not severe enough to require you to uninstall and reinstall Retail Pro Prism.
Scenario 2 will describe the steps to take when something goes SERIOUSLY wrong with your RP Prism system. This will include removing (un-installing) all components of your RP Prism system, and then re-installing the RP Prism system. Next, you will restore the database using a previously created database backup as well as restarting all Retail Pro Prism related services.
How to perform a backup of your Retail Pro Prism Database.
You must perform a backup of your Database in order to recover from a serious issue with your Retail Pro Prism system. You should perform regular backups of your database to ensure you have a recent backup in the event of an issue. You can use TechToolkit to back-up the Oracle database, or you perform a "cold" backup (in which case you must manually shutdown all Retail Pro Prism related services before beginning the manual backup process). Additionally, we suggest that you backup (copy and save) the WebClient folder. This is done in order to save things like screen layouts and translations, since they are not stored in the database.
- Create a backup using TechToolkit, or perform a "cold" backup. Click here to view steps to perform a backup
- Backup (Copy and Save) the WebClient folder: ProgramData\RetailPro\Server\WebClient
- Certain Retail Pro Prism related features are not stored in the database, such as custom screen layouts and translations. Backing up the WebClient folder will ensure that these features are also backed up and can be restored.
- Backup any custom plugins, using the developer's instructions.
- After backup is complete, restart all RP Prism related services in the following order (allow for a 15-30 second pause between starting of each service).
- RabbitMQ
- PrimLicSvr
- Apache2.4
- PrismMQService
- PrismBackOfficeService
- PrismResiliencyService
Scenario 1: Restoring the Database when something has gone wrong with your Retail Pro Prism system
Retail Pro Prism data resides in the Oracle database along with Retail Pro 9 data. Restoring a database is fairly straightforward.
- If you have not already done so, perform a backup (Copy and Save) of the WebClient folder: ProgramData\RetailPro\Server\WebClient
- Backing up the WebClient folder will ensure that things such as screen layouts and translations are also backed up and can be restored.
- Perform a database restore using a TechToolkit backup, or restore from a Cold backup. Click here to view steps to restore database from a backup
- After restore is complete, restart all RP Prism related services in the following order (allow for a 15-30 second pause between starting of each service).
- RabbitMQ
- PrimLicSvr
- Apache2.4
- PrismMQService
- PrismBackOfficeService
- PrismResiliencyService
- Reinstall only the Prism Server component (without uninstalling the existing Prism Server component from your computer).
- Restore the WebClient folder (if needed).
Your Retail Pro Prism system should now be in a usable state, with data present in the database.
Scenario 2: Restoring the Database when something has gone SERIOUSLY wrong with your Retail Pro Prism system
From time to time, it may be needed to remove all traces of Retail Pro Prism from your computer, and then reinstall the Retail Pro Prism system. With a current backup, you will be able to reinstall with data intact, without the need to initialize data into Retail Pro Prism again.
- If you have not already done so, perform a backup (Copy and Save) of the WebClient folder: ProgramData\RetailPro\Server\WebClient
- Backing up the WebClient folder will ensure that things such as screen layouts and translations are also backed up and can be restored.
- Remove (uninstall) all traces of Retail Pro Prism from your computer. Click here to view steps to completely remove all components of Prism
- Reinstall all Retail Pro Prism components to your computer. (Apache, Prism Server, Prism Proxy, Retail Pro 9 / Prism DRS, & Prism Document Designer)
- Validate that you're able to login to the fresh RP Prism installation without any errors.
- Perform a database restore using a TechToolkit backup, or restore from a Cold backup. Click here to view steps to restore database from a backup
- Ensure that all RP Prism related services are running.
- RabbitMQ
- PrimLicSvr
- Apache2.4
- PrismMQService
- PrismBackOfficeService
- PrismResiliencyService
- Reinstall only the Prism Server component (without uninstalling the existing Prism Server component from your computer).
- Restore the WebClient folder (if needed).
- Validate that you're able to login to the fresh Retail Pro Prism installation without any errors.
Your Retail Pro Prism system should now be in a usable state, with data present in the database.
Author:
Brian Maupin
Tech Support Engineer
Retail Pro International, LLC