Backup/Restore Pro-Isam Data

** This utility is under development and is not yet available. **

Although SRM software utilizes an Oracle database, certain control files are stored in a Pro-Isam format to maximize efficient file sharing and minimize file locking.
 In the event of a system crash Oracle can provide an easy rollback recovery, and then this utility can be used to restore the Pro-Isam files to ensure that these critical control files are reset synchronized with the Oracle tables.
 Rollback errors can be viewed in the Rollback Log.

The Pro-Isam files include:

 GLLR   - LAST USED
 GLLD   - DIVISION LAST USED
 GLPF   - POSTING CONTROL FILE
 ARCL   - CUSTOMER LAST USED SITE NUMBER
 SFLR   - GLOBAL UPDATE CONTROL FILE
 RUNFUN - GLOBAL UPDATE CONTROL FILE
 UPDATE - GLOBAL UPDATE CONTROL FILE
 

Backup

Any program that changes one of these Pro-Isam files such as use of an incremental Contract #, or addition of a new customer using the auto-assigned customer number, automatically generates a Backup of the Pro-Isam files to an Oracle table. This ensures that if crash recovery is required the Pro-Isam data is included in the Oracle rollback database.
 This Backup utility can be used to force a manual backup if desired.

Restore

Since the Pro-Isam information has been copied regularly to an Oracle table, it can be recovered along with the Oracle rollback recovery process, and then using this Restore utility, the Pro-Isam files can be reset to match the Oracle database.

Another application for use of the Backup/Restore Pro-Isam files tool, would be when all the data in the Oracle database is being exported. i.e. to create/copy to a new company or to refresh the "Play" company
 By utilizing the Pro-Isam Backup before making the copy, and the Restore after loading or refreshing the company, the critical control files are maintained in sync.

Note: Backup and restore can also be started from the command line, by running the script "proisam_backup_restore" and selecting either Backup or Restore. This will perform backup and restore for all SRM data directories installed on the system.

Topic Keyword: GLLU03