RMAN-04014 Startup Failed ORA03113
(Doc ID 1546836.1)
Last updated on AUGUST 02, 2024
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.3 and laterOracle 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
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 |