alter extract begin timestamp get OGG-08100

432452405 432485451 1 1 1390 +ARCHDG/ORCL/ARCHIVELOG/2019_03_27/thread_1_seq_13 NO A 
90.310.1004009429 
433196395 433682358 1 1 1397 +ARCHDG/ORCL/ARCHIVELOG/2019_03_27/thread_1_seq_13 NO A 
97.267.1004042105 
434220075 434511477 1 1 1399 +ARCHDG/ORCL/ARCHIVELOG/2019_03_28/thread_1_seq_13 NO A 
99.312.1004087427 
439918452 440590238 1 1 1410 +ARCHDG/ORCL/ARCHIVELOG/2019_03_31/thread_1_seq_14 NO A 
10.285.1004343531 
441201995 441875468 1 1 1412 +ARCHDG/ORCL/ARCHIVELOG/2019_03_31/thread_1_seq_14 NO A 
12.284.1004379771 
442542323 443122491 1 1 1414 +ARCHDG/ORCL/ARCHIVELOG/2019_04_01/thread_1_seq_14 NO A 
14.278.1004414591 
443122491 443840137 1 1 1415 +ARCHDG/ORCL/ARCHIVELOG/2019_04_01/thread_1_seq_14 NO A 
15.281.1004435515 
443840137 444509287 1 1 1416 +ARCHDG/ORCL/ARCHIVELOG/2019_04_01/thread_1_seq_14 NO A 
16.292.1004454547 
SQL> select scn_to_timestamp(432485451) from dual; 

SCN_TO_TIMESTAMP(432485451) 
————————————————————————— 
27-MAR-19 11.30.27.000000000 AM 

SQL> select scn_to_timestamp(441875468) from dual; 

SCN_TO_TIMESTAMP(441875468) 
————————————————————————— 
31-MAR-19 06.22.50.000000000 PM 

SQL> select scn_to_timestamp(443122491) from dual; 

SCN_TO_TIMESTAMP(443122491) 
————————————————————————— 
01-APR-19 04.03.09.000000000 AM 
OGG (https://LINUXVM01:18100 LOCAL) 12> ALTER EXTRACT EXT01, begin 2019-03-27T11:30:27Z 
2019-04-01T15:08:15Z INFO OGG-08100 ERROR: Invalid BEGIN datetime entry. 

OGG (https://LINUXVM01:18100 LOCAL) 13> ALTER EXTRACT EXT01, begin 2019-03-31T06:22:50Z 
2019-04-01T15:09:02Z INFO OGG-08100 ERROR: Invalid BEGIN datetime entry. 

OGG (https://LINUXVM01:18100 LOCAL) 14> ALTER EXTRACT EXT01, begin 2019-04-01T04:03:09Z 
2019-04-01T15:10:09Z INFO OGG-08100 ERROR: Invalid BEGIN datetime entry. 

OGG (https://LINUXVM01:18100 LOCAL) 10> ALTER EXTRACT EXT01, SCN 432485451
2019-04-02T07:29:17Z INFO OGG-08100 EXTRACT altered.

OGG (https://LINUXVM01:18100 LOCAL) 11> info EXT01 detail

EXTRACT EXT01 Initialized 2019-04-02 07:29 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:10 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
First Record
SCN 0.432485451 (432485451)

Target Extract Trails:

Trail Name Seqno RBA Max MB Trail Type

/ogg/app/oracle/oggma/12.3.0.1.4/DEPLOYMENT_LOCAL/LOCAL/var/lib/data/TR 0 0 200 EXTTRAIL
Integrated Extract outbound server first scn: 0.382613480 (382613480)
Integrated Extract outbound server filtering start scn: 0.382614338 (382614338)
Extract Source Begin End
Not Available * Initialized * First Record
Not Available * Initialized * 2019-03-08 15:32
OGG (https://LINUXVM01:18100 LOCAL) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt

ADMINSRVR RUNNING
DISTSRVR RUNNING
PMSRVR RUNNING
RECVSRVR RUNNING
EXTRACT RUNNING EXT01 00:00:03 00:00:00
EXTRACT RUNNING EXT02 00:00:03 00:00:00

 

Leave a Reply

Your email address will not be published. Required fields are marked *