Release 10.1A: OpenEdge Data Management:
Database Administration

> ## 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, on systems with an Enterprise database license, to maintain database consistency during an OS mirror fracture or split operation on an active online database.

> | 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:

>     proquiet dbname enable

> ``dbname``

> Specifies the name of the database for which you are enabling a database quiet processing point.

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

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

> 3. Use the PROQUIET command to disable the database quiet point:

>     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 Chapter 17, " Startup and Shutdown Commands."

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

> 5. 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:

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

> 6. Use the PROBKUP utility with the -`norecover` startup parameter to back up the fractured version of the database:

>     probkup dbname -norecover

> `dbname`

> Specifies the name of the fractured version of the database.

> Note: The -`norecover` parameter prevents PROBKUP 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095