dataguard学习之部分参数配置（Some parameter configurations for DataGuard learning）.docVIP

dataguard学习之部分参数配置（Some parameter configurations for DataGuard learning） DataGuard learning part of the parameter configuration - [DATAGUARD]Dec 1, 2009 Tag:oracle, DataGuard, arguments, LOG_ARCHIVE_DEST_2 On the Internet there is an article that introduces DataGuard to parameters, explains the parameters involved in configuring Data Guard, and has learned a lot from work. Their summary, format, because the preferences of the problem will inevitably be similar, especially in advance statement. To build a 10g version of the DataGuard environment, one of the difficulties is configuring database names, roles, archiving, and other related parameters such as diskgroup. Take the following environment for example: HostName Role instance_name tnsnames.ora Db1, Primary, node1, db1, db1, DB2, DR1, DR2 DB2, primary, node2, DB2, db1, DB2, DR1, DR2 DR1, Standby, Apply, node1, db1, db1, DB2, DR1, DR2 DR2, Standby, node2, DB2, db1, DB2, DR1, DR2 Summarize some parameters that need to be customized according to the host and database environment. Other parameters involved in DataGuard, such as log_archive_format and so on, have fixed wording and are not explained here. 1.DB_NAME Just pay attention to the DataGuards main and standby nodes, and the instance uses the same db_name. Recommended in line with service_name. Primary Site Standby Site *.DB_NAME=DB*.DB_NAME=DB 2.DB_UNIQUE_NAME The unique name of the Primary and Standby end database can not be changed after setting. Be careful: If the main backup db_unique_name is not the same, it needs to be used in conjunction with the LOG_ARCHIVE_CONFIG Db_unique_name does not specify that you need to conform to the database service_name. You can customize any name. Primary Site Standby Site *.db_unique_name=Primary *.db_unique_name=Standby 3.LOG_ARCHIVE_CONFIG List the DB_UNIQUE_NAME parameters on the main and standby library. By default, this parameter is defined to ensure that the database can send or receive redo log. When the 1Primary d