Original article address: [Technical uard] Detailed description of data guard deployment parameters secooler
For physical data guard deployment, see [physical uard] physical data guard configuration and installation on the same host (http://space.itpub.net/519536/viewspace-578181 ), this document compares the parameters used by the master and slave databases during data guard deployment.
1. db_name: Database Name, which must be the same for all databases in the same data guard.
The primary end is the same as the standby end.
*. Db_name = 'ora10g'
*. Db_name = 'ora10g'
2. db_unique_name: Instance name of the database. A unique name must be specified for each database.
Primary end:
*. Db_unique_name = ora10g
Standby end:
*. Db_unique_name = ora10gdg
3. log_archive_config. This parameter lists all db_unique_name (including primary dB and standby dB) in the same data guard using the dg_config attribute and is separated by commas.
The primary end is the same as the standby end.
*. Log_archive_config = 'dg _ Config = (ora10g, ora10gdg )'
*. Log_archive_config = 'dg _ Config = (ora10g, ora10gdg )'
4. control_files
Primary end:
*. Control_files = '/Oracle/u02/oradata/ora10g/controlfile/o1_mf_4srph8fv _. CTL ','/Oracle/u01/APP/Oracle/flash_recovery_area/ora10g/controlfile/o1_mf_4srph96b _. CTL'
Standby end:
*. Control_files = '/Oracle/u02/oradata/ora10gdg/controlfile/o1_mf_4srph8fv _. CTL ','/Oracle/u01/APP/Oracle/flash_recovery_area/ora10gdg/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 =/Oracle/u02/oradata/ora10g valid_for = (all_logfiles, all_roles) db_unique_name = ora10g'
*. Log_archive_dest_2 = 'service = ora10gdg lgwr async valid_for = (online_logfiles, primary_role) db_unique_name = ora10gdg'
Standby end:
*. Log_archive_dest_1 = 'location =/Oracle/u02/oradata/ora10gdg valid_for = (all_logfiles, all_roles) db_unique_name = ora10gdg'
*. Log_archive_dest_2 = 'service = ora10g lgwr async valid_for = (online_logfiles, primary_role) db_unique_name = ora10g'
6. log_archive_dest_state_n. Specify the parameter value as enable. Activate the defined archive log directory and allow 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 all dB servers in the same data guard configuration have the same sys password.
Primary end:
*. Remote_login_passwordfile = exclusive
Standby end:
*. Remote_login_passwordfile = exclusive
8. log_archive_format: Specifies the format of the archive file, which must be the same 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_produc: specifies the number of archiving processes (1-30). The default value is usually 4.
This parameter is not modified in this experiment.
10. compatible: The Oracle version of the primary database and the standby database must be consistent. This parameter specifies the version number of oracle.
Primary end:
*. Compatible = '10. 2.0.3.0'
Standby end:
*. Compatible = '10. 2.0.3.0'
11. fal_server: the parameter of the standby database. The Oracle network service name is provided, usually the connection string pointing to the primary database.
Primary end (the master database is set to swap the master and slave roles after switching ):
*. Fal_server = ora10gdg
Standby end:
*. Fal_server = ora10g
12. fal_client, the parameter of the standby database, which provides the Oracle network service name, usually the connection string pointing to the standby database.
Primary end (the master database is set to swap the master and slave roles after switching ):
*. Fal_client = ora10g
Standby end:
*. Fal_client = ora10gdg
13. db_file_name_convert: the data file conversion directory of the primary database and the standby database is mapped (if the directory structure of the two databases is different). If multiple mappings exist, the ing relationship is specified one by one.
Format: *. db_file_name_convert = master database data file directory, backup database data file directory
Primary end (the master database is set to swap the master and slave roles after switching ):
*. Db_file_name_convert = '/Oracle/u02/oradata/ora10gdg/datafile','/Oracle/u02/oradata/ora10g/datafile'
Standby end:
*. Db_file_name_convert = '/Oracle/u02/oradata/ora10g/datafile','/Oracle/u02/oradata/ora10gdg/datafile'
14. log_file_name_convert indicates that the log file conversion directory of the master database and the backup database is mapped
Format: *. log_file_name_convert = main database log directory, backup database directory
Primary end (the master database is set to swap the master and slave roles after switching ):
*. Log_file_name_convert = '/Oracle/u02/oradata/ora10gdg/onlinelog', '/Oracle/u02/oradata/ora10g/onlinelog'
Standby end:
*. Log_file_name_convert = '/Oracle/u02/oradata/ora10g/onlinelog', '/Oracle/u02/oradata/ora10gdg/onlinelog'
15. standby_file_management. If the data file of the primary database is modified (such as new database creation or renaming), modify the data file in standby according to the settings of this parameter. Auto indicates automatic management. If it is set to manual, manual management is required.
Primary end (the master database is set to swap the master and slave roles after switching ):
*. Standby_file_management = auto
Standby end:
*. Standby_file_management = auto
16. standby_archive_dest: Archive directory of the backup database
Primary end (the master database is set to swap the master and slave roles after switching ):
*. Standby_archive_dest = '/ora10g_arch'
Standby end:
*. Standby_archive_dest = '/ora10gdg_arch'
17. Summary
For more parameter descriptions for data guard, see Oracle official documentation: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/init_params.htm#i88512
A thorough understanding of the database parameters used to deploy data guard not only helps us understand the principles of physical data guard, but also helps us troubleshoot data guard-related faults.
Good luck.
Secooler
11.06.10
-- The end --
