PROSAGA码农传奇-量子传输-Oracle 11g XE - 突然ORA-01034：ORACLE不可用且ORA-27101：共享内存域不存在

Oracle 11g XE - 突然ORA-01034：ORACLE不可用且ORA-27101：共享内存域不存在

作者: 满目山河
发布时间: 2024-04-11 06:58:35 (12天前)
转自：

<div class =“post-text”itemprop =“text”>
  <P>
    根据您的警报日志，您的DB_RECOVERY_FILE_DEST_SIZE已超出：
  </p>
   <pre>
    <code>
      19809, 00000, "limit exceeded for recovery files"
//*Cause: The limit for recovery files specified by the
//        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
// *Action: There are five possible solutions:
//          1) Take frequent backup of recovery area using RMAN.
//          2) Consider changing RMAN retention policy.
//          3) Consider changing RMAN archived log deletion policy.
//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          5) Delete files from recovery area using RMAN.

</code>
  </pre>
  <P>
    因此，您需要在initfile或spfile中增加数据库参数DB_RECOVERY_FILE_DEST_SIZE，然后启动数据库并删除所有存档日志：
  </p>
   <pre>
    <code>
      rman target /
delete archivelog all;

</code>
  </pre>
  <P>
    您还可以删除所有存档日志（如果您不需要它们），因为您的数据库可以成功安装：
  </p>
   <pre>
    <code>
      sqlplus / as sysdba
shutdown abort
startup mount
exit

rman target /
delete archivelog all
exit

sqlplus /as sysdba
alter database open;

</code>
  </pre>
  <P>
    之后，我建议您在数据库中禁用archivelog模式，以避免将来出现同样的情况。我相信你不接受热备份：
  </p>
   <pre>
    <code>
      sqlplus / as sysdba
shutdown immediate
startup mount
alter database noarchivelog;
alter database open;

</code>
  </pre>
</DIV>