{"id":874,"date":"2013-05-21T01:29:36","date_gmt":"2013-05-20T17:29:36","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=874"},"modified":"2013-05-21T01:38:34","modified_gmt":"2013-05-20T17:38:34","slug":"%e7%bb%86%e8%8a%82%e6%88%90%e5%b0%b1%e6%88%90%e8%b4%a5-%e6%9d%83%e9%99%90%e4%b9%8bora-19587-ora-27091","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=874","title":{"rendered":"\u7ec6\u8282\u6210\u5c31\u6210\u8d25-\u6743\u9650\u4e4bORA-19587 ORA-27091"},"content":{"rendered":"<p>\u4e0d\u591a\u8bf4\u4e86\uff0c\u665a\u4e0a\u52a0\u73ed\u5728\u5355\u8282\u70b9\u7684\u5907\u5e93\u642d\u5efa\u7269\u7406DG\uff0c\u6709\u70b9\u7740\u6025\u56de\u5bbf\u820d\uff0c\u4e00\u65f6\u534a\u4f1a\u513f\u5fd8\u4e86\u628aroot put\u8fc7\u53bb\u7684\u63a7\u5236\u6587\u4ef6\u6ca1\u6709\u4fee\u6539\u6743\u9650\uff0c\u590d\u5236\u5e93\u7684\u65f6\u5019\u51fa\u9519\u3002\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@xxx:\/opt\/oracle]$ rman target \/ auxiliary sys\/system@xxx\r\n\r\nRecovery Manager: Release 9.2.0.4.0 - 64bit Production\r\n\r\nCopyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.\r\n\r\nconnected to target database: XXXXCDB (DBID=69648XXXX)\r\nconnected to auxiliary database: cakmcdb (not mounted)\r\n\r\nRMAN&gt; duplicate target database for standby nofilenamecheck;\r\n\r\nStarting Duplicate Db at 20-MAY-13\r\nusing target database controlfile instead of recovery catalog\r\nallocated channel: ORA_AUX_DISK_1\r\nchannel ORA_AUX_DISK_1: sid=8 devtype=DISK\r\n\r\nprinting stored script: Memory Script\r\n{\r\n   restore clone standby controlfile to clone_cf;\r\n   replicate clone controlfile from clone_cf;\r\n   sql clone &#039;alter database mount standby database&#039;;\r\n}\r\nexecuting script: Memory Script\r\n\r\nStarting restore at 20-MAY-13\r\n\r\nusing channel ORA_AUX_DISK_1\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of Duplicate Db command at 05\/20\/2013 21:57:12\r\nRMAN-03015: error occurred in stored script Memory Script\r\nORA-19587: error occurred reading 8192 bytes at block number 1\r\nORA-27091: skgfqio: unable to queue I\/O\r\nORA-27069: skgfdisp: attempt to do I\/O beyond the range of the file\r\nAdditional information: 1\r\nAdditional information: 1\r\n<\/pre>\n<p>\u6b64\u5904\u9700\u8981\u4fee\u6539\u7ed9\u5907\u5e93\u521b\u5efa\u7684\u63a7\u5236\u6587\u4ef6\u7684\u6743\u9650<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n# ls -l ctl_racdb_st.bak\r\n-rw-r--r--   1 root     other    2023424  5\u6708 20 22:00 ctl_racdb_st.bak\r\n# chown oracle:dba ctl_racdb_st.bak\r\n# ls -l ctl_racdb_st.bak\r\n-rw-r--r--   1 oracle   dba      2023424  5\u6708 20 22:00 ctl_racdb_st.bak\r\n<\/pre>\n<p>\u6ce8\u610f\uff1a<br \/>\n1\u3001\u57289i\u4e2d\u4f7f\u7528\u547d\u4ee4duplicate\u590d\u5236\u5e93\uff0c\u5982\u679c\u4e3b\u5907\u5e93\u7684\u6587\u4ef6\u8def\u5f84\u4e00\u6837\uff0c\u5219\u9700\u8981\u52a0\u53c2\u6570nofilenamecheck\uff0c\u5426\u5219\u62a5\u9519<br \/>\n2\u3001\u5728\u521b\u5efa\u5907\u5e93\u63a7\u5236\u6587\u4ef6\u53ca\u5907\u4efd\u4e3b\u5e93\u7684\u524d\u540e\uff0c\u9700\u8981\u6267\u884c alter system archive log current; \u4ea7\u751f\u65b0\u7684\u68c0\u67e5\u70b9\uff0c\u5426\u5219\u5728\u590d\u5236\u7684\u65f6\u5019\u53ef\u80fd\u4f1a\u62a5\u5907\u4efd\u7684scn\u65b0\u4e8e\u5f53\u524d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0d\u591a\u8bf4\u4e86\uff0c\u665a\u4e0a\u52a0\u73ed\u5728\u5355\u8282\u70b9\u7684\u5907\u5e93\u642d\u5efa\u7269\u7406DG\uff0c\u6709\u70b9\u7740\u6025\u56de\u5bbf\u820d\uff0c\u4e00\u65f6\u534a\u4f1a\u513f\u5fd8\u4e86\u628aroot put\u8fc7\u53bb\u7684\u63a7\u5236\u6587\u4ef6\u6ca1 [&hellip;]<\/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":[201,199,200],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/874"}],"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=874"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/874\/revisions"}],"predecessor-version":[{"id":879,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/874\/revisions\/879"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}