{"id":827,"date":"2013-04-24T15:30:14","date_gmt":"2013-04-24T07:30:14","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=827"},"modified":"2013-04-24T15:34:19","modified_gmt":"2013-04-24T07:34:19","slug":"rsm0%e8%bf%9b%e7%a8%8b%e5%bc%95%e8%b5%b7alert%e6%97%a5%e5%bf%97%e6%9a%b4%e5%a2%9e%e7%9a%84%e5%a4%84%e7%90%86%e8%bf%87%e7%a8%8b","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=827","title":{"rendered":"RSM0\u8fdb\u7a0b\u5f15\u8d77alert\u65e5\u5fd7\u66b4\u589e\u7684\u5904\u7406\u8fc7\u7a0b"},"content":{"rendered":"

RSM0\u8fdb\u7a0b\u5f15\u8d77alert\u65e5\u5fd7\u66b4\u589e\u7684\u5904\u7406\u8fc7\u7a0b
\n\u6574\u4f53\u67b6\u6784\u5982\u4e0b\uff1a
\n\"rac_dg1\"<\/a>
\n\u5728alert\u65e5\u5fd7\u4e2d\u4e0d\u65ad\u91cd\u590d\u51fa\u73b0\u4ee5\u4e0b\u4fee\u6539\u53c2\u6570\u7684\u8bb0\u5f55\uff1a<\/p>\n

\r\n<msg time='2013-04-24T10:50:44.736+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='XXX21DBRAC1' host_addr='xx.x.x.xx' module=''\r\n pid='31902'>\r\n <txt>ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID=&apos;XXXdb1&apos;;\r\n <\/txt>\r\n<\/msg>\r\n<msg time='2013-04-24T10:50:44.747+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='XXX21DBRAC1' host_addr='xx.x.x.xx' module=''\r\n pid='31902'>\r\n <txt>ALTER SYSTEM SET log_archive_format=&apos;%t_%s_%r.dbf&apos; SCOPE=SPFILE SID=&apos;XXXdb1&apos;;\r\n <\/txt>\r\n<\/msg>\r\n<msg time='2013-04-24T10:50:44.783+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='XXX21DBRAC1' host_addr='xx.x.x.xx' module=''\r\n pid='31902'>\r\n <txt>ALTER SYSTEM SET standby_file_management=&apos;MANUAL&apos; SCOPE=BOTH SID=&apos;*&apos;;\r\n <\/txt>\r\n<\/msg>\r\n<msg time='2013-04-24T10:50:44.816+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='XXX21DBRAC1' host_addr='xx.x.x.xx' module=''\r\n pid='31902'>\r\n <txt>ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID=&apos;*&apos;;\r\n <\/txt>\r\n<\/msg>\r\n<msg time='2013-04-24T10:50:44.849+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='XXX21DBRAC1' host_addr='xx.x.x.xx' module=''\r\n pid='31902'>\r\n <txt>ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID=&apos;*&apos;;\r\n <\/txt>\r\n<\/msg>\r\n<msg time='2013-04-24T10:50:44.883+08:00' org_id='oracle' comp_id='rdbms'\r\n client_id='' type='UNKNOWN' level='16'\r\n host_id='XXX21DBRAC1' host_addr='xx.x.x.xx' module=''\r\n pid='31902'>\r\n <txt>ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID=&apos;*&apos;;\r\n <\/txt>\r\n<\/msg>\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u53d1\u73b0\u90fd\u662f\u4ecexx.x.x.xx\u81ea\u8eab\u53d1\u51fa\u7684\u547d\u4ee4<\/p>\n
\u6839\u636e\u65e5\u5fd7\u6587\u4ef6\u4e2d\u7684pid\u67e5\u770b\u8fdb\u7a0b<\/p>\n
\r\n[oracle@XXX21DBRAC1 ~]$ ps -ef | grep 31902\r\noracle   18995 18966  0 12:14 pts\/1    00:00:00 grep 31902\r\noracle   31902     1  1 Mar01 ?        18:04:30 ora_rsm0_XXXdb1\r\n<\/pre>\n
\u6ce8\u91ca\uff1a
\nRSM0\tData Guard Broker Resource Guard Process 0   \u662f broker\u7684\u8fdb\u7a0b
\nrsm\uff08broker resource manager\uff09\u8d1f\u8d23\u5904\u7406broker\u4f7f\u7528\u7684\u3001\u9700\u8981\u5728\u914d\u7f6e\u4e2d\u7684\u4e00\u4e2a\u6570\u636e\u5e93\u4e0a\u6267\u884c\u4efb\u4f55sql\u547d\u4ee4\u3002
\n\u901a\u8fc7dgmgrl\u4fee\u6539\u4e86\u914d\u7f6e\uff0c\u53ef\u80fd\u662f\u6570\u636e\u5e93\u5728\u542f\u52a8\u8fc7\u7a0b\u4e2d\u7531broker\u6267\u884c\u7684\u914d\u7f6e\u547d\u4ee4\u3002<\/p>\n
\u76f8\u5173\u8fdb\u7a0b\u8fd8\u6709\uff1a
\nRSM0\tData Guard Broker Resource Guard Process 0
\nRSM1\tData Guard Broker Resource Guard Process 1
\nNSV0\tData Guard Broker NetSlave Process 0
\nNSV1\tData Guard Broker NetSlave Process 1
\nNSV2\tData Guard Broker NetSlave Process 2
\nNSV3\tData Guard Broker NetSlave Process 3
\nNSV4\tData Guard Broker NetSlave Process 4
\nNSV5\tData Guard Broker NetSlave Process 5
\nNSV6\tData Guard Broker NetSlave Process 6
\nNSV7\tData Guard Broker NetSlave Process 7
\nNSV8\tData Guard Broker NetSlave Process 8
\nNSV9\tData Guard Broker NetSlave Process 9
\nINSV\tData Guard Broker INstance SlaVe Process<\/p>\n
\u6ce8\u610f\uff1a
\n\u4e00\u65e6\u5f00\u59cb\u4f7f\u7528broker\u5c31\u5fc5\u987b\u4e00\u76f4\u4f7f\u7528\u5b83\u4fee\u6539dg\u7684\u914d\u7f6e\u3002
\n\u5982\u679c\u4e4b\u540e\u4f7f\u7528sql*plus\u4fee\u6539\u914d\u7f6e\uff0cbroker\u4f1a\u5c06\u5176\u8fd8\u539f\u6216\u8005\u5bfc\u81f4broker\u914d\u7f6e\u548c\u6570\u636e\u5e93\u914d\u7f6e\u4e4b\u95f4\u4e0d\u4e00\u81f4\u3002
\n\u5982\u679c\u5378\u8f7dbroker\uff0c\u5c06\u4e0d\u5f97\u4e0d\u91cd\u65b0\u914d\u7f6edg\uff0c\u4ee5\u8fd4\u56de\u539f\u59cb\u7684\u8bbe\u7f6e\u3002<\/p>\n
\u53c2\u6570\uff1adg_broker_start=true   \u6240\u6709\u8282\u70b9\u4fee\u6539\u5c06\u542f\u7528broker<\/p>\n
\u5b9e\u9645\u67e5\u770b\u5982\u4e0b\uff1a<\/p>\n
\r\n[oracle@XXX21DBRAC1 ~]$ ps -ef | grep nsv\r\noracle   26609 26568  0 13:05 pts\/1    00:00:00 grep nsv\r\noracle   31893     1  0 Mar01 ?        00:03:25 ora_insv_XXXdb1\r\noracle   31900     1  0 Mar01 ?        00:11:48 ora_nsv1_XXXdb1\r\n[oracle@XXX21DBRAC1 ~]$ cd\r\n[oracle@XXX21DBRAC1 ~]$ \r\n[oracle@XXX21DBRAC1 ~]$ dgmgrl \/\r\nDGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production\r\n\r\nCopyright (c) 2000, 2009, Oracle. All rights reserved.\r\n\r\nWelcome to DGMGRL, type "help" for information.\r\nConnected.\r\nDGMGRL> show configuration\r\n\r\nConfiguration - dg2012\r\n\r\n  Protection Mode: MaxPerformance\r\n  Databases:\r\n    XXXdb_p - Primary database\r\n      Warning: ORA-16532: Data Guard broker configuration does not exist\r\n\r\n    XXXdb_s - Physical standby database (disabled)\r\n\r\nFast-Start Failover: DISABLED\r\n\r\nConfiguration Status:\r\nWARNING\r\n<\/pre>\n
\u8282\u70b92\uff1a<\/p>\n
\r\n[oracle@XXX21DBRAC2 ~]$ dgmgrl \/\r\nDGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production\r\n\r\nCopyright (c) 2000, 2009, Oracle. All rights reserved.\r\n\r\nWelcome to DGMGRL, type "help" for information.\r\nConnected.\r\nDGMGRL> show configuration\r\nORA-16532: Data Guard broker configuration does not exist\r\n\r\nConfiguration details cannot be determined by DGMGRL\r\n<\/pre>\n
\u67e5\u770b\u5404\u8282\u70b9\u53c2\u6570\u8bbe\u7f6e\uff1a
\n\u8282\u70b91\uff1a<\/p>\n
\r\nSQL> show parameter dg_\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndg_broker_config_file1               string      \/u01\/app\/oracle\/product\/11.2.0\r\n                                                 \/dbhome_1\/dbs\/dr1XXXDB_P.dat\r\ndg_broker_config_file2               string      \/u01\/app\/oracle\/product\/11.2.0\r\n                                                 \/dbhome_1\/dbs\/dr2XXXDB_P.dat\r\ndg_broker_start                      boolean     TRUE\r\n\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n+DATA\/XXXdb\/datafile\/system.256.788703825\r\n+DATA\/XXXdb\/datafile\/sysaux.257.788703825\r\n+DATA\/XXXdb\/datafile\/undotbs1.258.788703825\r\n+DATA\/XXXdb\/datafile\/users.259.788703825\r\n+DATA\/XXXdb\/datafile\/undotbs2.271.788704025\r\n+DATA\/XXXdb\/datafile\/XXX21_01.dbf\r\n+DATA\/XXXdb\/datafile\/XXX11_01.dbf\r\n+DATA\/XXXdb\/datafile\/sysaux02.dbf\r\n+DATA\/XXXdb\/datafile\/system02.dbf\r\n\r\n9 rows selected.\r\n<\/pre>\n
\u8282\u70b92\uff1a<\/p>\n
\r\nSQL> show parameter dg\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndg_broker_config_file1               string      \/u01\/app\/oracle\/product\/11.2.0\r\n                                                 \/dbhome_1\/dbs\/dr1XXXDB_P.dat\r\ndg_broker_config_file2               string      \/u01\/app\/oracle\/product\/11.2.0\r\n                                                 \/dbhome_1\/dbs\/dr2XXXDB_P.dat\r\ndg_broker_start                      boolean     TRUE\r\n\r\n<\/pre>\n
\u8bf4\u660e\u4e3b\u5e93\u542f\u7528\u4e86broker\u4f46\u662f\u914d\u7f6e\u5b58\u5728\u95ee\u9898\u3002<\/p>\n
\u5efa\u8bae\u5c06\u4e3b\u5e93\u6240\u6709\u5b9e\u4f8b\u53c2\u6570dg_broker_start \u8bbe\u7f6e\u4e3afalse\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
RSM0\u8fdb\u7a0b\u5f15\u8d77alert\u65e5\u5fd7\u66b4\u589e\u7684\u5904\u7406\u8fc7\u7a0b \u6574\u4f53\u67b6\u6784\u5982\u4e0b\uff1a \u5728alert\u65e5\u5fd7\u4e2d\u4e0d\u65ad\u91cd\u590d\u51fa\u73b0\u4ee5\u4e0b\u4fee\u6539\u53c2\u6570\u7684\u8bb0\u5f55 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,36],"tags":[183,182],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/827"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=827"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/827\/revisions"}],"predecessor-version":[{"id":829,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/827\/revisions\/829"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=827"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}