Thursday 21 March 2019

Far - synch datagrard configuration

Relevant configuration parameters
for this example include:

Primary (primary):
--------------------------------------------
log_archive_dest_2= service="farsync", SYNC NOAFFIRM delay=0 optional compression=disable
max_failure=1 max_connections=1 reopen=5 db_unique_name="farsync" net_timeout=8,
alternate=LOG_ARCHIVE_DEST_3 valid_for=(online_logfile,all_roles)

log_archive_dest_3=service="standby", ASYNC NOAFFIRM delay=0 optional compression=disable
max_failure=1 max_connections=1 reopen=5 db_unique_name="standby"
alternate=LOG_ARCHIVE_DEST_2 valid_for=(online_logfile,all_roles)

log_archive_dest_state_2=ENABLE
log_archive_dest_state_3=ALTERNATE
log_archive_config=dg_config=(primary, farsync, standby)
fal_server= standby

»
Primary Far Sync “A” (farsync)

log_archive_dest_2=”service="standby", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=5 db_unique_name="standby" net_timeout=8, valid_for=(standby_logfile,all_roles)

log_archive_dest_state_2=ENABLE
log_archive_config=dg_config=(primary, farsync, standby)
fal_server=primary

»
Standby (standby):
-----------------------------------------
log_archive_dest_2= service="primary" ASYNC reopen=5 db_
unique_name="primary"
valid_for=(online_logfile,all_roles)
log_archive_dest_state_2
=ENABLE
log_archive_config
=
dg_config=(
primary,farsync, standby)
fal_server=farsync, primary


https://oracledba.blogspot.com/2016/11/using-standby-as-alternate-for-far-sync.html
https://www.oracle.com/technetwork/database/availability/farsync-2267608.pdf

SELECT p1.value|| '/' || p2.value || '_ora_'  || p.spid  ||'.trc'  file_name
FROM
v$process p,
v$session s,
v$parameter p1,
v$parameter p2
WHERE p1.name = 'user_dump_dest'
AND p2.name = 'db_name'
AND p.addr = s.paddr
AND s.audsid = USERENV ('SESSIONID');

Optimizer Access Paths using Indexes

Introduction In this tutorial you will use the Optimizer Access Paths for the following cases (scenarios): Case 1: With and Without Index Ca...