Oracle Error: Ora-03113:end-of-file on communication channel Process

Database mounted.

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

Process id:4907

Session id:1 Serial Number:5

A solution to this error

After this error occurs, Oracle is already mount, and the status of Oracle is now viewed:

Select Open_mode from V$database;

ERROR:

Ora-03114:not connected to ORACLE

Tip Oracle is not connected to Oracle at all

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

Found an error in the Alter LOG:

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

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

You have the following choices to free up space from the 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 the 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 '

because The db_recovery_file_dest_size definition of the flashback space has been exhausted, resulting in the inability of Oracle to automatically archive!!! And Oracle gives the four-solution recommendations

2, go to flash back space to see how the flashback is used.

Catalog:/u01/app/oracle/flash_recovery_area/orcl/archivelog

It is not possible to delete this at this time, only the flash back region (FRA) defined by Db_recovery_file_dest_size can be increased, and since DB is now prompted to connect to Oracle, It is not possible to modify SPFile (that is, by alter system set), only modify Pfile, open db from Pfile (Pfile is a text file, modify directly, SPFile is a binary file, only via alter system To complete the modification)

3, modify Pfile

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

VI Init.ora

Direct change: *.db_recovery_file_dest_size=8039114752

4, then start the database from Pfile

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

The new generation of SPFile with Pfile

Oracle Error: Ora-03113:end-of-file on communication channel Process