Oracle Dataguard Master Repository parameter file configuration detailed

The Main library parameters are detailed:?

Keep all the same db_name in the same data guard

db_name=ora11g?? #为一个数据库指定一个唯一的名称, the parameter will not change once it is specified, unless the DBA actively changes it so that db_unique_namedb_unique_name=ora11g_primary is introduced in oracle?10g???? #定义数据库唯一名称, because the db_name parameter must be the same for the physical database, the logical database must be different for the parameter to determine the Dataguard configuration?????????????????????????????? #的每个数据库, if this parameter is not defined, the Db_name parameter value is used by default. This parameter must be configured differently in Dataguard.

Log_archive_config is used to control sending archived logs to remote locations, receiving remote archive logs, and specifying data? The unique database name for the guard configuration, with the default value of Send,receive,nodg_config.

? ? ? ? When the parameter is set to send, the sending archive log is activated to the remote location;

? ? ? ? When set to Nosend, the sending of archived logs to a remote location is forbidden;

? ? ? ? When this parameter is set to receive, the receiving Remote archive log is activated;

? ? ? ? When this parameter is set to Noreceive, it is forbidden to receive remote archive logs;

? ? ? ? When you set this parameter to Dg_config, you can specify a maximum of 9 unique database names;

? ? ? ? When the parameter is set to Nodg_config, a unique database name is disabled.

Log_archive_config= ' dg_config= (ora11g_primary?,ora11g_standby) '???? #定义DataGuard配置的有效DB_UNIQUE_NAME参数列表, the order of names does not require

Log_archive_dest_1= ' location=/u01/app/oracle/archive? Valid_for= (all_logfiles,all_roles)? Db_unique_name=ora11g_primary '???? #指定本地归档的路径

Log_archive_dest_2= ' Service=ora11g_standby? Lgwr? ASYNC? Valid_for= (online_logfiles,primary_role)? Db_unique_name=ora11g_standby ' #指定远端备库的归档路径

Log_archive_dest_n (from 1 to 10) defines the redo file path. This parameter must specify the archive file path through location or service. Location represents a local path, and the service is typically the net service name, which is the standby database that receives redo data. NET service name refers to the name that is configured in Tnsnames.ora.

Note: Each log_archive_dest_n has a corresponding log_archive_dest_state_n parameter that has the following 4 property values:

Enable: The default value, which means that the transport service is allowed

DEFER: Specifies that the corresponding log_archive_dest_n parameter is valid but is not used temporarily

ALTERNATE: The transfer is forbidden, but if the connection to the other related destination fails, it becomes the Enable

RESET: The function is similar to defer, but it clears all error messages if there is an error prior to the transfer destination

log_archive_dest_state_1=enable Log_archive_dest_state_2=enable?

Remote_login_passwordfile=exclusive??? #远程登录设置独享模式 (Note that the main repository password is the same)

? Log_archive_format=%t_%s_%r.arc

when some logs of primary database are not sent to standby database this time an archive crack occurs (Archive Gap)The missing log is the crack (GAP). Data Guard can automatically detect and resolve archived cracks without the need for DBA intervention. This requires configurationFal_client,fal_server These two parameters (Fal:fetch Archive Log)from the name of Fal can be seen, this process is Standby database initiated the process of taking the log, Standby database isFal_client, it is to take these gap from the fal_server. 10g, this fal_server can be primary Database, or it can be otherStandby Database?The fal_client and fal_server two parameters are the Oracle Net NameFal_client sends a request to fal_server over the network,fal_server sending missing logs to fal_client over the networkbut these two connections are not necessarily a connection. So when Fal_client sends a request to Fal_server, it carries fal_client parametersvalue that tells the fal_server where the missing log should be sent. This parameter is also an Oracle Net name for this name in Fal_serverused to point to the Fal_client .

Fal_server=ora11g_standbyfal_client=ora11g_primary

If the primary database data file changes (such as new), the standby database is modified accordingly

Set to auto to indicate automatic management. Set as manual means manual management is required (Note: Rename changes

is not uploaded to the standby database)

Standby_file_management=auto

Main Library Parameters ?

Db_name=ora11gdb_unique_name=ora11g_primarylog_archive_config= ' dg_config= (ora11g_primary?,ora11g_standby) '??? Log_archive_dest_1= ' location=/u01/app/oracle/archive? Valid_for= (all_logfiles,all_roles)? Db_unique_name=ora11g_primary ' log_archive_dest_2= ' Service=ora11g_standby? Lgwr? ASYNC? Valid_for= (online_logfiles,primary_role)? Db_unique_name=ora11g_standby ' Log_archive_dest_state_1=enablelog_archive_dest_state_2=enableremote_login_ Passwordfile=exclusivelog_archive_format=%t_%s_%r.arcfal_server=ora11g_standbyfal_client=ora11g_primarystandby _file_management=auto

Library Parameters ?

Db_name=ora11gdb_unique_name=ora11g_standby? Log_archive_config= ' dg_config= (ora11g_primary?,ora11g_standby) '??? Log_archive_dest_1= ' location=/u01/app/oracle/archive? Valid_for= (all_logfiles,all_roles)? Db_unique_name=ora11g_standby ' log_archive_dest_2= ' service=ora_primary? Lgwr? ASYNC? Valid_for= (online_logfiles,primary_role)? Db_unique_name=ora11g_primary ' Log_archive_dest_state_1=enablelog_archive_dest_state_2=enableremote_login_ Passwordfile=exclusivelog_archive_format=%t_%s_%r.arcfal_server=ora11g_primaryfal_client=ora11g_standbystandby _file_management=auto

Oracle Dataguard Master Repository parameter file configuration detailed