Data Guard : Parameters
Basic Parameters
compatible
db_recovery_file_dest
db_recovery_file_dest_size
log_archive_config
log_archive_dest_1
log_archive_dest_2
service
valid_for
db_unique_name
compression
log_archive_max_processes
sync
Redo data should be received by all destinations before the commit is complete.
REDO_LOG_TYPE
ONLINE_LOGFILE
STANDBY_LOGFILE
ALL_LOGFILES
Default
DATABASE_ROLE
PRIMARY_ROLE
STANDBY_ROLE
ALL_ROLES
Default
Protection
Maximum Protection
Maximum Availability
ASYNC (Defalut)
Redo data need not be received by all destinations for commit to complete.
Maximum Performance
SYNC is not supported by destinations LOG_ARCHIVE_DEST_11 to LOG_ARCHIVE_DEST_31
AFFIRM/NOAFFIRM
FOR INFO ONLY : ALTER SYSTEM SET log_archive_dest_2='SERVICE=dosa1 LGWR SYNC AFFIRM COMPRESSION=ENABLE DB_UNIQUE_NAME=dosa1';
MAX_CONNECTIONS
Used only when redo transport service uses ARCH. Valid values : 1 - 5. Depends on LOG_ARCHIVE_MAX_PROCESSES if set, real-time Redo Apply will not be used.
MAX_FAILURE (also need to set REOPEN)
These many attempts will be done to connect to destination before giving up. Need to set REOPEN clause. after attemtping MAX_FAILURE attempts, REOPEN clause will be set to 0. Then redo transport will to be destination specified in ALTERNATE attribute. Destination for LOG_ARCHIVE_DEST_1 to LOG_ARCHIVE_DEST_10 can contain either LOCATION or SERVICE. But, destination for LOG_ARCHIVE_DEST_11 to LOG_ARCHIVE_DEST_31 can contain only SERVICE.
REOPEN
will reopen the failed connection
NET_TIMEOUT
used with SYNC redo transport mode.
LGWR
will wait for acknowledgement from redo transport destination. if not recieved, the redo transort session for the destination is terminated. Default value = 30 seconds.
DELAY
set the delay between primary and standby database
SQL> ALTER SYSTEM SET log_archive_dest_2='SERVICE=dosa1 LGWR SYNC AFFIRM REOPEN=20 NET_TIMEOUT=30 DELAY=10 DB_UNIQUE_NAME=dosa1';
FAL_SERVER
for missing archived log if there is gap
FAL_SERVER
primary net service name
FAL_CLIENT
no longer required in 11g
STANDBY_FILE_MANAGEMENT
MANUAL is default
DB_FILE_NAME_CONVERT
String replacement
Comments