Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle12.2 ORA-03113

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

1. Database startup error report

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. Check the alarm log

$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.005% 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:

Consider changing RMAN RETENTION POLICY. If you are using Data Guard

Then consider changing RMAN ARCHIVELOG DELETION POLICY.Back up files to tertiary device such as tape using RMAN

BACKUP RECOVERY AREA command.Add disk space and increase db_recovery_file_dest_size parameter to

Reflect the new space.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 archivelog file to'/ u01 * * app *

Krsd_check_stuck_arch: stuck archiver: inactive mandatory LAD:1

Krsd_check_stuck_arch: stuck archiver condition declared

2. Treatment method

Turn off the flashback and do not easily open the flashback area.

$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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report