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

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 4907

Session ID: 1 Serial number: 5

The wrong solution

After this error occurs, obviously oracle has been mounted, at this time check oracle status:

select open_mode from v$database;

ERROR:

ORA-03114: not connected to ORACLE

Oracle is not connected to Oracle.

1. Check the alert log first.

$locate alert_orcl.log (my instance name is orcl)

/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log

Alter log error found:

ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 100.00% used, and has 0 remaining bytes available.

************************************************************************

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.

************************************************************************

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4907.trc:

************************************************************************

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 44462592 bytes disk space from 4039114752 limit

*** 2014-08-24 17:04:51.935 4132 krsh.c

ARCH: Error 19809 Creating archive log file to '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2014_08_24/o1_mf_1_117_%u_.arc'

Since the flashback space defined by db_recovery_file_dest_size is all used up, oracle cannot automatically archive!!! And oracle gave four solutions

2. Enter flashback space to see how flashbacks are used.

Directory: /u01/app/oracle/flash_recovery_area/ORCL/archivelog

First, it cannot be deleted at this time. Only the flashback area (FRA) defined by db_recovery_file_dest_size can be enlarged. Moreover, since db now prompts that it cannot be connected to oracle, it is impossible to modify spfile (that is, it is completed through alter system set). Only pfile can be modified. DB can be opened from pfile (pfile is a text file, directly modified, spfile is a binary file, and modification can only be completed through alter system).

3, modify pfile

cd /u01/app/oracle/admin/orcl/pfile/

vi init.ora

Change directly: *.db_recovery_file_dest_size=8039114752

4, and then start the database from pfile

startup pfile='/u01/app/oracle/admin/orcl/pfile/init.ora'

Create spfile from pfile

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.