用rman恢复备库；遇到备库起不来一个案例 ORA-01152:ORA-01110

柔光的暖阳◎ 2022-01-06 04:55 1987阅读 0赞

*  数据从主库恢复到备库；打开备库发现出现异常

<table> 
 <tbody> 
  <tr> 
   <td> <p>SQL&gt; alter database open;</p> <p>alter database open</p> <p>*</p> <p>ERROR at line 1:</p> <p>ORA-10458: standby database requires recovery</p> <p>ORA-01152: file 1 was not restored from a sufficiently old backup</p> <p>ORA-01110: data file 1: '/u01/app/oradata/orcl/system01.dbf'</p> </td> 
  </tr> 
 </tbody> 
</table>

*  查看告警日志 用tail -200 alert\_orcl.log 查看

<table> 
 <tbody> 
  <tr> 
   <td> <p>Standby crash recovery need archive log for thread 1 sequence 27156 to continue.</p> <p>Please verify that primary database is transporting redo logs to the standby database.</p> <p>Wait timeout: thread 1 sequence 27156</p> </td> 
  </tr> 
 </tbody> 
</table>

从告警展示等待超时；就是在主库传归档日志给备库。可以找到原因是出在tnsname.ora；或者是否是参数配置Ok；这两个参数

\*.fal\_client=

\*.fal\_server=

*  自己仔细核对一遍；并tnsping 每个网路服务名。再一次启动

<table> 
 <tbody> 
  <tr> 
   <td> <p>SQL&gt; shutdown immediate;</p> <p>ORA-01109: database not open</p> <p>Database dismounted.</p> <p>ORACLE instance shut down.</p> <p>SQL&gt; create spfile from pfile='/u01/app/oracle/dbs/pfile_orcl.ora';</p> <p>File created.</p> <p>SQL&gt; startup</p> <p>ORACLE instance started.</p> <p>Total System Global Area 1603411968 bytes</p> <p>Fixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2213776 bytes</p> <p>Variable Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1023412336 bytes</p> <p>Database Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 570425344 bytes</p> <p>Redo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7360512 bytes</p> <p>Database mounted.</p> <p>ORA-10458: standby database requires recovery</p> <p>ORA-01152: file 1 was not restored from a sufficiently old backup</p> <p>ORA-01110: data file 1: '/u01/app/oradata/orcl/system01.dbf'</p> </td> 
  </tr> 
 </tbody> 
</table>

还是出现一样的症状。 原因是一样吗？看alert日志吧

<table> 
 <tbody> 
  <tr> 
   <td> <p>Media Recovery Waiting for thread 1 sequence 157</p> <p>ARC3: Archival started</p> <p>ARC0: STARTING ARCH PROCESSES COMPLETE</p> <p>Error 1017 received logging on to the standby</p> <p>------------------------------------------------------------</p> <p>Check that the primary and standby are using a password file</p> <p>and remote_login_passwordfile is set to SHARED or EXCLUSIVE,</p> <p>and that the SYS password is same in the password files.</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; returning error ORA-16191</p> <p>------------------------------------------------------------</p> <p>FAL[client, ARC2]: Error 16191 connecting to orcl_120 for fetching gap sequence</p> <p>Errors in file /u01/app/diag/rdbms/ora11g/orcl/trace/orcl_arc2_25914.trc:</p> <p>ORA-16191: Primary log shipping client not logged on standby</p> </td> 
  </tr> 
 </tbody> 
</table>

日志出现

Check that the primary and standby are using a password file and remote\_login\_passwordfile is set to SHARED or EXCLUSIVE,

and that the SYS password is same in the password files. returning error ORA-16191。

这个应该是跟密码文件有关。

*  在主库重建下密码文件；再传到备库

<table> 
 <tbody> 
  <tr> 
   <td> <p>orapwd file=orapworcl password=oracle entries=10;</p> <p>scp orapworcl <a href="mailto:oracle@ora" rel="nofollow">oracle@ora</a>cle2:/u01/app/oracle/dbs/</p> </td> 
  </tr> 
 </tbody> 
</table>

*  再一次启动；看看还会出现什么问题

<table> 
 <tbody> 
  <tr> 
   <td> <p>SQL&gt; alter database open;</p> <p>Database altered.</p> </td> 
  </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/lottu/p/4902424.html