Server initiated restore of Oracle database fail with an error "ORA-01033: ORACLE initialization or shutdown in progress"

Article:TECH202099  |  Created: 2013-01-27  |  Updated: 2014-10-07  |  Article URL http://www.symantec.com/docs/TECH202099
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



Server initiated restore of Oracle database fail with an error "ORA-01033: ORACLE initialization or shutdown in progress"

The RMAN output will also show the following.

SQL*Plus: Release 11.2.0.x.0 Production on  Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-03113: end-of-file on communication channel
 


Error



ORA-03113: end-of-file on communication channel
ORA-01033: ORACLE initialization or shutdown in progress


Environment



Backup Exec 2012

Oracle 11.2.0.3.0 or 11.2.0.4

RHEL 5.7 or 5.8


Cause



 The issue occurs due to some unknown issue with the Oracle setup and the workaround mentioned below is available. Please contact Oracle Support to further diagnose the issue if the workaround cannot be applied.


Solution



This issue is mainly seen with the Oracle Version 11.2.0.3.0 or 11.2.0.4

Workaround:

The target database needs to manually put in Nomount state before running the restore job from Backup Exec. Please follow the following steps

  1. Connect to RMAN and type the following commands.
  2. Connect target
  3. Shutdown immediate
  4. Startup nomount
  5. SET DBID <Database ID>
  6. Run the restore job from Backup Exec.

Supplemental Materials

SourceETrack
Value3060777
Description

Oracle version (11.2.0.3)server initiated restore is failing while brining the database in nomount state.



Article URL http://www.symantec.com/docs/TECH202099


Terms of use for this information are found in Legal Notices