How to recover / restore a database backup in Retail Pro 9 or Retail Pro Prism

How to recover (or restore) a database backup in Retail Pro 9 or Retail Pro Prism:

Retail Pro 9 allows you to restore your database files if you have previously saved a backup of those database files. This will allow you to recover from issues that affect your database. By backing up your database, you protect your business from data 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.

How to perform a database restore using TechToolkit
To begin, you will need to already have an existing backup file saved.

1. Launch the Technician's Toolkit (RetailPro9\TechToolkit.exe)
2. On the left-hand side of the screen, select: Backup and Recovery > Recovery
3. Select your preferred options on the screen:
   • Recovery Type: There are four types of recovery to select from: Full, Point in Time, From a Complete Backup, or Data File Recovery.
   • Backup set location: Browse to the location of the backup file you woud like to use.
   • Target Drive: Select the Target drive on the network.
   • Backup date and time: (only available if using a Point in Time recovery) Enter the date and time for the backup. Your data will be restored to its state at that date and time.
4. Select Start. (You can select Stop at any time to cancel the recovery process).

How to perform a manual database restore (a.k.a. "cold restore")
To begin, you will need to already have an existing backup file saved.

1. Stop all Retail Pro related services.
   • Control Panel > Adminstrative Tools > Services
     • OracleODS11gr1TNSListener
     • OracleServiceRproODS 
     • RetailPro License Server
2. To perform a manual restore (a.k.a. "cold restore"), you will need to copy the contents of the backup file, and place them in the following location:
   • Oracle\oradata\rproods --- you are replacing all the files in the rproods folder with the files from your backup folder)
3. Rebuild the password file using TechToolkit:
   • Start Tech Toolkit > Select Managing Storage Structure > Select Password File > click Start > when done, shutdown tech toolkit, and restart your computer.
4. Restart all Retail Pro related services.
   • Control Panel > Adminstrative Tools > Services
     • OracleODS11gr1TNSListener 
     • OracleServiceRproODS 
     • RetailPro License Server