My Oracle Support Banner

RMAN-04014 Startup Failed ORA03113 (Doc ID 1546836.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.3 and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
IBM: Linux on System z
Checked for relevance on 07-Jan-2016

Symptoms

After upgrading database from 11.2.0.2 to 11.2.03, where all post-upgrade checks have worked, the offline backups through RMAN  fail at database startup


Two 11.2.0.2 instances are on the same server using an ORACLE_HOME of /opt/oracle/product/11.2.0/dbhome_1.
Assume the instances are called jhtest1 and jhorcl1.

There is one 11.2.0.2 listener for both instances/databases runing from the above ORACLE_HOME.

After applying 11.2.0.3 patch, instance jhtest1 was configured to use the 11.2.0.3 ORACLE_HOME /opt/oracle/product/11.2.0/dbhome_2.  All the config files for jhtest1 were copied from dbhome_1 to dbhome_2

DB-Control for JHTEST1 (11.2.0.3) is running ok, although it doesn't monitor the listener as this is still running off dbhome_1.
DB-Control for JHORCL1 (11.2.0.2) is running ok, and it does monitor the listener as this is still running off dbhome_1.

When performing an offline RMAN backup for jhtest1, the following sequence of events occur:

- The database is shutdown successfully by the rman script, but fails on startup.
- The rman log has the RMAN-04014 startup failed ORA-03113 end-of file on communications channel.
- The alert.log has no error messages for startup, the startup has begun but after a few lines there is nothing further in the alert.log.
- Shutdown abort for jhtest1 11203 database completes successfully
- Startup for jhtest1 then completes successfully, and the instance operates normally.



Changes

 An upgrade to 11.2.0.3 has taken place.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.