Hot Standby for Disaster Tolerant Systems
Oracle Rdb Release 7 and Oracle CODASYL DBMS Version 7 introduce new Hot Standby software that physically duplicates a database as a means of providing disaster tolerance. By implementing the Hot Standby, businesses with mission-critical requirements can prevent the catastrophic loss of data and data processing capability. Failure detection and failover can be achieved with minimal interruption to database users and application processing.
The Hot Standby software prevents an Oracle Rdb database or Oracle CODASYL DBMS database from becoming a single point of failure by physically duplicating a master database at a geographically-remote standby site across a wide area network. In the event of a node or cluster failure, the "hot standby" database becomes the master database and takes over application processing.
Automated AIJ Backup and Roll-Forward Operations
The standby database is created from a backup copy of the master database. Once started, the replication operation rolls forward the group commit operations to the standby database. As database modifications are applied to the after-image journal (AIJ) for the master database, the Hot Standby option automatically applies the modification over a network connection to the after-image journal for the standby database.
Automatic Database Synchronization
The Hot Standby option automatically performs coordinated database synchronization and verification with high performance and minimal impact on system resources:
To start the replication operation, a Replicate command can be entered using either the Rdb Management utility (RMU) or the DBMS Database Operator (DBO) utility, as appropriate. These utilities provide syntax and semantics for the following Replicate commands:
The Hot Standby is completely compatible with the standard Oracle Rdb and CODASYL DBMS database components. All database DDL and DML functionality is fully supported.
Hot Standby allows users to choose from among OpenVMS operating system platforms for both the master and the standby systems, mixing and matching as follows:
The Hot Standby option uses the following network transport protocols:
The standby cluster configuration is separate and distinct from the master database configuration. System failure of either the master or standby database is completely isolated from the other. Neither database is effected by the failure of the other.
Applications must be manually failed over to the hot-standby database if a failure occurs. There is no automatic failover support. However, the Hot Standby software automatically provides failover detection and notification for varying levels of failures: network, cluster, node, disk, server process, application process, database monitor, and other resources (such as process quotas, disk quotas, or disk space exhaustion).
Related Articles, Presentations, and White Papers: