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

book

Article ID: 100028575

calendar_today

Updated On:

Description

Error Message

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

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.

Resolution

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
  6. Run the restore job from Backup Exec.
 

 

Issue/Introduction

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

Additional Information

ETrack: 3060777
Powered by Wolken Software