Kbase P14490: Hotspare or Hot standby DB for reporting *read only * purposes?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Use hotspare or hot standby DataBase (DB) for reporting * read only * purposes?
GOAL:
Roll-Forward of After-Image (AI) and still accessing the DB in Read-Only mode
FIX:
Accessing the hot standby DataBase in single user mode with the parameter -RO (Read Only) is at no risk for the database but the user might see dirty data. While connecting with "-RO", the following message is issued:
WARNING: Before-image file of database sports is not truncated. (1552)
With Progress Fathom Replication Plus product, there is the possibility to start a DB Server with the parameter -ERO, "Enhanced Read-Only", on the hot standby database. Multi-user remote access of the database is then possible and none dirty data is read; no update to the database is allowed and any attempt to do so returns an error.