Server initiated offline backup of Oracle database completes successfully but no data is backed up.

book

Article ID: 100014236

calendar_today

Updated On:

Description

Error Message

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

Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Sep 16 10:38:32 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01033: ORACLE initialization or shutdown in progress

.

.

.

.

.

 

using target database control file instead of recovery catalog

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of allocate command at 09/16/2014 10:38:32

RMAN-06171: not connected to target database

EXIT

Recovery Manager complete.

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 mount state before running the offline backup job from Backup Exec.
Connect to the oracle database from sqlplus and run the following commands

shutdown immediate;
startup mount;

Once the backup job is done,the database needs to manually put in open state.
Connect to the oracle database from sqlplus and run the following commands

alter database open;

 

 

Applies To

Backup Exec 2012/2014

Oracle 11.2.0.3.0/11.2.0.4

RHEL 5.7 or 5.8

Issue/Introduction

Server initiated offline backup of Oracle database completes successfully but no data is backed up and RMAN script in the backup job logs gives the error "ORA-01033: ORACLE initialization or shutdown in progress"

Additional Information

ETrack: 3060777