{"id":1348,"date":"2014-10-17T22:47:30","date_gmt":"2014-10-17T14:47:30","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1348"},"modified":"2014-12-27T18:13:20","modified_gmt":"2014-12-27T10:13:20","slug":"ora-38760_dg%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8mrp%e8%bf%9b%e7%a8%8b","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1348","title":{"rendered":"ORA-38760_DG\u65e0\u6cd5\u542f\u52a8MRP\u8fdb\u7a0b"},"content":{"rendered":"<p>\u8bb0\u5f55\u4e00\u6b21ORA-38760_DG\u65e0\u6cd5\u542f\u52a8MRP\u8fdb\u7a0b<br \/>\n\u73b0\u8c61\u662f\u76d1\u63a7\u62a5\u8b66\u79f0\u4e3b\u5907\u5e93\u65e5\u5fd7\u5e94\u7528\u4e0d\u540c\u6b65\uff0c\u767b\u5230\u5907\u5e93\u67e5\u770bmrp\u8fdb\u7a0b\u4e0d\u5b58\u5728\uff0c\u968f\u5373\u542f\u52a8mrp\u8fdb\u7a0b\uff0c\u524d\u53f0\u6b63\u5e38\u8fd4\u56de\u65e0\u62a5\u9519\uff0c\u4f46\u662fmrp\u8fdb\u7a0b\u8fd8\u662f\u6ca1\u6709\u542f\u52a8\u8d77\u6765\u3002<br \/>\n\u5982\u4e0b\uff1a<\/p>\n<p>\u524d\u53f0\u6267\u884c<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; alter database recover managed standby database disconnect from session parallel 2;\r\n\r\nDatabase altered.\r\n<\/pre>\n<p><strong>\u6b63\u5e38\u8fd4\u56de\uff0c\u4f46\u662fmrp\u8fdb\u7a0b\u6ca1\u6709\u542f\u52a8<\/strong><br \/>\nalert\u62a5\u9519<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nThu Oct 16 09:58:40 2014\r\nMRP0: Background Media Recovery terminated with error 38760\r\nErrors in file \/oradata\/diag\/rdbms\/xxxxxs2\/xxxxxs2\/trace\/xxxxxs2_pr00_15195.trc:\r\nORA-38760: This database instance failed to turn on flashback database\r\nSlave exiting with ORA-38760 exception\r\nErrors in file \/oradata\/diag\/rdbms\/xxxxxs2\/xxxxxs2\/trace\/xxxxxs2_pr00_15195.trc:\r\nORA-38760: This database instance failed to turn on flashback database\r\nRecovery Slave PR00 previously exited with exception 38760\r\nMRP0: Background Media Recovery process shutdown (xxxxxs2)\r\nCompleted: alter database recover managed standby database disconnect from session parallel 2\r\n<\/pre>\n<p><strong>\u5220\u9664\u95ea\u56de\u6062\u590d\u70b9\u540e\u6b63\u5e38<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; select flashback_on from v$database;\r\n\r\nFLASHBACK_ON\r\n------------------\r\nRESTORE POINT ONLY\r\n\r\nSQL&gt; select * from v$restore_point;\r\n\r\n       SCN DATABASE_INCARNATION# GUA STORAGE_SIZE\r\n---------- --------------------- --- ------------\r\nTIME\r\n---------------------------------------------------------------------------\r\nRESTORE_POINT_TIME                                                          PRE\r\n--------------------------------------------------------------------------- ---\r\nNAME\r\n--------------------------------------------------------------------------------\r\n 629694310                     2 YES   5972688896\r\n28-AUG-14 10.20.34.000000000 AM\r\n                                                                            YES\r\nRESTORE_POINT_TEST\r\n\r\n\r\nSQL&gt; drop restore point RESTORE_POINT_TEST;\r\n\r\nRestore point dropped.\r\n\r\nSQL&gt; select flashback_on from v$database;\r\n\r\nFLASHBACK_ON\r\n------------------\r\nNO\r\n\r\nSQL&gt; select open_mode from v$database;\r\n\r\nOPEN_MODE\r\n--------------------\r\nMOUNTED\r\n\r\nSQL&gt; alter database flashback on;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database open read only;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database recover managed standby database disconnect from session parallel 2;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; select open_mode from v$database;\r\n\r\nOPEN_MODE\r\n--------------------\r\nREAD ONLY WITH APPLY\r\n<\/pre>\n<p>alert\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nThu Oct 16 10:01:40 2014\r\nDrop guaranteed restore point RESTORE_POINT_TEST\r\nStopping background process RVWR\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_9zx7369p_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_9zx9o5t7_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_9zyfjqh1_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b011w9p0_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b03pqqmd_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b06mkzpj_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_9zsfph8w_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_9zvs878h_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b097yjf1_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b0cwbpxt_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b0jwdp2q_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b0oc5tv6_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b0ybykqg_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b15z8ofj_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b1xll14q_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b1xll2f8_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b1xlmq41_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b22d11j4_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b25wkz7q_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b2htvobf_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b2tvdwdf_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b3bjxlm5_.flb\r\nDeleted Oracle managed file \/oradata\/xxxxxs2\/xxxxxs2\/flashback\/o1_mf_b3lhsznd_.flb\r\nGuaranteed restore point RESTORE_POINT_TEST dropped\r\nThu Oct 16 10:02:17 2014\r\nalter database recover managed standby database disconnect from session\r\nAttempt to start background Managed Standby Recovery process (xxxxxs2)\r\nThu Oct 16 10:02:17 2014\r\nMRP0 started with pid=26, OS id=15549 \r\nMRP0: Background Managed Standby Recovery process started (xxxxxs2)\r\n started logmerger process\r\nThu Oct 16 10:02:22 2014\r\nManaged Standby Recovery not using Real Time Apply\r\nParallel Media Recovery started with 40 slaves\r\nWaiting for all non-current ORLs to be archived...\r\nAll non-current ORLs have been archived.\r\nMedia Recovery Log \/oradata\/archivelog\/1_2047_788703924.dbf\r\nMedia Recovery Log \/oradata\/archivelog\/2_2328_788703924.dbf\r\nCompleted: alter database recover managed standby database disconnect from session\r\nMedia Recovery Log \/oradata\/archivelog\/2_2329_788703924.dbf\r\nMedia Recovery Log \/oradata\/archivelog\/1_2048_788703924.dbf\r\nMedia Recovery Log \/oradata\/archivelog\/2_2330_788703924.dbf\r\nThu Oct 16 10:02:37 2014\r\nMedia Recovery Log \/oradata\/xxxxxs2\/xxxxxs2\/archivelog\/2014_10_16\/o1_mf_1_2049_b3y859yy_.arc\r\nMedia Recovery Log \/oradata\/archivelog\/2_2331_788703924.dbf\r\nMedia Recovery Log \/oradata\/archivelog\/2_2332_788703924.dbf\r\nMedia Recovery Log \/oradata\/archivelog\/1_2050_788703924.dbf\r\nMedia Recovery Log \/oradata\/xxxxxs2\/xxxxxs2\/archivelog\/2014_10_16\/o1_mf_2_2333_b3y924g8_.arc\r\nMedia Recovery Log \/oradata\/xxxxxs2\/xxxxxs2\/archivelog\/2014_10_16\/o1_mf_1_2051_b3y921rj_.arc\r\nMedia Recovery Log \/oradata\/archivelog\/1_2052_788703924.dbf\r\nThu Oct 16 10:02:47 2014\r\nMedia Recovery Log \/oradata\/archivelog\/2_2334_788703924.dbf\r\nMedia Recovery Waiting for thread 1 sequence 2053 (in transit)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8bb0\u5f55\u4e00\u6b21ORA-38760_DG\u65e0\u6cd5\u542f\u52a8MRP\u8fdb\u7a0b \u73b0\u8c61\u662f\u76d1\u63a7\u62a5\u8b66\u79f0\u4e3b\u5907\u5e93\u65e5\u5fd7\u5e94\u7528\u4e0d\u540c\u6b65\uff0c\u767b\u5230\u5907\u5e93\u67e5\u770bmrp\u8fdb [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[36],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1348"}],"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=1348"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1348\/revisions"}],"predecessor-version":[{"id":1350,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1348\/revisions\/1350"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1348"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}