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.


相关文章
|
7月前
|
Oracle 关系型数据库
Oracle 11g和12c的主要区别
Oracle 11g和12c的主要区别
|
Oracle 关系型数据库 5G
Oracle 12C rman备份占用大量临时表空间
Oracle 12C rman备份占用大量临时表空间
387 0
|
11月前
|
Oracle 关系型数据库
oracle 12c新功能 recover table恢复单个表
不支持sys用户和system表空间的表
|
11月前
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库
静默安装Oracle 12c单机环境软件
静默安装Oracle 12c单机环境软件
103 0
|
存储 网络协议 Oracle
Oracle 12c rman duplicate网卡offload引起文件坏块问题
Oracle 12c rman duplicate网卡offload引起文件坏块问题
163 0
|
SQL 存储 Oracle
在Oracle 12c中,在RMAN方面有哪些增强的新特性?
在Oracle 12c中,在RMAN方面有哪些增强的新特性?
147 0
|
Oracle 关系型数据库
Oracle学习笔记之12C中的PDB自启动
Oracle学习笔记之12C中的PDB自启动
|
SQL 监控 Oracle
Oracle 12c之后CDB上创建公共用户无法访问PDB 上v$session表内容
Oracle 12c CDB模式下,创建公共用户,登录到CDB,无法查看PDB下一些表的信息,如v$session,登录到具体PDB才能看到,这篇文章将介绍如何给公共用户授权解决这个问题。
1592 0
|
存储 Oracle 关系型数据库
Oracle学习笔记之Oracle 12C 使用seed创建PDB
Oracle学习笔记之Oracle 12C 使用seed创建PDB
4671 0
Oracle学习笔记之Oracle 12C 使用seed创建PDB

推荐镜像

更多