{"id":825,"date":"2013-04-24T10:36:31","date_gmt":"2013-04-24T02:36:31","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=825"},"modified":"2013-04-24T15:34:40","modified_gmt":"2013-04-24T07:34:40","slug":"11g%e7%89%a9%e7%90%86%e5%a4%87%e5%ba%93%e9%87%8d%e5%bb%ba%e5%87%ba%e9%94%99rman-04006-rman-00554","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=825","title":{"rendered":"11g\u7269\u7406\u5907\u5e93\u91cd\u5efa\u51fa\u9519RMAN-04006 RMAN-00554"},"content":{"rendered":"<p>\u6574\u4f53\u67b6\u6784\u5982\u4e0b\uff1a<br \/>\n<a href=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/04\/rac_dg1.jpg\" class=\"cboxElement\" rel=\"example_group\"825><img loading=\"lazy\" src=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/04\/rac_dg1-300x149.jpg\" alt=\"rac_dg1\" width=\"300\" height=\"149\" class=\"aligncenter size-medium wp-image-817\" srcset=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/04\/rac_dg1-300x149.jpg 300w, http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/04\/rac_dg1.jpg 1007w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u51c6\u5907\u5728\u4e3b\u5e93\u7684\u8282\u70b91\u8fde\u63a5\u5230\u5907\u5e93\u4f7f\u7528rman\u91cd\u5efa\u7269\u7406\u5907\u5e93\u7684\u65f6\u5019\u62a5\u9519\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@XXX21DBRAC1 dbs]$ rman target \/ auxiliary sys\/oracle@XXXDB_S\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 23 18:22:37 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database: XXXDB (DBID=1566881586)\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-00554: initialization of internal recovery manager package failed\r\nRMAN-04006: error from auxiliary database: ORA-01017: invalid username\/password; logon denied\r\n<\/pre>\n<p>\u6ce8\uff1a\u5728\u5c06\u5907\u5e93\u548c\u4e3b\u5e93\u53e3\u4ee4\u6587\u4ef6\u4e00\u81f4\u5316\u540e\uff0c\u4ee5\u53ca\u5728\u5907\u5e93\u4fee\u6539\u5b8csys\u5bc6\u7801\u540e\u4f9d\u7136\u62a5\u76f8\u540c\u7684\u9519\u8bef<\/p>\n<p><strong>\u89e3\u51b3\u8fc7\u7a0b\uff1a<\/strong><br \/>\n\u67e5\u770b\u5907\u5e93\u544a\u8b66\u65e5\u5fd7\uff0c\u53d1\u73b0\u6709\u4e2a\u6570\u636e\u6587\u4ef6\u6709\u95ee\u9898\uff0c\u4e8e\u662f\u5c06\u8be5\u6570\u636e\u6587\u4ef6\u79bb\u7ebf<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@XXX21DBDG ~]$ sqlplus &quot;\/as sysdba&quot;\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 23 18:22:44 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; alter database mount;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database open;\r\nalter database open\r\n*\r\nERROR at line 1:\r\nORA-10458: standby database requires recovery\r\nORA-01157: cannot identify\/lock data file 8 - see DBWR trace file\r\nORA-01111: name for data file 8 is unknown - rename to correct file\r\nORA-01110: data file 8:\r\n&#039;\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs\/UNNAMED00008&#039;\r\n\r\n\r\nSQL&gt; alter database datafile 8 offline;\r\nalter database datafile 8 offline\r\n*\r\nERROR at line 1:\r\nORA-01668: standby database requires DROP option for offline of data file\r\n\r\n\r\nSQL&gt; alter database datafile 8 offline drop;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; shutdown immedaite;\r\nSP2-0717: illegal SHUTDOWN option\r\nSQL&gt; shutdown immediate;\r\nORA-01109: database not open\r\n\r\n\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; startup nomount;\r\nORACLE instance started.\r\n\r\nTotal System Global Area 1.0689E+10 bytes\r\nFixed Size                  2237776 bytes\r\nVariable Size            5637147312 bytes\r\nDatabase Buffers         5033164800 bytes\r\nRedo Buffers               16924672 bytes\r\n<\/pre>\n<p>\u6ce8\uff1a\u518d\u6b21\u5728\u4e3b\u5e93\u4f7f\u7528rman\u8fde\u63a5\u5230\u5907\u5e93\u91cd\u5efa\u5907\u5e93\u62a5\u76f8\u540c\u9519\u8bef\u3002<\/p>\n<p>\u4e8e\u662f\u4fee\u6539\u5907\u5e93\u76d1\u542c\u6587\u4ef6\uff1a<br \/>\n\u539f\u76d1\u542c\u6587\u4ef6\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSID_LIST_LISTENER =\r\n  (SID_LIST =\r\n    (SID_DESC =\r\n      (GLOBAL_DBNAME = XXXdb_s)\r\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1)\r\n      (SID_NAME = XXXdb)\r\n    )\r\n  )\r\n\r\nLISTENER =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.92)(PORT = 1521))\r\n  )\r\n\r\nADR_BASE_LISTENER = \/u01\/app\/oracle\r\n<\/pre>\n<p>\u4fee\u6539\u540e\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSID_LIST_LISTENER =\r\n  (SID_LIST =\r\n    (SID_DESC =\r\n      (SID_NAME = PLSExtProc)\r\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1)\r\n      (PROGRAM = extproc)\r\n    )\r\n    (SID_DESC =\r\n      (GLOBAL_DBNAME = XXXdb_s)\r\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1)\r\n      (SID_NAME = XXXdb)\r\n    )\r\n  )\r\n\r\nLISTENER =\r\n  (DESCRIPTION_LIST =\r\n    (DESCRIPTION =\r\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.92)(PORT = 1521))\r\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))\r\n    )\r\n  )\r\n\r\nADR_BASE_LISTENER = \/u01\/app\/oracle\r\n\r\n<\/pre>\n<p>\u5728\u5b8c\u6210\u4ee5\u4e0a\u4fee\u6539\u540e\uff0c\u53ef\u4ee5\u6b63\u5e38\u91cd\u5efa\u5907\u5e93\u3002<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@XXX21DBRAC1 ~]$ rman target \/ auxiliary sys\/oracle@XXXDB_S\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 23 18:45:45 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database: XXXDB (DBID=1566881586)\r\nconnected to auxiliary database: XXXDB (not mounted)\r\n\r\nRMAN&gt; duplicate target database for standby;\r\n\r\nStarting Duplicate Db at 23-APR-13\r\nusing target database control file instead of recovery catalog\r\nallXXXted channel: ORA_AUX_DISK_1\r\nchannel ORA_AUX_DISK_1: SID=394 device type=DISK\r\n\r\ncontents of Memory Script:\r\n{\r\n   restore clone standby controlfile;\r\n}\r\nexecuting Memory Script\r\n\r\nStarting restore at 23-APR-13\r\nusing channel ORA_AUX_DISK_1\r\n\r\nchannel ORA_AUX_DISK_1: restoring control file\r\nchannel ORA_AUX_DISK_1: copied control file copy\r\ninput file name=\/tmp\/racdb_st.ctl\r\noutput file name=\/oradata\/XXXdb\/controlfile\/current.261.788703923\r\noutput file name=\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs\/oradata\/XXXdb\/controlfile\/current.260.788703923\r\nFinished restore at 23-APR-13\r\n\r\ncontents of Memory Script:\r\n{\r\n   sql clone &#039;alter database mount standby database&#039;;\r\n}\r\nexecuting Memory Script\r\n\r\nsql statement: alter database mount standby database\r\n... ...\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6574\u4f53\u67b6\u6784\u5982\u4e0b\uff1a \u51c6\u5907\u5728\u4e3b\u5e93\u7684\u8282\u70b91\u8fde\u63a5\u5230\u5907\u5e93\u4f7f\u7528rman\u91cd\u5efa\u7269\u7406\u5907\u5e93\u7684\u65f6\u5019\u62a5\u9519\u5982\u4e0b\uff1a [oracle@XXX2 [&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":[181,180],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/825"}],"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=825"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/825\/revisions"}],"predecessor-version":[{"id":830,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/825\/revisions\/830"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=825"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}