The summary in this document is very comprehensive, but I have made some corrections to some of the errors (such as fal_server and fal_client instructions) or some ambiguous descriptions. to differentiate the network connection string and SID, list the information of the master and slave databases first.
Master database:
Version: Oracle 10.2.0.1.0
ORACLE_SID = WENDING
Db_name = WENDING
Db_unique_name/instance_name = WENDING
Global_name/service_names = WENDING. LK
Net service name = DB_WENDING
Slave database:
ORACLE_SID = WDSTD
Db_name = WENDING (physical standby database)/WDSTD (logical standby database)
Db_unique_name/instance_name = WDSTD
Global_name/service_names = WDSTD. LK
Net service name = DB_WDSTD
The configuration of tnsnames. ora in the two libraries is the same, as follows:
DB_WENDING =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = primary_server) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WENDING. LK)
)
)
DB_WDSTD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = standby_server) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WDSTD. LK)
)
)
Description of parameters for configuring Dataguard:
1. DB_NAME: database name. It must be the same as DB_NAME for all primary and physical standby databases in the same consumer uard. The logical standby database can be different.
The primary end and standby end are the same:
*. DB_NAME = 'wending'
2. DB_UNIQUE_NAME: Instance name of the database. A unique name must be specified for each database www.bkjia.com.
Primary end:
*. DB_UNIQUE_NAME = WENDING
Standby end:
*. Db_unique_name = WDSTD
3. LOG_ARCHIVE_CONFIG. This parameter lists all DB_UNIQUE_NAME (including master and slave databases) in the same consumer uard using the DG_CONFIG attribute and is separated by commas (,).
The primary end and standby end are the same:
*. LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (WENDING, WDSTD )'
4. CONTROL_FILES
Primary end:
*. Control_files = '/u01/oradata/WENDING/controlfile/o1_mf_4srph8fv _. ctl', '/u02/flash_recovery_area/WENDING/controlfile/o1_mf_4srph96b _. ctl'
Standby end:
*. Control_files = '/u01/oradata/WDSTD/controlfile/o1_mf_4srph8fv _. ctl', '/u02/flash_recovery_area/WDSTD/controlfile/o1_mf_4srph96b _. ctl'
5. LOG_ARCHIVE_DEST_n: path for generating the archive file. LOCATION indicates the local machine, and the SERVICE indicates that the file is on another machine.
Primary end:
*. LOG_ARCHIVE_DEST_1 = 'location =/u01/arch/WENDING VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = wending'
*. LOG_ARCHIVE_DEST_2 = 'service = DB_WDSTD lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = WDSTD'
Standby end:
*. LOG_ARCHIVE_DEST_1 = 'location =/u01/arch/WDSTD VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = WDSTD'
*. LOG_ARCHIVE_DEST_2 = 'service = DB_WENDING lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = WENDING'
6. LOG_ARCHIVE_DEST_STATE_n, specify the parameter value as ENABLE, and activate the archived log directory defined by www.bkjia.com, allowing the redo transmission service to transmit redo data to the specified path
Primary end:
*. LOG_ARCHIVE_DEST_STATE_1 = ENABLE
*. LOG_ARCHIVE_DEST_STATE_2 = ENABLE
Standby end:
*. LOG_ARCHIVE_DEST_STATE_1 = ENABLE
*. LOG_ARCHIVE_DEST_STATE_2 = ENABLE
7. REMOTE_LOGIN_PASSWORDFILE. We recommend that you set the parameter value to EXCLUSIVE or SHARED. Ensure that the sys password of all db servers in the same consumer uard configuration is the same
Primary end:
*. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
Standby end:
*. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
8. LOG_ARCHIVE_FORMAT: Specifies the format of the archive file. It is best to keep the same format on the master and backup ends.
Primary end:
*. LOG_ARCHIVE_FORMAT = log _ % t _ % s _ % r. arc
Standby end:
*. LOG_ARCHIVE_FORMAT = log _ % t _ % s _ % r. arc
9. LOG_ARCHIVE_MAX_PROCESSES: specifies the number of archiving processes (1-30). The default value is usually 2.
This parameter is not modified in this experiment.
10. COMPATIBLE. This parameter indicates the Oracle version number. The Oracle version of the master database and the physical standby database must be the same. The logical standby database can be different.
Primary end:
*. COMPATIBLE = '10. 2.0.4.0'
Standby end:
*. COMPATIBLE = '10. 2.0.4.0'