OGG启动EXTRACT 进程遇到OGG-00664错误
May172013
今天在给客户安装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错误。
2013-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 2013-05-08 15:10 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:01 ago) Log Read Checkpoint Oracle Redo Logs 2013-05-08 15:12:05 Thread 1, Seqno 1039, RBA 136134144 Log Read Checkpoint Oracle Redo Logs 2013-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: 2013-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: 2013-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: 2013-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: 2013-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: 2013-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: 2013-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: 2013-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: 2013-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 = 2013-05-08 15:10:54 Last Update Time = 2013-05-08 15:12:09 Stop Status = A Last Result = 400
经过测试，EXTRACT进程可正常抽取。
Start of Statistics at 2013-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 2013-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 2013-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 2013-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 2013-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.
OGG启动EXTRACT 进程遇到OGG-00664错误：等您坐沙发呢！
发表评论
