ERROR: OGG-00446 No valid log files for current redo sequence 33, thread 1, error retrieving redo file name for sequence 33, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2018-03-18 17:44:15.000000.
Cause:
As the redo log file was stored under ASM, the process was unable to connect to ASM leading to the error.
workaround:
Extract process to run successfully, specify a user that can connect to the ASM instance using the below in Extract Parameter file
TRANLOGOPTIONS ASMUSER {user}@{ASM_TNS_ALIAS} ASMPASSWORD {password}
Example:
GGSCI (ggsrv1.localdomain as ogg@db1) 73> view params ESRV1 Extract esrv1 USERID ogg, PASSWORD oracle TRANLOGOPTIONS ASMUSER sys@asm ASMPASSWORD oracle ExtTrail ./dirdat/es Table HR.JOB_HISTORY; Table HR.EMPLOYEES; Table HR.JOBS; Table HR.DEPARTMENTS; Table HR.LOCATIONS; Table HR.REGIONS;
To ensure that the Oracle GoldenGate Extract process can connect to an ASM instance, list the ASM instance in the listener.ora and tnsnames.ora file.
--->listener.ora SID_LIST_LISTENER_ASM = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ASM) (ORACLE_HOME = /u01/app/grid/product/12.1.0/grid) (SID_NAME = +ASM) ) )
--->tnsnames.ora ASM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ggsrv1.localdomain)(PORT = 1521)) ) (CONNECT_DATA = (SID = +ASM) ) )