Oracle Dataguard Master Repository parameter file configuration detailed

The Main library parameters are detailed: Keep all db_name in the same data guard the same db_name=ora11g Specify a unique name for a database that will not change once specified unless the DBA actively changes db_unique_name=ora11g_primary

The initialization parameter log_archive_config is used to control the sending of archived logs to a remote location, to receive remote archive logs, and to specify a unique database name for the data guard configuration, with a default value of Send,receive,nodg_config.

When this parameter is set to send, the sending archive log is activated to the remote location, and when set to Nosend, the archive log is prevented from being sent to the remote location, and when the parameter is set to receive, the remote archive log is activated, and when the parameter is set to Noreceive, the The Remote archive log is disabled, and when set to Dg_config, you can specify a maximum of 9 unique database names, and when the parameter is set to Nodg_config, the unique database name is disabled.

log_archive_config= ' dg_config= (Ora11g_primary, Ora11g_standby) 'specify the path to the local archivelog_archive_dest_1= ' location=/u01/app/oracle/archive valid_for= (all_logfiles,all_roles) DB_UNIQUE_NAME= Ora11g_primary ' Specify the archive path for the remote standby librarylog_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.

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=enableLog_archive_dest_state_2=enable

Remote login settings Exclusive mode (Z Note that the main repository password is the same)

Remote_login_passwordfile=exclusive

%s Log sequence number
The%s log sequence number, zero filled%t, and the thread parameter in the RAC node is the value
%T thread number, zero filled
------of which the first 4 items can be used in 9I
%a activation ID
%d database ID
%r resetlogs ID that ensures unique names is constructed for the archived log files across multiple incarnations of the D Atabase
Beginning with Oracle 10g, the Log_archive_format initialization parameter must contain%s,%t, and%r to ensure that the generated archive redo log name is unique.
(reason: 10g can do the recovery through Resetlog, so add%r. and 9i can not do through resetlog recovery, so there is no%r parameters)

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 accordinglyset to Auto to indicate automatic management. Set as manual means manual management is required (Note: Rename changesis 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_standbylog_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