Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

primary database doesn't send redo log to far sync instance

rafadbaMay 4 2018

I have a Data Guard configurarition in this scenario:

Oracle 12.2.0.1

Primary database: TERRA (db_unique_name and oracle net service name is the same)

Far Sync instance: TERRAFS (db_unique_name and oracle net service name is the same)

Physical standby : PLUTAO (db_unique_name and oracle net service name is the same)

Primary database Configuration:

log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TERRA';

log_archive_dest_2='SERVICE=TERRAFS SYNC AFFIRM MAX_FAILURE=1 ALTERNATE=LOG_ARCHIVE_DEST_3 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQ UE_NAME=TERRAFS'

log_archive_dest_3='SERVICE=PLUTAO ASYNC ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=PLUTAO'

log_archive_config='DG_CONFIG=(TERRA,PLUTAO,TERRAFS)'

fal_server=PLUTAO

Far Sync Instance Configuration:

log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/TERRAFS VALID_FOR=( ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TERRAFS'

log_archive_dest_2='SERVICE=PLUTAO ASYNC VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=PLUTAO'

log_archive_config='DG_CONFIG=(TERRA,PLUTAO,TERRAFS)'

fal_server=TERRA

Standby database Configuration:

log_archive_dest_1='LOCATION=/u01/app/oradata/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PLUTAO';

log_archive_dest_2='service=TERRA LGWR ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=TERRA';

fal_server=TERRA,TERRAFS

log_archive_config='dg_config=(TERRA,PLUTAO,TERRAFS)'

ERROR:

pastedImage_741.png

*** TROUBLESHOOTING ***

DEST_ID=2 is a Far Sync instance, so in my primary database:

pastedImage_742.png

pastedImage_746.png

In my far sync instance**:**

pastedImage_751.png

pastedImage_752.png

I don't know what is happining, Does someone can help me?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2018
Added on May 4 2018
0 comments
118 views