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
