RMAN-04014 Startup Failed ORA03113 (Doc ID 1546836.1)

Last updated on APRIL 24, 2017

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

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 hundreds of Community platforms