Updated: October 18, 2019 8:39am

Backup and Recovery

This article explains how to back up the Retail Pro Prism database and then restore the database (from the backup), in two different scenarios.

Scenario 1 describes 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 describes 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.

Backup Retail Pro Prism Database
You must perform a backup of your Database 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 back up (copy and save) the WebClient folder. This is done to save things like screen layouts and translations, since they are not stored in the database.

  1. Create a backup using TechToolkit, or perform a "cold" backup. Click here to view steps to perform a backup.
  2. 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.
  3. 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 - Restore database after something has gone wrong with Prism
Retail Pro Prism data resides in the Oracle database along with RIL Oracledata. Restoring a database is straightforward.

  1. 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.
  2. 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
  3. 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
  4. Reinstall only the Prism Server component (without uninstalling the existing Prism Server component from your computer).
  5. 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.

  1. If you have not already done so, perform a backup (Copy and Save) of the WebClient folder:  ProgramData\RetailPro\Server\WebClient  (Note: Backing up the WebClient folder will ensure that things such as screen layouts and translations are also backed up and can be restored.)
  2. Remove (uninstall) all traces of Retail Pro Prism from your computer. Click here to view steps to completely remove all components of Prism
  3. Reinstall all Retail Pro Prism components to your computer. (Apache, Prism Server, Prism Proxy, Retail Pro 9 / Prism DRS, & Prism Document Designer)
  4. Validate that you're able to login to the fresh RP Prism installation without any errors.
  5. 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
  6. Reinstall only the Prism Server component (without uninstalling the existing Prism Server component from your computer).
  7. Restore the WebClient folder (if needed).
  8. 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.

Backup Database (RIL and Prism)
RIL Prism Management Tech Toolkit allows you to back up your database files so that you can recover those files, if needed. By backing up your database, you protect your business from data and financial loss that can result from a hard disk crash or other unforeseen event. You can perform two types of backups: Complete or Incremental. A complete backup is a backup of all your database files. An incremental backup is a backup of only the changes made to the database since the last complete backup occurred.

Backup Database using Tech Toolkit

  1. Launch the Technician's Toolkit (RetailPro9\TechToolkit.exe)
  2. On the left-hand side of the screen, select: Backup and Recovery > Backup > Options
  3. Select your preferred backup type: complete or incremental. Enter the location where the backup file will be saved. In the Set Name field, enter a name for the backup folder (unique name required). Select whether to backup archive logs and delte the archive after backup. If you compress the backup file, you have the option of securing it with a password (required to decompress the file).
  4. Select Save.
  5. Select Backup and Recovery > Backup from the side menu.
  6. Select Start. You backup file will now be saved in the specified location. Note: If "complete" backup was performed, then the Retail Pro related services must be restarted in order to use the Retail Pro system:
  • OracleODS12cTNSListener
  • OracleServiceRproODS
  •  RetailPro License Server

Manual Backup (a.k.a. Cold Backup)
Note: A "cold backup" is always in the form of a complete backup.  

  1. Close Retail Pro related services: OracleODS12cTNSListener, OracleServiceRproODS and RetailPro License Server.
  2. Copy and Save the following folder to a new location: Oracle\oradata\rproods. This saved folder is your backup file.