Oracle12.2 ORA-03113
admin
2023-04-16 16:01:52
0

1、数据库启动报错
SQL> startup
ORACLE instance started.

Total System Global Area 2030043136 bytes
Fixed Size 8794504 bytes
Variable Size 587206264 bytes
Database Buffers 1426063360 bytes
Redo Buffers 7979008 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 1872
Session ID: 1 Serial number: 47660

2、查看告警日志
$tail -100 al*.log
ARCH: STARTING ARCH PROCESSES COMPLETE
2018-10-27T10:35:12.755099+08:00
Errors in file /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_arc0_1874.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 10485760 bytes is 100.00% used, and has 0 remaining bytes available.
2018-10-27T10:35:12.755152+08:00


You have following choices to free up space from recovery area:

  1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
    then consider changing RMAN ARCHIVELOG DELETION POLICY.
  2. Back up files to tertiary device such as tape using RMAN
    BACKUP RECOVERY AREA command.
  3. Add disk space and increase db_recovery_file_dest_size parameter to
    reflect the new space.
  4. Delete unnecessary files using RMAN DELETE command. If an operating
    system command was used to delete files, then use RMAN CROSSCHECK and
    DELETE EXPIRED commands.

    2018-10-27T10:35:12.756113+08:00
    Errors in file /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_arc0_1874.trc:
    ORA-19809: limit exceeded for recovery files
    ORA-19804: cannot reclaim 202974720 bytes disk space from 10485760 bytes limit
    ARC0: Error 19809 Creating archive log file to '/u01/app/oracle/fast_recovery_area/cdb1/CDB1/archivelog/2018_10_27/o1_mf_156%u_.arc'
    krsd_check_stuck_arch: stuck archiver: inactive mandatory LAD:1
    krsd_check_stuck_arch: stuck archiver condition declared

2、处理方法
关闭闪回,不要轻易打开闪回区。
$sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 27 10:44:15 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 2030043136 bytes
Fixed Size 8794504 bytes
Variable Size 587206264 bytes
Database Buffers 1426063360 bytes
Redo Buffers 7979008 bytes
Database mounted.
SQL> show parameter recovery

NAME TYPE VALUE


db_recovery_file_dest string /u01/app/oracle/fast_recovery_area/cdb1
db_recovery_file_dest_size big integer 10M
recovery_parallelism integer 0
remote_recovery_file_dest string

SQL> alter system set db_recovery_file_dest='';

System altered.

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE

READ WRITE

SQL>

相关内容

热门资讯

凤凰连线:中美新一轮经贸磋商,... 中美双方将在韩国举行第七轮经贸磋商。美方的阵容和日程安排如何?在这轮磋商中有哪些关切?凤凰卫视驻韩国...
知情人士:阿联酋秘密打击伊朗,... 据参考消息援引美国《华尔街日报》网站5月11日报道,多名知情人士透露,阿联酋已对伊朗发动军事打击,令...
美防长称美伊停火协议依然有效 △赫格塞思(资料图)当地时间5月12日,美国国防部长赫格塞思表示,他们针对伊朗问题的所有情况都制定了...
特朗普二度来华,五大博弈看点,... 就在5月11日,外交部官宣了一则重磅消息:应中国邀请,美国总统特朗普将于5月13日至15日开启访华行...
科学家预测:“哥斯拉级”厄尔尼... 科学家近日发出警告,太平洋上空正在形成一种被称为“哥斯拉”级的罕见厄尔尼诺气候模式。有科学家预测,这...
200亿美金估值的可灵,值母公... 文 | 影子备忘录 要说今年科技圈最火的赛道,AI短剧绝对排得上号。一部AI仿真人短剧,3人团队、...
多名中国公民在越南乘机遗失财物... 近日,多名中国公民反映在越乘机过程中财物遗失,中国驻胡志明市总领馆提醒中国公民注意:一、强化防范意识...
电视机尺寸一览表70寸长宽 电视机尺寸一览表70寸长宽:一般液晶电视显示屏都是16比9,70寸就是说客它对角线长70寸是106....
东莞一社区推出生育奖励方案,二... 极目新闻记者 柳之萌近日,广东东莞万江街道谷涌社区出台生育奖励方案,对符合条件的二孩家庭一次性奖励1...
80寸液晶电视尺寸长宽多少厘米 80寸液晶电视尺寸长宽多少厘米:80寸的液晶电视大概为181x111厘米,即长度大概在181厘米,宽...