Forum Discussion

AlexMiclat's avatar
AlexMiclat
Level 1
10 years ago

Symantec Backup Exec 2014 Oracle Database its restore only control file not DB

RMAN Output
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 19 17:22:41 2015

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 Connected.
 ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 7700742144 bytes
Fixed Size    2089568 bytes
Variable Size 1241517472 bytes
Database Buffers 6442450944 bytes
Redo Buffers   14684160 bytes
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Recovery Manager: Release 10.2.0.5.0 - Production on Wed Aug 19 17:22:54 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 
connected to target database: opera (not mounted)

 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=XX.XXX.XXX.XX,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={AD80CB5F-8A49-47EA-A8F5-F9AE1B82E0D5},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\KIDXB-OPTRN.kempmoe.dxb\production,NBBSA_SOURCE_MACHINE_NAME=RAC-production-2347436078';
 
 RESTORE CONTROLFILE FROM 'BE_c-2347436078-20150818-00';
 
 RELEASE CHANNEL ch0;
 alter database mount;
 }
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=553 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 19-AUG-15

channel ch0: restoring control file
channel ch0: restore complete, elapsed time: 00:00:15
output filename=D:\ORACLE\ORADATA\OPERA\CONTROL01.CTL
output filename=C:\ORACLE\ORADATA\OPERA\CONTROL02.CTL
Finished restore at 19-AUG-15

released channel: ch0

database mounted

 EXIT

Recovery Manager complete.

Recovery Manager: Release 10.2.0.5.0 - Production on Wed Aug 19 17:25:03 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 
connected to target database: OPERA (DBID=2347436078, not open)

 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=XX.XXX.XXX.XX,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={AD80CB5F-8A49-47EA-A8F5-F9AE1B82E0D5},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\KIDXB-OPTRN.kempmoe.dxb\production,NBBSA_SOURCE_MACHINE_NAME=RAC-production-2347436078';
 }
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=551 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0
released channel: ch0

 EXIT

Recovery Manager complete.