查看: 1491|回复: 14
部署了ogg，该怎么备份啊
论坛徽章:3
各位，最近部署了一套rac-&单库的ogg，rac开启了归档，想请教一下，生产库用rman备份，该如何处理归档呢？
如何保证可以删除的归档已经应用到了备库？求教！
认证徽章论坛徽章:836
少删点呗，保留个一天两天之类的
论坛徽章:3
这个也不保险啊，如果这1,2天ogg出现问题，而没有发现，那不是要重同步了？
有没有向dg一样，设置一个参数，可以保证没有被应用到备库的归档是不能被删除的？
论坛徽章:20
归档日志多保留一段时间 另外ogg的监控做好
招聘 : 认证徽章论坛徽章:597
没啥好法子，保留1,2天归档日志，并写代码监控OGG
论坛徽章:3
各位ogg监控脚本有么？
招聘 : 论坛徽章:17
ogg 用的是自己的trail file吧， 给归档日志保留3天或者不删除，给ogg的trail file的目录留大，及时备库有问题了，还有trail file在呢
论坛徽章:3
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY&&， 要在配置primary extract 之前做。
论坛徽章:3
paomananshan 发表于
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY&&， 要在配置primary extract 之前做。
这不是在dg上用的么，ogg也能用？
论坛徽章:3
novmcgrady 发表于
这不是在dg上用的么，ogg也能用？
跟你说的就是ogg的环境，自己找找ogg的官方文档，有相关配置。
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号配置OGG到MySQL复制时登陆MySQL报错解决_数据库技术_Linux公社-Linux系统门户网站
你好，游客
配置OGG到MySQL复制时登陆MySQL报错解决
来源：Linux社区&
作者：还不算晕
1.MYSQL登陆报错[@bys2 mysqlogg]$ mysql -u root -pEnter password: ERROR ): Access denied for user 'root'@'localhost' (using password: YES)此时使用 mysql -u root 即不使用密码可以登陆。重改密码：使用root用户操作# /etc/init.d/mysql stop# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &# mysql -u root mysqlmysql& UPDATE user SET Password=PASSWORD('newpassword') where USER='root';mysql& FLUSH PRIVILEGES; ---刷新数据库中数据。mysql& quit# /etc/init.d/mysqld restart此时就可以使用密码登陆了。# mysql -u root -pEnter password:mysql&2.OGG中登陆MYSQL报错解决GGSCI () 2& dblogin sourcedb oggtest,userid rootPassword:
12:03:14 WARNING OGG-00769 MySQL Login failed: . SQL error (2002). Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE , USER root, PORT 3306.GGSCI () 3& exit[oracle@bys2 mysqlogg]$ su -Password: [root@bys2 ~]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock[root@bys2 ~]# exitlogout[oracle@bys2 mysqlogg]$ ./ggsciOracle GoldenGate Command Interpreter for MySQLVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_0Linux, x86, 32bit (optimized), MySQL Enterprise on Apr 23 :30Copyright (C) , Oracle and/or its affiliates. All rights reserved.GGSCI () 1& dblogin sourcedb oggtest,userid rootPassword: Successfully logged into database.
推荐阅读：
两台Oracle之间配置OGG-未配置同步DDL&
OGG配置DML单向复制一例及错误分析
OGG-00446 ERROR: Could not find archived log&
Oracle Linux 5.7 部署OGG v11 oracle to oracle&
GoldenGate源端意外宕机，导致OGG-01031报错&
相关资讯 & & &
& (12/08/:37)
& (08/22/:10)
& (01月23日)
& (11/29/:29)
& (06/12/:43)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款>> 《子弹风暴》缺少vorbisfile.dll、ogg.dll错误的解决方法
《子弹风暴》缺少vorbisfile.dll、ogg.dll错误的解决方法
发表： 来源：多游网作者：jason 浏览：4
1、出现缺少vorbisfile.dll、ogg.dll错误
请运行BinariesWin32ShippingPC-StormGame.exe
所有需要的文件都在这个目录里。
2、出现xlive.dll 5366错误
请安装xlive 3.0旧版
发布此文仅为传递信息，认同其观点或证实其描述。
/gl/.html复制本文链接
新游测试表
04-2215:00万仞峡谷资料片04-1519:00南宫剑岛服03-1623:00乘风破浪03-1623:00江山多娇03-1622:00乘风破浪03-1622:00江山多娇03-1621:00乘风破浪03-1621:00江山多娇
03-1623:00双线1服03-1622:00双线1服03-1621:00双线1服03-1620:00双线1服03-1619:00双线1服03-1618:00双线1服03-1617:00双线1服03-1616:00双线1服
04-0610:00皇图471服04-0510:00S27服04-0310:00皇图470服03-3010:00皇图469服03-2810:00S26服03-2710:00皇图468服03-2310:00皇图467服03-2010:00皇图466服
热门标签推荐温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
& 10:45:54&&ERROR&& OGG-01031& Oracle GoldenGate Capture for Oracle, dpump.prm:& There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/home/oracle/ggs/dirdat/k1005466" (error 11, Resource temporarily unavailable)). 10:45:54& ERROR&& OGG-01668& Oracle GoldenGate Capture for Oracle, dpump.prm:& PROCESS ABENDING.&该错误官方说明如下：&OGG-01031: There is a problem in network communication, a remote file problem,encryption keys for target and source do not match (if using ENCRYPT) or anunknown error. (Reply received is {0})Cause: Extract was not able to send data to the target.Action: Examine the network for an outage between the source and target system.Make certain that MGRPORT in RMTHOST matches the one in the parameter fileof the remote Manager. Check for errors on the target system that indicate theManager or Collector process is not running, or that Collector does not haveprivileges to write to the remote trail. Check for encryption errors if the ENCRYPToption is specified with the RMTHOST or RMTHOSTOPTIONS parameter: Thismight indicate that the encryption key that was sent from the source does notmatch the one in the ENCKEYS file on the target, or that the key or ENCKEYS fileon the target is missing.&貌似是网络原因造成的，排查源库和目标库的相关参数发现，都是一致的，也没什么问题，再到目标库查看相关进程都是running状态，但是出现了一个比较明显的告警信息，如下：& 10:57:50&&WARNING OGG-01223& Oracle GoldenGate Collector for Oracle:& Unable to lock file "/home/oracle/ggs/dirdat/k1005466" (error 11, Resource temporarily unavailable).& Lock currently held by process id (PID) 1731. 10:57:50& WARNING OGG-01223& Oracle GoldenGate Collector for Oracle:& Unable to open file "/home/oracle/ggs/dirdat/k1005466" (error 11, Resource temporarily unavailable). 10:57:50& INFO&&& OGG-01676& Oracle GoldenGate Collector for Oracle:& Terminating after client disconnect. 10:59:22& INFO&&& OGG-00963& Oracle GoldenGate Manager for Oracle, mgr.prm:& Command received from EXTRACT on host &unknown& (START SERVER CPU -1 PRI -1& TIMEOUT 300 PARAMS ). 10:59:22& INFO&&& OGG-01677& Oracle GoldenGate Collector for Oracle:& Waiting for connection (started dynamically). 10:59:22& INFO&&& OGG-00963& Oracle GoldenGate Manager for Oracle, mgr.prm:& Command received from SERVER on host localhost.localdomain (REPORT ). 10:59:22& INFO&&& OGG-00974& Oracle GoldenGate Manager for Oracle, mgr.prm:& Manager started collector process (Port 7810). 10:59:22& INFO&&& OGG-01228& Oracle GoldenGate Collector for Oracle:& Timeout in 300 seconds.&仔细观察发现，源和目标库的相关操作都是对目标库的trail文件k1005466进行操作的，推测大致的过程是这样的：启动pump进程后，该进程要往目标库的第5466号trail文件写数据，而此时目标库的该文件被进程编号为1731的进程所锁定，pump无法获得该文件上的锁，造成等待，延时，最终超时而abend掉（这种情况表面看来很像是由于网络原因造成的，其实不然），之后在目标库查看1731号进程的具体情况如下：&[oracle@trptdb ggs]$ ps -ef | grep 1731oracle&&& 1731&&&& 1& 0 May23 ?&&&&&&& 00:00:13 ./server -w 300 -p
-m 7809 -k -l /home/oracle/ggs/ggserr.logoracle&& & 0 10:58 pts/1&&& 00:00:00 grep 1731&发现是ogg的server进程锁住了第5466号文件，推测应该是读取5466号文件写入ggserr log所造成吧，具体有待查证，之后干脆直接kill掉该进程，然后再次启动源库的pump进程，2端开始正常应用：&源库ggserr.log：& 10:52:26& INFO&&& OGG-00987& Oracle GoldenGate Command Interpreter for Oracle:& GGSCI command (oracle): start dpump. 10:52:26& INFO&&& OGG-00963& Oracle GoldenGate Manager for Oracle, mgr.prm:& Command received from GGSCI on host 127.0.0.1 (START EXTRACT DPUMP ). 10:52:26& INFO&&& OGG-00975& Oracle GoldenGate Manager for Oracle, mgr.prm:& EXTRACT DPUMP starting. 10:52:26& INFO&&& OGG-00992& Oracle GoldenGate Capture for Oracle, dpump.prm:& EXTRACT DPUMP starting. 10:52:26& INFO&&& OGG-00993& Oracle GoldenGate Capture for Oracle, dpump.prm:& EXTRACT DPUMP started. 10:52:31& INFO&&& OGG-01226& Oracle GoldenGate Capture for Oracle, dpump.prm:& Socket buffer size set to 27985 (flush size 27985). 10:52:32& INFO&&& OGG-01056& Oracle GoldenGate Capture for Oracle, dpump.prm:& Recovery initialization completed for target file /home/oracle/ggs/dirdat/k1005466, at RBA 5777739, CSN . 10:52:32& INFO&&& OGG-01478& Oracle GoldenGate Capture for Oracle, dpump.prm:& Output file /home/oracle/ggs/dirdat/k1 is using format RELEASE 10.4/11.1. 10:52:32& INFO&&& OGG-01026& Oracle GoldenGate Capture for Oracle, dpump.prm:& Rolling over remote file /home/oracle/ggs/dirdat/k1005467. 10:52:32& INFO&&& OGG-01054& Oracle GoldenGate Capture for Oracle, dpump.prm:& Recovery completed for target file /home/oracle/ggs/dirdat/k1005467, at RBA 1393, CSN . 10:52:32& INFO&&& OGG-01057& Oracle GoldenGate Capture for Oracle, dpump.prm:& Recovery completed for all targets. 10:52:33& WARNING OGG-00869& Oracle GoldenGate Capture for Oracle, dpump.prm:& No unique key is defined for table M_GOODS_STOCK2. All viable columns will be used to represent the key, but may not guarantee uniqueness.& KEYCOLS may be used to define the key. 10:52:33& WARNING OGG-00869& Oracle GoldenGate Capture for Oracle, dpump.prm:& No unique key is defined for table M_GOODS_STOCK. All viable columns will be used to represent the key, but may not guarantee uniqueness.& KEYCOLS may be used to define the key. 10:52:34& WARNING OGG-00869& Oracle GoldenGate Capture for Oracle, dpump.prm:& No unique key is defined for table M_PAGE_CLICK. All viable columns will be used to represent the key, but may not guarantee uniqueness.& KEYCOLS may be used to define the key.&目标库ggserr.log：& 10:59:27& INFO&&& OGG-01229& Oracle GoldenGate Collector for Oracle:& Connected to :22983. 10:59:27& INFO&&& OGG-01669& Oracle GoldenGate Collector for Oracle:& Opening /home/oracle/ggs/dirdat/k1005466 (byte -1, current EOF 5777739). 10:59:27& INFO&&& OGG-01670& Oracle GoldenGate Collector for Oracle:& Closing /home/oracle/ggs/dirdat/k1005466. 10:59:27& INFO&&& OGG-01669& Oracle GoldenGate Collector for Oracle:& Opening /home/oracle/ggs/dirdat/k1005466 (byte 5777739, current EOF 5777739). 10:59:27& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005466 to disk. 10:59:27& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005466 to disk. 10:59:27& INFO&&& OGG-01670& Oracle GoldenGate Collector for Oracle:& Closing /home/oracle/ggs/dirdat/k1005466. 10:59:27& INFO&&& OGG-01669& Oracle GoldenGate Collector for Oracle:& Opening /home/oracle/ggs/dirdat/k1005467 (byte -1, current EOF 0). 10:59:27& INFO&&& OGG-01020& Oracle GoldenGate Delivery for Oracle, rep1.prm:& Processed extract process RESTART_ABEND record at seq 5467, rba 1333 (aborted 0 records). 10:59:30& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005467 to disk. 10:59:30& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005467 to disk. 10:59:30& INFO&&& OGG-01670& Oracle GoldenGate Collector for Oracle:& Closing /home/oracle/ggs/dirdat/k1005467. 10:59:30& INFO&&& OGG-01669& Oracle GoldenGate Collector for Oracle:& Opening /home/oracle/ggs/dirdat/k1005468 (byte -1, current EOF 0). 10:59:31& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005468 to disk. 10:59:31& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005468 to disk. 10:59:31& INFO&&& OGG-01670& Oracle GoldenGate Collector for Oracle:& Closing /home/oracle/ggs/dirdat/k1005468. 10:59:31& INFO&&& OGG-01669& Oracle GoldenGate Collector for Oracle:& Opening /home/oracle/ggs/dirdat/k1005469 (byte -1, current EOF 0). 10:59:33& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005469 to disk. 10:59:33& INFO&&& OGG-01735& Oracle GoldenGate Collector for Oracle:& Synchronizing /home/oracle/ggs/dirdat/k1005469 to disk. 10:59:33& INFO&&& OGG-01670& Oracle GoldenGate Collector for Oracle:& Closing /home/oracle/ggs/dirdat/k1005469. 10:59:33& INFO&&& OGG-01669& Oracle GoldenGate Collector for Oracle:& Opening /home/oracle/ggs/dirdat/k1005470 (byte -1, current EOF 0). 10:59:41& WARNING OGG-00869& Oracle GoldenGate Delivery for Oracle, rep1.prm:& No unique key is defined for table 'M_GOODS_STOCK2'. All viable columns will be used to represent the key, but may not guarantee uniqueness.& KEYCOLS may be used to define the key.&由此看来遇到问题的时候，errlog里面会提供大量有用的排错信息，这一点也需要细心和耐心，同时可以查阅官方对错误和警告的详细说明，对解决问题很有帮助。&------附：碰到一则类似案例---------------------远端的ext1抽取进程起不来，报错如下：85). 16:47:06 &ERROR & OGG-01031 &Oracle GoldenGate Capture for Oracle, ext1.prm: &There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/u01/ggate/dirdat/lt000000" (error 11, Resource temporarily unavailable)). 16:47:06 &ERROR & OGG-01668 &Oracle GoldenGate Capture for Oracle, ext1.prm: &PROCESS ABENDING.查看目标端的ggserr.log ：013-09-20 16:39:29 &WARNING OGG-01223 &Oracle GoldenGate Collector for Oracle: &Unable to lock file "/u01/ggate/dirdat/lt000000" (error 11, Resource temporarily unavailable). &Lock currently held by process id (PID) 16402. 16:39:29 &WARNING OGG-01223 &Oracle GoldenGate Collector for Oracle: &Unable to open file "/u01/ggate/dirdat/lt000000" (error 11, Resource temporarily unavailable). 16:39:29 &INFO & &OGG-01676 &Oracle GoldenGate Collector for Oracle: &Terminating after client disconnect.与上文出现的问题症状相似，然后目标端执行：root@oracle11g ~]# ps -ef|grep 16402oracle &
&0 10:36 ? & & & &00:00:03 ./server -w 300 -p
-m 7809 -k -l /u01/ggate/ggserr.logroot & &
&0 16:43 pts/3 & &00:00:00 grep 16402[root@oracle11g ~]# kill -9 16402在源端重启：ext1进程，问题解决。
阅读(1324)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_',
blogTitle:'OGG-01031错误处理一例（转）',
blogAbstract:'from：http://space.itpub.net//viewspace-730797刚刚观察测试库gg运行状况发现，pump进程异常abend，err log报错日志如下：& 10:45:54&&ERROR&& OGG-01031& Oracle GoldenGate Capture for Oracle, dpump.prm:& There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT)',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:2,
publishTime:4,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
hmcon:'0',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}