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:

  1. Use the PROQUIET command to enable a database quiet point:
  2. proquiet dbname enable 
    

    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.

  3. Use an operating system utility to perform the OS mirror fracture or split operation.
  4. Upon successful completion of this command, the fractured disk contains a duplicate of the active online database.

  5. Use the PROQUIET command to disable the database quiet point:
  6. proquiet dbname disable 
    

    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."

  7. 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.
  8. 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:
  9. prostrct repair dbname [ description-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.

  10. Use the PROBKUP utility with the -norecover startup parameter to back up the fractured version of the database:
  11. probkup dbname -norecover 
    

    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