How to fix ORA-03113?

How to fix ORA-03113?

The proper fix is to get rid of the recovery files. You do that using RMAN, not SQLPLUS or ADRCI. Wait a long time and your archivelog (that was using up all that space) will be gone. So, you can shutdown/startup your database and be back in business.

What is ORA-03113 error?

ORA-03113: end-of-file on communication channel. Cause: The connection between Client and Server process was broken. It may also happen if the external agent extproc crashes for some reason. Action: There was a communication error that requires further investigation.

How to resolve ORA-03113 end of file on communication channel?

Solution 3:

1. Startup the instance in nomount: SQL> startup nomount.
2. Open database into mount state: alter database mount;
3. Clear the redo log files having issue due to power failure or unclean shutdown of database. SQL> alter database clear unarchived logfile group 1;
4. Shutdown the database and open it.

What is alert log file in Oracle?

The alert log file (also referred to as the ALERT. LOG) is a chronological log of messages and errors written out by an Oracle Database. This file should constantly be monitored to detect unexpected messages and corruptions. Oracle will automatically create a new alert log file whenever the old one is deleted.

Where can I find ora-03113 on my computer?

Oracle was restarted. Going step by step: startup nomount works, alter database mount works, alter database open returns ORA-03113. This is all on localhost – not over the network.

When to start up an Oracle 11g database?

Database opened. SQL> select instance_name from v$instace; select instance_name from v$instace * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 43880 Session ID: 170 Serial number: 5 SQL> Environment: Windows 7 64 bit, Oracle 11g. Here are the details from alerts.log:

How big is an Oracle 11g database buffer?

Total System Global Area 209235968 bytes Fixed Size 1332188 bytes Variable Size 125832228 bytes Database Buffers 75497472 bytes Redo Buffers 6574080 bytes Database mounted. SQL> alter system set db_recovery_file_dest_size=35G scope=both; System altered. SQL> shutdown immediate; ORA-01109: database not open Database dismounted.

How to restore tablespace in Oracle 11g database?

But nevertheless let’s think about, how we can proceed. The best is to open a service request at Oracle Support. One possibility is to restore the undo tablespace. But maybe the error will occur again. Then a point in time restore of the whole database will be an option.