Hi Experts,
I need a test case in GG for the below scenario.
Say, suppose there is a long running transaction running on the DB.. say 2 days old for which the archive logs do not exist locally on the server. I shutdown the extract and on startup, it complains that it cannot find a archivelog to recover the transaction from 2 days ago. Now, assuming that the transaction is not an important ( say toad session ) and one which can be ignored, how do I reset the extract to start from a different log sequence or RBA ??
I have had this issue few times on a regional 3 way replication we have within the organization. Please can someone put a test case, which I can execute to prove the point. Also, I get very confused with the checkpoint and RBA to start. I would really appreciate if someone can give me a bit of insight into this. My understanding of checkpoint is a pointer where either an extract or pump or replicat has processed records up to.
Appreciate if one of you can explain this
GGSCI (camrdpoddb02) 4> info extd3, showch
EXTRACT EXTD3 Last Started 2012-03-23 11:39 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint Oracle Redo Logs
2012-03-23 12:47:42 Seqno 98, RBA 105360896
SCN 0.11568399 (11568399)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 98
RBA: 101578768
Timestamp: 2012-03-23 11:36:00.000000
SCN: 0.11566313 (11566313)
Redo File: /ora03/oradata/RDPD3/RDPD3_redo_02a.log
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 98
RBA: 105360400
Timestamp: 2012-03-23 12:47:42.000000
SCN: 0.11568399 (11568399)
Redo File: /ora03/oradata/RDPD3/RDPD3_redo_02a.log
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 98
RBA: 105360896
Timestamp: 2012-03-23 12:47:42.000000
SCN: 0.11568399 (11568399)
Redo File: /ora03/oradata/RDPD3/RDPD3_redo_02a.log
BR Previous Recovery Checkpoint:
Thread #: 0
Sequence #: 0
RBA: 0
Timestamp: 2012-03-01 16:37:07.473939
SCN: Not available
Redo File:
BR Begin Recovery Checkpoint:
Thread #: 1
Sequence #: 98
RBA: 97644544
Timestamp: 2012-03-23 08:46:40.000000
SCN: 0.11562008 (11562008)
Redo File:
BR End Recovery Checkpoint:
Thread #: 1
Sequence #: 98
RBA: 97644544
Timestamp: 2012-03-23 08:46:40.000000
SCN: 0.11562008 (11562008)
Redo File:
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 2
RBA: 1078
Timestamp: 2012-03-23 12:47:58.599991
Extract Trail: dirdat/d3
Header:
Version = 2
Record Source = A
Type = 10
# 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 = 2012-03-23 11:39:33
Last Update Time = 2012-03-23 12:47:58
Stop Status = A
Last Result = 400
Many thanks
Edited by: USER101 on Mar 23, 2012 12:53 PM
Edited by: USER101 on Mar 23, 2012 12:56 PM