Recover of Corrupted Definition File in Golden Gate

-
                            Recover of Corrupted Definition File in Golden Gate


In one of the golden gate setup ,we are not able to start the replicate in the target side. It was showing some error like below

2019-02-20 02:31:22  ERROR   OGG-00303  Problem at line 27.  Expecting file, table, or record definition.
2019-02-20 02:31:22  ERROR   OGG-01668  PROCESS ABENDING.

Solution:-
If the golden gate version is Version 11.1.1.0.27,then we will see this type of error in the report file while we want to start the replicate process.
1.Go to the source server and generate the new definition file by using ./defgen utility
Gg_home$ ./defgen paramfile /oracle/app/oracle/product/oggnew/dirprm/prcc_defgen_teradata.prm
2. new definition file will be created in  the below location of source server
$Gg_home/dirdef/prcc_defgen_teradata
3.transfer the prcc_defgen_teradata file to target by scp or open this text file by cat command ,copy to a notepad++ ,paste in the target server $gg_home/dirdef/prcc_defgen_teradata (by removing the existing file content)
4.Open the prcc_defgen_teradata file in target server and remove completely the below lines carefully (don’t comment “#”  the lines in file),then save it

[this line will come after “Field descriptions for each column entry” and before the “Definition for first table”]
Database type: ORACLE
Character set ID: ISO-8859-9
National character set ID: UTF-16
Locale: neutral
Case sensitivity: 14 14 14 14 14 14 14 14 14 14 14 14 11 14 14 14
5.log in to the target golden gate and restart the manager ,then restart the replicates

Comments

Post a Comment

Popular posts from this blog

Oracle Golden Gate FAQ

-
Image
                                                      Oracle Golden Gate FAQ Q. What type of Topology does Goldengate support? GoldenGate supports the following topologies. 1. Unidirectional 2. Bidirectional 3. Peer-to-peer 4. Broadcast 5. Consolidation 6. Cascasding Q. What are the main components of the Goldengate replication? The replication configuration consists of the following processes. 1. Manager 2. Extract 3. Pump 4. Replicate Q. What transaction types does Goldengate support for Replication? Goldengate supports both DML and DDL Replication from the source to target. Q. What are the supplemental logging pre-requisites? The following supplemental logging is required. 1. Database supplemental logging 2. Object level logging Q. Why is Supplemental logging required for Replication? Integrated Capture (IC): 1. In the Integrated Capture mode, GoldenGate works directly with the database log mining server to receive the data changes in the form of log
Read more

Oracle Golden gate - Long running transactions while stopping an extract

-
Oracle Golden gate  - Long running transactions while stopping an extract ? Below is how you can find it out and kill if needed. GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN Sending showtrans request to EXTRACT EXRAJ ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064 Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288 ------------------------------------------------------------ XID:                  1630.17.201166 Items:                1        Extract:              EXRAJ    Redo Thread:          1      Start Time:           2013-05-10:21:43:50  SCN:                  1586.3900894393 (6815719025849)  Redo Seq:             74058 Redo RBA:             104066064          Status:               Running            ------------------------------------------------------------ XID:            
Read more

FAQ on Oracle Golden gate for unix & windows

-
                                        FAQ on Oracle Golden gate for unix & windows 1.What is the purpose of running   the Reverse utility • To restore a test database to its original state before the test run. Because the Reverse utility only backs out changes, a test database can be restored in a matter of minutes, much more efficiently than a complete database restore, which can take hours. • To reverse errors caused by corrupt data or accidental deletions. For example, if an UPDATE or DELETE command is issued without a WHERE clause, the Reverse utility reverses the operation. 2.What needs to do for using the Reverse utility • Run Extract to extract the before data. • Run the Reverse utility to perform the reversal of the transactions. • Run Replicat to apply the restored data to the target database. 3.How the Reverse utility reverses the forward operations Reversing the ordering of database operations in an extract file, a series of extract
Read more