My Oracle Support Banner

RMAN-04014 Startup Failed ORA03113 (Doc ID 1546836.1)

Last updated on FEBRUARY 12, 2020

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.3 and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Linux on IBM 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 DBtest1 and DBorcl1.

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 DBtest1 was configured to use the 11.2.0.3 ORACLE_HOME /opt/oracle/product/11.2.0/dbhome_2.  All the config files for DBtest1 were copied from dbhome_1 to dbhome_2

DB-Control for DBTEST1 (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 DBORCL1 (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 DBtest1, 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 DBtest1 11203 database completes successfully
- Startup for DBtest1 then completes successfully, and the instance operates normally.


NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem/solution discussed in this note.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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