Advertisements

OGG-00446 No valid log files for current redo sequence:

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)
 )
 )

 

Advertisements