今天在给客户安装OGG的时候,EXTRACT进程无法启动。
GGSCI (ycods1) 4> start EXTBAM
Sending START request to MANAGER ...
EXTRACT EXTBAM starting
GGSCI (ycods1) 5> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXTBAM 00:00:00 02:59:08
EXTRACT STOPPED PUMPBAM 00:00:00 02:56:41
REPLICAT RUNNING REPCIMXB 00:00:00 00:00:02
REPLICAT RUNNING TREPLVA 00:00:00 00:00:05
观察日志,发现OGG-00664错误。
-05-08 15:07:07 ERROR OGG-00664 OCI Error beginning session (status = 12705-ORA-12705: Cannot access NLS data files or invalid environment specified)
这个报错很明显是由于NLS_LANG环境变量设置的不对,观察EXTRACT进程配置文件,发现NLS_LANG部分用了全角的双引号。
EXTRACT extbam
SETENV (NLS_LANG=”AMERICAN_AMERICA.ZHS16GBK”)
SETENV (ORACLE_SID=yyjc1)
USERID ogguser,PASSWORD AACAAAAAAAAAAAHAVEMFFBTCODIDNHRD,ENCRYPTKEY default
DYNAMICRESOLUTION
删除双引号,问题解决。
GGSCI (ycods1) 12> start EXTBAM
Sending START request to MANAGER ...
EXTRACT EXTBAM starting
GGSCI (ycods1) 13> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTBAM 00:00:00 03:02:48
EXTRACT STOPPED PUMPBAM 00:00:00 03:00:21
REPLICAT RUNNING REPCIMXB 00:00:00 00:00:01
REPLICAT RUNNING TREPLVA 00:00:00 00:00:03
通过观察,EXTRACT进程正常,已经这确连接2个RAC实例。
GGSCI (ycods1) 18> info EXTBAM,showch
EXTRACT EXTBAM Last Started -05-08 15:10 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint Oracle Redo Logs
-05-08 15:12:05 Thread 1, Seqno 1039, RBA 136134144
Log Read Checkpoint Oracle Redo Logs
-05-08 15:11:34 Thread 2, Seqno 706, RBA 149851136
Current Checkpoint Detail:
Read Checkpoint #1
Oracle RAC Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 1039
RBA: 44683776
Timestamp: -05-08 12:08:01.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 1039
RBA: 136133136
Timestamp: -05-08 15:12:05.000000
SCN: 2878.4099253078 (12365015130966)
Redo File: +DATA/yyjc/onlinelog/group_5.259.805634579
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 1039
RBA: 136134144
Timestamp: -05-08 15:12:05.000000
SCN: 2878.4099253078 (12365015130966)
Redo File: +DATA/yyjc/onlinelog/group_5.259.805634579
Read Checkpoint #2
Oracle RAC Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 2
Sequence #: 706
RBA: 84888064
Timestamp: -05-08 12:08:01.000000
SCN: Not available
Redo File:
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 2
Sequence #: 706
RBA: 149850640
Timestamp: -05-08 15:11:34.000000
SCN: 2878.4099253074 (12365015130962)
Redo File: +DATA/yyjc/onlinelog/group_4.268.805635511
Current Checkpoint (position of last record read in the data source):
Thread #: 2
Sequence #: 706
RBA: 149851136
Timestamp: -05-08 15:11:34.000000
SCN: 2878.4099253074 (12365015130962)
Redo File: +DATA/yyjc/onlinelog/group_4.268.805635511
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 954
Timestamp: -05-08 15:12:09.130906
Extract Trail: ./dirdat/SG_BAM/BA
Write Checkpoint #2
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 0
RBA: 0
Timestamp: -05-08 12:12:06.444958
Extract Trail: ./dirdat/SG_BAM/XB
Header:
Version = 2
Record Source = A
Type = 6
# Input Checkpoints = 2
# Output Checkpoints = 2
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 4096
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Status:
Start Time = -05-08 15:10:54
Last Update Time = -05-08 15:12:09
Stop Status = A
Last Result = 400
经过测试,EXTRACT进程可正常抽取。
Start of Statistics at -05-08 15:25:12.
Output to ./dirdat/SG_BAM/BA:
Extracting from SG_BAM.BAM_PROCESSINST to SG_BAM.BAM_PROCESSINST:
*** Total statistics since -05-08 15:25:10 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Daily statistics since -05-08 15:25:10 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Hourly statistics since -05-08 15:25:10 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Latest statistics since -05-08 15:25:10 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
End of Statistics.