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

Step-by-step guide for Install, Configure and Maintain Oracle Database 12C in AWS Cloud

Creating an Account with AWS
Creating a VPC
Creating a Security Group & SSH Key Pair
Building an EC2 instance in AWS Cloud
Connecting to an EC2 Instance
Downloading Oracle Database 12c Software
Preparing EC2 instance for Oracle Database 12c installation
Changing Hostname of an EC2 Instance.
Adding Secondary IP (for oracle installation we need static IP)
Creating Private DNS Hosted Zone
Configuring SELinux and Firewall
Adding a Volume to an EC2 Instance
Taking a snapshot of an EC2 Instance
Adding a Swap Volume
Oracle Database 12c Installation

All the above details are demonstrated in this document :

oracle12c_on_aws.docx