Table 1 lists the initialization parameters and indicates if the parameter applies to the primary database role, the standby database role, or both. This article contains an updated version of the 9i. You can manage a data guard configuration by using either sqlplus, the data guard brokers commandline interface dgmgrl, or oracle enterprise manager 10g grid control. However, if you want to take advantage of new oracle database 11g features, set the compatible parameter to 11. Data guard physical standby setup in oracle database 11g. Oracle d ata guard ensures high availability, data protection, and disaster recovery for enterprise data. How to create a data guard standby using rman duplicate rac or nonrac, mos note 1617946.
Disaster recovery for oracle exadata database machine. Data guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production oracle databases to survive disasters and data corruptions. Additional database parameters when operating with data guard broker. Explains the structure of a physical standby database with oracle 12c data guard in. The data guard broker subsystem can aid in the setup, management and. Oracle data guard 11g high availability best practices. The software which oracle corporation markets as oracle data guard forms an extension to. Data guard is the name for oracle s standby database solution, used for disaster recovery and high availability. Data guard physical standby setup in oracle database 11g release 2.
The table also includes notes and recommendations specific to setting the parameters in a data guard environment. Oracle data guard ensures high availability, data protection, and disaster recovery for enterprise data. See the following topics for information about oracle data guard installation. Setting up oracle 11g data guard for sap customers. Oracle database 11g release 2 data guard setup using oracle grid control. Leveraging logical standby databases in oracle 11g data guard. Configure data guard physical setup usando data broker. Oracle weblogic server active gridlink and oracle data guard best practices. You must use a server parameter file spfile to ensure the broker can. Standard edition, standard edition one, and enterprise edition. Table 141 lists the initialization parameters and indicates if the parameter applies to the primary database role, the standby database role, or both. Oracle data guard is included with the e nterprise edition of the oracle database software. Data guard is the name for oracles standby database solution, used for disaster recovery and high availability. Dynamic setng of oracle data guard sql apply parameters.
1214 1038 301 830 1532 286 1533 243 1055 1212 58 1013 806 708 358 688 669 1268 839 284 1323 19 760 180 127 1097 1567 298 1098 727 77 1532 670 1563 1146 286 983 3 206 541 1338 588 382 482