RMAN-06820 ORA-17629 During Backup at Standby Site

妖狐艹你老母 2022-08-10 13:49 13阅读 0赞

<table> 
 <tbody> 
  <tr> 
   <td><img src="/images/20220810/979030736fd94f19b6c3a8e76e9f96b3.png" alt="" width="10" height="10"></td> 
   <td align="left"><span style="font-size:14px; text-align:right; padding:0px 6px 0px 0px; font-weight:bold">RMAN-06820 ORA-17629 During Backup at Standby Site (文档 ID 1616074.1)</span></td> 
   <td align="right">&nbsp;</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

![t.gif][]

<table style="table-layout:fixed; overflow:hidden"> 
 <tbody> 
  <tr> 
   <td style="overflow:hidden"><span style="font-size:12px"></span> <p><strong>In this Document</strong><br> </p> 
    <table> 
     <tbody> 
      <tr> 
       <td></td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=jxiafxhpt_4&amp;_afrLoop=509761882432232#SYMPTOM" rel="nofollow">Symptoms</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <table> 
     <tbody> 
      <tr> 
       <td>&nbsp;</td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=jxiafxhpt_4&amp;_afrLoop=509761882432232#CHANGE" rel="nofollow">Changes</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <table> 
     <tbody> 
      <tr> 
       <td>&nbsp;</td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=jxiafxhpt_4&amp;_afrLoop=509761882432232#CAUSE" rel="nofollow">Cause</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <table> 
     <tbody> 
      <tr> 
       <td>&nbsp;</td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=jxiafxhpt_4&amp;_afrLoop=509761882432232#FIX" rel="nofollow">Solution</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <table> 
     <tbody> 
      <tr> 
       <td>&nbsp;</td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=jxiafxhpt_4&amp;_afrLoop=509761882432232#REF" rel="nofollow">References</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <hr> <p><br> </p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> APPLIES TO:</h2> Oracle Database - Enterprise Edition - Version 11.2.0.4 and later<br> Information in this document applies to any platform.<br> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>SYMPTOMS</h2> <p>RMAN archivelog backup at the standby site is throws the following errors at the start of the job:</p> 
    <div style="overflow:auto; border:1px solid rgb(196,209,230); padding:0.5em; margin:5px 0px 0px; font-family:'Courier New',Courier,monospace; font-size:12px; background-color:rgb(224,234,241)"> 
     <br> 
     <span style="font-size:10px">Starting backup at 15-JAN-2014 13:44:46</span> 
     <br> 
     <span style="font-size:10px">RMAN-06820: WARNING: failed to archive current log at primary database</span> 
     <br> 
     <span style="font-size:10px">ORACLE error from target database:</span> 
     <br> 
     <span style="font-size:10px">ORA-17629: Cannot connect to the remote database server</span> 
     <br> 
     <span style="font-size:10px">ORA-17627: ORA-01017: invalid username/password; logon denied&nbsp;</span> 
     <br> 
     <span style="font-size:10px">ORA-17629: Cannot connect to the remote database server</span> 
    </div> <p>&nbsp;</p> <p>But the rest of the backup actually complete successfully:</p> <p>&nbsp;</p> 
    <div style="overflow:auto; border:1px solid rgb(196,209,230); padding:0.5em; margin:5px 0px 0px; font-family:'Courier New',Courier,monospace; font-size:12px; background-color:rgb(224,234,241)"> 
     <span style="font-size:10px">skipping archived log of thread 1 with sequence 607; already backed up</span> 
     <br> 
     <span style="font-size:10px">skipping archived log of thread 1 with sequence 614; already backed up</span> 
     <br> 
     <span style="font-size:10px">channel t1: starting archived log backup set</span> 
     <br> 
     <span style="font-size:10px">channel t1: specifying archived log(s) in backup set</span> 
     <br> 
     <span style="font-size:10px">input archived log thread=1 sequence=678 RECID=290 STAMP=836919086</span> 
     <br> 
     <span style="font-size:10px">input archived log thread=1 sequence=679 RECID=291 STAMP=836919369</span> 
     <br> 
     <span style="font-size:10px">input archived log thread=1 sequence=680 RECID=292 STAMP=836919706</span> 
     <br> 
     <span style="font-size:10px">input archived log thread=1 sequence=681 RECID=293 STAMP=836919873</span> 
     <br> 
     <span style="font-size:10px">channel t1: starting piece 1 at 15-JAN-2014 13:44:52</span> 
     <br> 
     <span style="font-size:10px">channel t1: finished piece 1 at 15-JAN-2014 13:46:17</span> 
     <br> 
     <span style="font-size:10px">piece handle=LOG_THMDB_20140115_171228_1_1 tag=LOG_TWMDB comment=API Version 2.0,MMS Version 5.4.1.0</span> 
     <br> 
     <span style="font-size:10px">channel t1: backup set complete, elapsed time: 00:01:25</span> 
     <br> 
     <span style="font-size:10px">Finished backup at 15-JAN-2014 13:46:17</span> 
    </div> <p>&nbsp;</p> <p>&nbsp;</p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>CHANGES</h2> <p>&nbsp;Database was upgraded to 11.2.0.4</p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>CAUSE</h2> <p>Per 'unpublished' Bug 8740124, as of 11.2.0.4, we now include the current standby redo log as part of an RMAN archivelog backup at the standby site. This is achieved by forcing a log switch at the primary site.<br> <br> However, the connection to the primary failed when attempting to do so.</p> <p><br> This is due to this bug:<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="https://support.oracle.com/epmos/faces/BugDisplay?id=17580082" rel="nofollow">Bug 17580082</a>&nbsp;- ACTIVE STANDBY - RMAN-06820: WARNING: FAILED TO ARCHIVE CURRENT LOG AT PRIMARY<br> &nbsp;</p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>SOLUTION</h2> <p><span style="text-decoration:underline"><strong>Workaround</strong></span></p> <p>Do not use operating system authentication to login with RMAN. Use a username and password.<br> <br> That is, do not use just the "/" (operating system authentication) connect to the standby database:</p> 
    <div style="overflow:auto; border:1px solid rgb(196,209,230); padding:0.5em; margin:5px 0px 0px; font-family:'Courier New',Courier,monospace; font-size:12px; background-color:rgb(224,234,241)">
      $ rman target / 
    </div> <p><br> Instead put in the username and password for the SYSDBA user:</p> 
    <div style="overflow:auto; border:1px solid rgb(196,209,230); padding:0.5em; margin:5px 0px 0px; font-family:'Courier New',Courier,monospace; font-size:12px; background-color:rgb(224,234,241)"> 
     <br> $ rman sys/password 
    </div> <p>&nbsp;</p> <p></p> <p>&nbsp;</p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>REFERENCES</h2> <a href="https://support.oracle.com/epmos/faces/BugDisplay?id=17580082" rel="nofollow">BUG:17580082</a>&nbsp;- ACTIVE STANDBY - RMAN-06820: WARNING: FAILED TO ARCHIVE CURRENT LOG AT PRIMARY<br> <br> <a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=8740124.8" rel="nofollow">NOTE:8740124.8</a>&nbsp;- Bug 8740124 - Current standby redo log group should be included in the database backup by RMAN<br> <a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1301769.1" rel="nofollow">NOTE:1301769.1</a>&nbsp;- ORA-17629 : RMAN Resync Catalog from db_unique_name all fails</td> 
  </tr> 
 </tbody> 
</table>

[t.gif]: /images/20220810/979030736fd94f19b6c3a8e76e9f96b3.png