ORA-03113 end-of-file 问题解决方法

 ORA-03113:end-of-file on communication channel

 兰德马克数据库启动不了，
cd /pb/lmoracle/product/diag/rdbms/owlmk/OWLMK/trace
vi alert_OWLMK.log

Errors in file/pb/lmoracle/product/diag/rdbms/owlmk/OWLMK/trace/OWLMK_ora_4938.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 38654705664 bytesis 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recoveryarea:
1. Consider changing RMAN RETENTION POLICY. If you are using DataGuard,
   then consider changing RMANARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREAcommand.
3. Add disk space and increase db_recovery_file_dest_size parameterto
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If anoperating
   system command was used todelete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************

显示 db_recovery_file_dest_size36个G已经满了

数据库启动不了，rman target/  不行
先用root到/pb/oracle_recovery/OWLMK/archivelog删除几个最老的目录。
然后
sqlplus "/as sysdba"
startup;
仍然启动不了。
startup mount;
能启动

另外打开一个窗口：
su - lmoracle
rman target /
crosscheck archivelog all;
delete expired archivelog all;
delete noprompt archivelog until time "sysdate -3";

在sqlplus中执行
shutdown;
退出重新进入 sqlplus "/as sysdba"
startup;
正常启动

show parametersdb_recovery_file_dest_size;

NAME                TYPE        VALUE
------------------------------------ -----------------------------------------
db_recovery_file_dest_size          big integer 36G
alter system set db_recovery_file_dest_size=80Gscope=both;

显示flash_recovery_area用量：
select * from v$flash_recovery_area_usage;
select * from v$recovery_file_dest;

欢迎转载和交流，有问题可联系 QQ： 83555727 或Email 83555727@qq.com