Progress
Database Administration
Guide and Reference
Using Database Quiet Points
If you use OS disk mirroring to provide data redundancy as part of your backup and recovery strategy, you can use database quiet points to maintain database consistency during an OS mirror fracture or split operation on an active online database.
Follow these steps to maintain database consistency during an OS mirror fracture or split operation on an active online database:
- Use the PROQUIET command to enable a database quiet point:
dbname specifies the name of the database for which you are enabling a database quiet processing point.
NOTE: For more information on and the complete syntax for the PROQUIET command, see Startup and Shutdown Commands."During a database quiet processing point all file write activity to the database is stopped. Any processes that attempt to start a transaction while the quiet point is enabled must wait until you disable the database quiet processing point.
- Use an operating system utility to perform the OS mirror fracture or split operation.
Upon successful completion of this command, the fractured disk contains a duplicate of the active online database.
- Use the PROQUIET command to disable the database quiet point:
dbname specifies the name of the database for which you are disabling the database quiet processing point.
For more information on, and the complete syntax for, PROQUIET, see Startup and Shutdown Commands."
- Update the structure description (.st) file of the fractured version of the database. Replace the logical location reference (which still references the active database) with the physical location reference of the fractured mirror.
- Use the PROSTRCT utility with the REPAIR qualifier to update the shared memory and semaphore identification information to reflect the offline status of the fractured version of the database, and to update the file list information for a database with the information in the updated .st file:
dbname
Specifies the name of the database for which you are repairing the extent list and master block.
description-file
Specifies the name of the structure description (.st) file.
- Use the PROBKUP utility with the -
norecover
startup parameter to back up the fractured version of the database:
dbname
Specifies the name of the fractured version of the database.
NOTE: The -norecover
parameter prevents Progress from performing crash recovery or switching to a new AI extent as part of the backup process. Use of the -norecover
parameter is noted as an entry in the .lg file.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |