oracle 12C startup时报ora-03113 end-of-file on communication channel

启动数据库的时候出错:

SQL> startup;
ORACLE instance started.

Total System Global Area  771751936 bytes
Fixed Size		    2929160 bytes
Variable Size		  633343480 bytes
Database Buffers	  130023424 bytes
Redo Buffers		    5455872 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 28259
Session ID: 243 Serial number: 50427

在alert log里面有下面的提示:

ORA-19815: WARNING: db_recovery_file_dest_size of 4781506560 bytes is 100.00% used, and has 0 remaining bytes available.
Thu Sep 03 10:45:19 2020
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
Thu Sep 03 10:45:19 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/cdr1/trace/cdr1_arc2_28717.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4781506560 bytes is 100.00% used, and has 0 remaining bytes available.
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
Thu Sep 03 10:45:19 2020
************************************************************************
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
You have following choices to free up space from recovery area:
   reflect the new space.
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
   DELETE EXPIRED commands.
************************************************************************

将数据库启动到mount状态,进入rman删除归档日志。

 RMAN> delete archivelog all;
....
 Deleted 103 objects

再打开数据库

SQL> alter database open;

Database altered.
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页