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>

相关内容

热门资讯

我来教教您“新猴王拼三张到底有... 有 亲,根据资深记者爆料新猴王拼三张是可以开挂的,确实有挂(咨询软件无需...
终于懂了“天天微友辅助器?”(... 您好:天天微友这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
今日重大消息“闽游麻将怎么开挂... 您好:闽游麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
【今日要闻】“宁波游戏大厅有没... 家人们!今天小编来为大家解答宁波游戏大厅透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里...
玩家分享攻略“TT语音到底有挂... 家人们!今天小编来为大家解答TT语音透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里买很...
终于明白“瓦力棋牌真的有挂吗?... 家人们!今天小编来为大家解答瓦力棋牌透视挂怎么安装这个问题咨询软件客服徽9784099的挂在哪里买很...
玩家最新攻略“九酷众娱炸/金/... 玩家最新攻略“九酷众娱炸/金/花辅助器?”(其实是有挂)您好,九酷众娱炸/金/花这个游戏其实有挂的,...
日媒炒作“台湾有事,美军放弃撤... 【环球时报报道 记者 郭媛丹】日本共同社27日报道称,因考虑台湾突发事态,美军修改了原先拟将驻冲绳海...
玩家分享攻略“青鸾牛牛有挂吗?... 玩家分享攻略“青鸾牛牛有挂吗?”(果然有透视挂)您好,青鸾牛牛这个游戏其实有挂的,确实是有挂的,需要...
终于懂了“微乐云南麻将真的有挂... 您好:微乐云南麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9784099】很多玩家在这款...