Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

OGG-15432 Could not find a valid log archive destination with matching db_unique_name of 'MINEDB' in source database

user10126973Feb 17 2024

Hello All,

I am able to register extract(i have no issues while registering extract), after sometime its stopped with the following error.

OGG-15432 Could not find a valid log archive destination with matching db_unique_name of 'MINEDB' in source database

OGG Version 19.1.0.0.4

Oracle Database version : 12.2

I set the following on source

EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'oggadmin', privilege_type => 'capture', grant_select_privileges=> true, -
do_grants => TRUE);

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=minedb ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=minedb';

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,minedb)';

Downstream

EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'oggadmin', privilege_type => 'capture', grant_select_privileges=> true, -
do_grants => TRUE);

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=/u01/app/minedb/arch_remote VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)';

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,minedb)';

I am seeing archives shipping to /u01/app/minedb/arch_remote

Please share your thoughts what exactly went wrong here,

Regards,

DR

Comments
Post Details
Added on Feb 17 2024
1 comment
77 views