04-23-2015 03:08 AM
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 :)
Solved! Go to Solution.
04-23-2015 05:35 AM
I resolve the problem. I have read manual and made pre restoring commands on oracle server.
04-23-2015 05:35 AM
I resolve the problem. I have read manual and made pre restoring commands on oracle server.