1.买个闹钟，以便按时叫醒你。
自贪睡和不守时，都将成为你工作和事业上的绊脚石，任何时候都一样。不仅要学会准时，更要学会提前。就如你坐车去某地，沿途的风景很美，你忍不住下车看一看，后来虽然你还是赶到了某地，却不是准时到达。“闹钟”只是一种简单的标志和提示，真正灵活、实用的时间，掌握在每个人的心中。
2.如果你不喜欢现在的工作，要么辞职不干，要么就闭嘴不言。
初出茅庐，往往眼高手低，心高气傲，大事做不了，小事不愿做。不要养成挑三拣四的习惯。不要雨天烦打伞，不带伞又怕淋雨，处处表现出不满的情绪。记住，不做则已，要做就要做好。
3.每个人都有孤独的时候。
要学会忍受孤独，这样才会成熟起来。年轻人嘻嘻哈哈、打打闹闹惯了，到了一个陌生的环境，面对形形色色的人和事，一下子不知所措起来，有时连一个可以倾心说话的地方也没有。这时，千万别浮躁，学会静心，学会忍受孤独。在孤独中思考，在思考中成熟，在成熟中升华。不要因为寂寞而乱了方寸，而去做无聊无益的事情，白白浪费了宝贵的时间。
4.走运时要做好倒霉的准备。
有一天，一只狐狸走到一个葡萄园外，看见里面水灵灵的葡萄垂涎欲滴。可是外面有栅栏挡着，无法进去。于是它一狠心绝食三日，减肥之后，终于钻进葡萄园内饱餐一顿。当它心满意足地想离开葡萄园时，发觉自己吃得太饱，怎么也钻不出栅栏了。相信任何人都不愿做这样的狐狸。退路同样重要。饱带干粮，晴带雨伞，点滴积累，水到渠成。有的东西今天似乎一文不值，但有朝一日也许就会身价百倍。
5.不要像玻璃那样脆弱。
有的人眼睛总盯着自己，所以长不高看不远；总是喜欢怨天尤人，也使别人无比厌烦。没有苦中苦，哪来甜中甜？不要像玻璃那样脆弱，而应像水晶一样透明，太阳一样辉煌，腊梅一样坚强。既然睁开眼睛享受风的清凉，就不要埋怨风中细小的沙粒。
6.管住自己的嘴巴。
不要谈论自己，更不要议论别人。谈论自己往往会自大虚伪，在名不副实中失去自己。议论别人往往陷入鸡毛蒜皮的是非口舌中纠缠不清。每天下班后和你的那些同事朋友喝酒聊天可不是件好事，因为，这中间往往会把议论同事、朋友当做话题。背后议论人总是不好的，尤其是议论别人的短处，这些会降低你的人格。
7.机会从不会“失掉”，你失掉了，自有别人会得到。
不要凡事在天，守株待兔，更不要寄希望于“机会”。机会只不过是相对于充分准备而又善于创造机会的人而言的。也许，你正为失去一个机会而懊悔、埋怨的时候，机会正被你对面那个同样的“倒霉鬼”给抓住了。没有机会，就要创造机会，有了机会，就要巧妙地抓住。
8.若电话老是不响，你该打出去。
很多时候，电话会给你带来意想不到的收获，它不是花瓶，仅仅成为一种摆设。交了新朋友，别忘了老朋友，朋友多了路好走。交际的一大诀窍就是主动。好的人缘好的口碑，往往助你的事业更上一个台阶。
9.千万不要因为自己已经到了结婚年龄而草率结婚。
想结婚，就要找一个能和你心心相印、相辅相携的伴侣。不要因为放纵和游戏而恋爱，不要因为恋爱而影响工作和事业，更不要因一桩草率而失败的婚姻而使人生受阻。感情用事往往会因小失大。
10.写出你一生要做的事情，把单子放在皮夹里，经常拿出来看。
人生要有目标，要有计划，要有提醒，要有紧迫感。一个又一个小目标串起来，就成了你一生的大目标。生活富足了，环境改善了，不要忘了皮夹里那张看似薄薄的单子。
Daily Archives: 2011 年 11 月 21 日
ogg中Time Since Chkpt显示unknown解决
1、异常现象
[oracle@localhost ~]$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.1.1.0.0 Build 078 Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11 Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved. GGSCI (localhost.localdomain) 1> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT-ECP 00:00:00 unknown EXTRACT RUNNING EXT-EDS 00:00:00 unknown EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown
2、尝试关闭异常进程重启
GGSCI (localhost.localdomain) 2> stop * Sending STOP request to EXTRACT EXT-ECP ... ERROR: sending message to EXTRACT EXT-ECP (Timeout waiting for message). Sending STOP request to EXTRACT EXT-EDS ... ERROR: sending message to EXTRACT EXT-EDS (Timeout waiting for message). Sending STOP request to EXTRACT EXT-XZ ... ERROR: sending message to EXTRACT EXT-XZ (Timeout waiting for message). Sending STOP request to EXTRACT P-EDS ... ERROR: sending message to EXTRACT P-EDS (Timeout waiting for message). Sending STOP request to EXTRACT P-XZ ... ERROR: sending message to EXTRACT P-XZ (Timeout waiting for message). Sending STOP request to REPLICAT REP-BOS ... ERROR: sending message to REPLICAT REP-BOS (Timeout waiting for message). GGSCI (localhost.localdomain) 3> stop mgr! Sending STOP request to MANAGER ... Request processed. Manager stopped. GGSCI (localhost.localdomain) 4> info all Program Status Group Lag Time Since Chkpt MANAGER STOPPED EXTRACT RUNNING EXT-ECP 00:00:00 unknown EXTRACT RUNNING EXT-EDS 00:00:00 unknown EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown GGSCI (localhost.localdomain) 5> kill EXT-ECP ERROR: Manager not currently running. GGSCI (localhost.localdomain) 6> kill EXT-EDS ERROR: Manager not currently running. GGSCI (localhost.localdomain) 7> info all Program Status Group Lag Time Since Chkpt MANAGER STOPPED EXTRACT RUNNING EXT-ECP 00:00:00 unknown EXTRACT RUNNING EXT-EDS 00:00:00 unknown EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown GGSCI (localhost.localdomain) 8> exit --使用stop 进程，stop mgr，kill 进程都不能正常关闭这些进程
3、系统系统级别kill相关ogg进程
[oracle@localhost OGG]$ ps -ef|grep /opt/OGG oracle 7479 1 0 Nov10 ? 00:03:31 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-ecp.prm REPORTFILE /opt/OGG/dirrpt/EXT-ECP.rpt PROCESSID EXT-ECP USESUBDIRS oracle 7480 1 0 Nov10 ? 00:02:30 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-eds.prm REPORTFILE /opt/OGG/dirrpt/EXT-EDS.rpt PROCESSID EXT-EDS USESUBDIRS oracle 7482 1 0 Nov10 ? 00:03:07 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-xz.prm REPORTFILE /opt/OGG/dirrpt/EXT-XZ.rpt PROCESSID EXT-XZ USESUBDIRS oracle 7483 1 0 Nov10 ? 00:00:01 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/p-eds.prm REPORTFILE /opt/OGG/dirrpt/P-EDS.rpt PROCESSID P-EDS USESUBDIRS oracle 7485 1 0 Nov10 ? 00:00:03 /opt/OGG/replicat PARAMFILE /opt/OGG/dirprm/rep-bos.prm REPORTFILE /opt/OGG/dirrpt/REP-BOS.rpt PROCESSID REP-BOS USESUBDIRS oracle 7518 1 0 Nov10 ? 00:00:01 ./server -p 7847 -k -l /opt/OGG/ggserr.log oracle 7677 1 0 Nov10 ? 00:00:15 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/p-xz.prm REPORTFILE /opt/OGG/dirrpt/P-XZ.rpt PROCESSID P-XZ USESUBDIRS oracle 25261 25112 0 12:48 pts/1 00:00:00 grep /opt/OGG [oracle@localhost OGG]$ kill -9 7479 7480 7482 7483 7485 7518 7677 [oracle@localhost OGG]$ ps -ef|grep /opt/OGG oracle 25264 25112 0 12:48 pts/1 00:00:00 grep /opt/OGG
4、重启所有ogg进程
[oracle@localhost OGG]$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.1.1.0.0 Build 078 Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11 Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved. GGSCI (localhost.localdomain) 1> info all Program Status Group Lag Time Since Chkpt MANAGER STOPPED EXTRACT ABENDED EXT-ECP 00:00:00 unknown EXTRACT ABENDED EXT-EDS 00:00:00 unknown EXTRACT ABENDED EXT-XZ 00:00:00 unknown EXTRACT ABENDED P-EDS 00:00:00 unknown EXTRACT ABENDED P-XZ 00:00:00 unknown REPLICAT ABENDED REP-BOS 00:00:00 unknown --进程状态还是异常 GGSCI (localhost.localdomain) 2> start mgr Manager started. GGSCI (localhost.localdomain) 3> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT-ECP 00:00:00 unknown EXTRACT RUNNING EXT-EDS 00:00:00 unknown EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown --进程起来了，但是Time Since Chkpt还是不正确 GGSCI (localhost.localdomain) 4> stop ext-ecp Sending STOP request to EXTRACT EXT-ECP ... Request processed. GGSCI (localhost.localdomain) 5> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXT-ECP unknown 00:00:02 EXTRACT RUNNING EXT-EDS 00:00:00 unknown EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown --关闭EXT-ECP测试，状态正常 GGSCI (localhost.localdomain) 6> start ext-ecp Sending START request to MANAGER ... EXTRACT EXT-ECP starting GGSCI (localhost.localdomain) 7> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT-ECP unknown 00:00:14 EXTRACT RUNNING EXT-EDS 00:00:00 unknown EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown --Lag异常，等待恢复 GGSCI (localhost.localdomain) 8> stop ext-eds Sending STOP request to EXTRACT EXT-EDS ... Recovery is not complete. This normal stop will wait and checkpoint recovery's work when recovery has finished. To force Extract to stop now, use the SEND EXTRACT EXT-EDS, FORCESTOP command. --因为恢复没有完成导致该提示，可以忽略，等待 GGSCI (localhost.localdomain) 9> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT-ECP unknown 00:00:02 EXTRACT STOPPED EXT-EDS 01:51:12 00:00:01 EXTRACT RUNNING EXT-IM 00:00:00 1059:44:26 EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 unknown GGSCI (localhost.localdomain) 10> start ext-eds Sending START request to MANAGER ... EXTRACT EXT-EDS starting GGSCI (localhost.localdomain) 11> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT-ECP 99:53:02 00:00:01 EXTRACT RUNNING EXT-EDS 01:51:12 00:00:10 EXTRACT RUNNING EXT-XZ 00:00:00 unknown EXTRACT RUNNING P-EDS 00:00:00 unknown EXTRACT RUNNING P-XZ 00:00:00 unknown REPLICAT RUNNING REP-BOS 00:00:00 00:00:00 GGSCI (localhost.localdomain) 12> stop ext-xz Sending STOP request to EXTRACT EXT-XZ ... Request processed. GGSCI (localhost.localdomain) 13> start ext-xz Sending START request to MANAGER ... EXTRACT EXT-XZ starting GGSCI (localhost.localdomain) 15> stop p-eds Sending STOP request to EXTRACT P-EDS ... Request processed. GGSCI (localhost.localdomain) 16> start p-eds Sending START request to MANAGER ... EXTRACT P-EDS starting GGSCI (localhost.localdomain) 17> stop p-xz Sending STOP request to EXTRACT P-XZ ... Request processed. GGSCI (localhost.localdomain) 18> start p-xz Sending START request to MANAGER ... EXTRACT P-XZ starting GGSCI (localhost.localdomain) 19> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT-ECP 00:00:00 00:00:01 EXTRACT RUNNING EXT-EDS 00:00:00 00:00:10 EXTRACT RUNNING EXT-IM 00:00:00 1059:45:28 EXTRACT RUNNING EXT-XZ 00:00:00 00:00:07 EXTRACT RUNNING P-EDS 00:00:00 00:00:04 EXTRACT RUNNING P-XZ 00:00:00 00:00:05 REPLICAT RUNNING REP-BOS 00:00:00 00:00:05 --重启所有异常进程，ogg工作正常 GGSCI (localhost.localdomain) 20>
5、总结处理步骤
强制关闭mgr,系统级别kill相关ogg进程,开启ogg主进程,重启相关进程
