How to perform a database backup in Retail Pro 9 or Retail Pro Prism

How to perform a database backup when using Retail Pro 9 or Retail Pro Prism

 

Retail Pro 9 allows you to backup your database files so that you can recover those files, if necessary, at a later date. 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.

 

How to perform a database backup using TechToolkit

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 option on the screen:

• Backup Type: Select Complete or Incremental.
• Location: The location where the backup file will be saved. 
• Set Name: Enter a name for the backup folder. The set name must not be the same as a set name that has already been created.
• Backup Archive Logs: If selected, a backup copy of the Archive Logs is created. 
• Delete Archive after backup: If selected, the archive log will be deleted after the backup is complete.
• Compress Back: If selected, the backup file will be saved as a compressed file.
• Password Protect: (This option is only available is you choose to compress the backup file). If selected, the backup file will be password protected.

1. Select Save
2. Select Backup and Recovery > Backup from the side menu.
3. 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: 

• OracleODS11gr1TNSListener
• OracleServiceRproODS
• RetailPro License Server

How to perform a manual database 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
   • OracleODS11gr1TNSListener
   • OracleServiceRproODS
   • RetailPro License Server
2. Copy and Save the following folder to a new location:
   Oracle\oradata\rproods

This saved folder is your backup file.

 

To see how to recover your database using a saved backup file, click here.