ORA-03113: end-of-file on communication channel（归档满处理方法）

归档放在flash_recovery目录，由于归档占满了闪回目录，数据库启动报错ORA-03113: end-of-file on communication channel

 

tail -1200f /u01/app/oracle/product/11.2.0/dbhome_1/startup.log

 

Total System Global Area 6747725824 bytes
Fixed Size                  2213976 bytes
Variable Size            4630513576 bytes
Database Buffers         2080374784 bytes
Redo Buffers               34623488 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 19733
Session ID: 1705 Serial number: 5

 

而且lsnrctl status     -------no services

 

 

解决办法(加大闪回区大小)：

sql>shutdowm immediate;

sql>startup mount;

sql>alter system set db_recovery_file_dest_size = 300G scope=both sid='*';                            查看大小：show parameter db_recovery_file_dest_size

sql>shutdowm immediate;

sql>startup;

 

 

 

或者在startup mount;时：

delete noprompt archivelog until time 'sysdate-2';             删除归档，保留2天归档。

 

 

如果有部署OGG，最好备份归档后再删除。

 

 

 

如果直接删除了物理归档文件，控制文件是不知道被你删除了，此时：

用rman登录rman target /
crosscheck archivelog all;                     检查所有归档文件
delete expired archivelog all;                删除过期无效的归档记录

 

 

 

---end---