After Upgrading My Oracle Goldengate from 12.2. to 18.1
version extracts are unable to start with current trail file and fails
with below error
Error:
tail -f
$GG_HOME/ggserr.log
2019-01-22T18:25:28.710-0500 INFO
OGG-01478 Oracle GoldenGate Capture for Oracle, EORAQA.prm: Output
file /goldengate/dirdat/ORAQA/MYQADB/hp is using format RELEASE 12.3/18.1.
2019-01-22T18:25:28.715-0500
ERROR OGG-01416 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: File /goldengate/dirdat/ORAQA/MYQADB/hp000000141, with format
RELEASE 12.2, does not match current format specification of RELEASE 12.3/18.1.
Modify the parameter file to specify format RELEASE 12.2 or issue ETROLLOVER
prior to restart.
2019-01-22T18:25:28.715-0500 ERROR
OGG-01668 Oracle GoldenGate Capture for Oracle, eoraqa.prm:
PROCESS ABENDING.
Solution:
Since I’m using same existing trail file (seq# 144) to start after upgrading my GG
due to the version difference it is failing so We need to rollover to next
trail file and start with next trail file seq number
Login to ggsci and do ETROLLOVER
GGSCI (oraqa.domain.com) 43> alter EORAQA etrollover
2019-01-23 14:35:57 INFO OGG-01520
Rollover performed. For each affected output trail of Version 10 or
higher format, after starting the source extract, issue ALTER EXTSEQNO for that
trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to
the new trail file; it will not happen automatically.
EXTRACT altered.
GGSCI (oraqa.domain.com) 44> info EORAQA showch
EXTRACT EORAQA Initialized
2019-01-23 14:34 Status ABENDED
Checkpoint Lag 01:10:59
(updated 00:00:12 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
2019-01-23 13:24:58
SCN 95.1370001303 (409391894423)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Integrated Redo Log
Startup Checkpoint (starting position in the data
source):
Timestamp: 2018-02-28 12:15:17.000000
SCN: Not available
Recovery Checkpoint (position of oldest unprocessed
transaction in the data source):
Timestamp: 2019-01-23 13:24:58.000000
SCN: 95.1370001302 (409391894422)
Current Checkpoint (position of last record read in the
data source):
Timestamp: 2019-01-23 13:24:58.000000
SCN: 95.1370001303 (409391894423)
BR Previous Recovery Checkpoint:
Timestamp: 2019-01-22 18:39:59.544161
SCN: Not available
BR Begin Recovery Checkpoint:
Timestamp: 2019-01-23 10:41:39.000000
SCN: 95.1365863434 (409387756554)
BR End Recovery Checkpoint:
Timestamp: 2019-01-23 10:41:39.000000
SCN: 95.1365863434 (409387756554)
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 145
RBA: 0
Timestamp: 2019-01-23 13:25:01.767828
Extract Trail:
/goldengate/dirdat/ORAQA/MYQADB/hp
Seqno Length: 9
Flip Seqno Length: No
Trail Type: EXTTRAIL
Header:
Version = 2
Record Source = U
Type = 13
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = 2019-01-23 14:34:23
Last Update Time = 2019-01-23 14:35:57
Stop Status = A
Last Result = 520
GGSCI (oraqa.domain.com) 45> start EORAQA
Sending START request to MANAGER ...
EXTRACT EORAQA starting
GGSCI (oraqa.domain.com) 47> info EORAQA
EXTRACT EORAQA Last Started 2019-01-23
14:36 Status RUNNING
Checkpoint Lag 00:00:09
(updated 00:00:01 ago)
Process ID
2686
Log Read Checkpoint Oracle Integrated Redo Logs
2019-01-23 14:36:27
SCN 95.1370008158 (409391901278)
ggserr.log
2019-01-23T14:35:57.135-0500
INFO OGG-00987 Oracle GoldenGate Command Interpreter
for Oracle: GGSCI command (oracle): alter EORAQA etrollover.
2019-01-23T14:35:57.152-0500
INFO OGG-01520 Oracle GoldenGate Command Interpreter
for Oracle: Rollover performed. For each affected output trail of
Version 10 or higher format, after starting the source extract, issue ALTER
EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the
reader's scan to the new trail file; it will not happen automatically.
2019-01-23T14:36:09.856-0500
INFO OGG-00987 Oracle GoldenGate Command Interpreter
for Oracle: GGSCI command (oracle): info EORAQA showch.
2019-01-23T14:36:19.984-0500
INFO OGG-00987 Oracle GoldenGate Command Interpreter
for Oracle: GGSCI command (oracle): start EORAQA.
2019-01-23T14:36:19.985-0500
INFO OGG-00963 Oracle GoldenGate Manager for Oracle,
mgr.prm: Command received from GGSCI on host [10.123.00.25]:11140 (START
EXTRACT EORAQA ).
2019-01-23T14:36:19.992-0500
INFO OGG-00975 Oracle GoldenGate Manager for Oracle,
mgr.prm: EXTRACT EORAQA starting.
2019-01-23T14:36:20.130-0500
INFO OGG-00992 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: EXTRACT EORAQA starting.
2019-01-23T14:36:20.131-0500
INFO OGG-03059 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Operating system character set identified as UTF-8.
2019-01-23T14:36:20.131-0500
INFO OGG-02695 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: ANSI SQL parameter syntax is used for parameter parsing.
2019-01-23T14:36:20.131-0500
INFO OGG-02095 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Successfully set environment variable
ORACLE_HOME=/opt/oracle/product/12.1.0.2.64.
2019-01-23T14:36:20.132-0500
INFO OGG-02095 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Successfully set environment variable ORACLE_SID=ORAQA.
2019-01-23T14:36:20.169-0500
INFO OGG-01360 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: EXTRACT is running in Integrated mode.
2019-01-23T14:36:21.402-0500
INFO OGG-01635 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2019-01-23T14:36:21.411-0500
INFO OGG-01815 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Virtual Memory Facilities for: BR
anon
alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/goldengate/BR/EORAQA.
2019-01-23T14:36:21.421-0500
INFO OGG-01851 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: filecaching started: thread ID: 139675624793856.
2019-01-23T14:36:21.421-0500
INFO OGG-01815 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
$GG_HOME/dirtmp.
2019-01-23T14:36:21.615-0500
INFO OGG-06604 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Database ORAQA CPU info: CPU Count 80, CPU Core Count 80, CPU
Socket Count 8.
2019-01-23T14:36:22.309-0500
WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, EORAQA.prm:
Database does not have streams_pool_size initialization parameter configured.
2019-01-23T14:36:22.375-0500
INFO OGG-02248 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Logmining server DDL filtering enabled.
2019-01-23T14:36:23.643-0500
INFO OGG-02068 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Integrated capture successfully attached to logmining server
OGG$CAP_EORAQA using OGGCapture API.
2019-01-23T14:36:23.646-0500
INFO OGG-02089 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Source redo compatibility version is: 12.1.0.2.0.
2019-01-23T14:36:23.646-0500
INFO OGG-02086 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Integrated Dictionary will be used.
2019-01-23T14:36:23.720-0500
WARNING OGG-02905 Oracle GoldenGate Capture for Oracle, EORAQA.prm:
Replication of OID column in object tables may diverge.
2019-01-23T14:36:26.882-0500
INFO OGG-00993 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: EXTRACT EORAQA started.
2019-01-23T14:36:26.882-0500
INFO OGG-01052 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: No recovery is required for target file
/goldengate/dirdat/ORAQA/MYQADB/hp000000145, at RBA 0 (file not opened).
2019-01-23T14:36:26.883-0500
INFO OGG-01478 Oracle GoldenGate Capture for Oracle,
EORAQA.prm: Output file /goldengate/dirdat/ORAQA/MYQADB/hp is using
format RELEASE 12.2.
Now my extract started fine with new sequence number
0 comments:
Post a Comment