cancel
Showing results for 
Search instead for 
Did you mean: 

i can't restore oracle database.

VDobrokhotov
Level 3

Hello.

We have a few servers with oracle on it. We are going to use backup exec to backup oracle databases. So i decide to make a few experiments. I asked oracle admin to make a test oracle server with database. Server is backuping fine( with archivelogs), but when im trying to restore full database with archivelogs. i get error.

This is backup exec job log:

The Database script returned an error.  Refer to the Database script output section in job logs for more details.

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 23 11:25:55 2015

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 Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Apr 23 11:26:02 2015

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

 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=192.168.100.19,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={EC0C0E7E-CC83-4ECD-9BAA-F8777A1B1AE8},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\Oratest\DBNC';
 
 RESTORE CONTROLFILE FROM 'BE_0eq53lne_1_1';
 
 ALTER DATABASE MOUNT;
 
 RESTORE
     DATABASE;
 
 RECOVER
     DATABASE;
 
 RELEASE CHANNEL ch0;
 alter database open resetlogs;
 }
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 04/23/2015 11:26:02
RMAN-06171: not connected to target database

 EXIT

Recovery Manager complete.

Oracle admin cant tell me what to do, he doesn't know what is mean. So i decide to ask for help at symantec forum. pls help :) 

1 ACCEPTED SOLUTION

Accepted Solutions

VDobrokhotov
Level 3

I resolve the problem. I have read manual and made pre restoring commands on oracle server.  

View solution in original post

1 REPLY 1

VDobrokhotov
Level 3

I resolve the problem. I have read manual and made pre restoring commands on oracle server.