Monitoring the dataguard environment
The Oracle ® dataguard feature ensures high availability, data protection, and disaster recovery for the enterprise data. Dataguard provides a comprehensive set of services that creates, maintains, manages, and monitors one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.
A standby database can be either a physical standby database or a logical standby database:
- Physical standby database - provides a physically identical copy of the primary database, with on-disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, are the same. A physical standby database is kept synchronized with the primary database by recovering the redo data received from the primary database.
- Logical standby database - Contains the same logical information as the production database, although the physical organization and structure of the data can be different. It is kept synchronized with the primary database by transforming the data in the redo logs received from the primary database into SQL statements and then executing the SQL statements on the standby database. A logical standby database can be used for other business purposes in addition to disaster recovery requirements. This allows users to access a logical standby database for queries and reporting purposes at any time. Thus, a logical standby database can be used concurrently for data protection and reporting.
Using the ORACLE_DATAGUARD KM, you can monitor the log gap parameters and status of the configured standby instances, both physical and logical. The ORACLE_DATAGUARD KM supports all the three protection modes, maximum performance mode (default protection mode), maximum protection mode, and maximum availability mode.
The ORACLE_DATAGUARD KM monitors the dataguard instance configured through the KM command. During standby configuration, the ORACLE_DATAGUARD KM queries to all the configured instances of PATROL for Oracle. The initial configuration window displays the particular instances as primary instances and lets you select one of them. After selecting a primary instance, you need to enter the information of the standby instance. After you enter the information, validation is done for that standby instance and the dataguard instance is configured.
The ORACLE_DATAGUARD KM monitors a configured standby instance in any state, for example, log_archive_dest_state_x = DEFERED, ALTERNATE.
The following topics provides information about configuring, modifying and instance, and removing an instance:
Comments
Log in or register to comment.