翻译:
How To Calculate The SCN Value In Extract Status To Compare To Current_scn? (Doc ID 1600222.1)
适用:
Oracle GoldenGate - Version 11.2.1.0.5 and later
Information in this document applies to any platform.
目标:
当执行send extract xx status命令时,其结果举例如下:
GGSCI (<server>) 42> send <extract> status
Sending STATUS request to EXTRACT <extract> ...
EXTRACT <extract> (PID 9372244)
Current status: Recovery complete: Processing data
Current read position:
Redo thread #: 1
Sequence #: 198315
RBA: 335376
Timestamp: 2013-11-11 16:11:57.000000
SCN: 78.924145222 <=====================
Current write position:
Sequence #: 1548
RBA: 401683
Timestamp: 2013-11-11 16:12:31.811533
Extract Trail: /ora