Video Screencast Help

Backup Exec 2012: can not backup Oracle RAC 11G R2

Created: 28 Jan 2013 | 2 comments
joseluis_rios's picture

Hi

     We have a customer with two nodes in Oracle RAC 11G R2. They used to back up their Oracle database with Backup Exec 2010 succesfully. Recently they upgraded to Backup Exec 2012, and got the following error when try to execute a backup job. Hope you can help me with this issue. Thanks.

 

 

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 11 16:03:03 2012

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

 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges

 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=10.208.12.13,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={499554D2-9535-4868-B2DD-C6A47E118BC1},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\sv1pda-nvrac1.dpwc.local\DPWCTNP';
 BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP DELETE INPUT;
 
 RELEASE CHANNEL ch0;
 }
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 12/11/2012 16:03:03
RMAN-06171: not connected to target database

 EXIT

Recovery Manager complete.

Comments 2 CommentsJump to latest comment

swati's picture

Hello,

From the device name in RMAN script, it does not seem to be a RAC setup.
Oracle-Linux::\\sv1pda-nvrac1.dpwc.local\DPWCTNP'

For RAC we have device name such as Oracle-Linux::\\RAC-RACDB-804161001\RACDB where RACDB is the RAC database and 804161001 is DBID. Please confirm about the setup.

Also, at the time of RMAN connection, "ORA-01031: insufficient privileges" error indicates problems in account being used. Please post output of "id root" .

Thanks & Regards.

vjuhola's picture

"ORA-01031: insufficient privileges" indicates that the user you are running backups with has not enough rights. Grant rights, instructed as follows:

sqlplus / as sysdba

grant sysdba to <enter username here>;
grant sysoper to <enter username here>;
grant connect to <enter username here>;
grant select any dictionary to <enter username here>;

 

"RMAN-06171: not connected to target database" says that you are not connected to target database (the database you wish to back up). Connect with catalog if you are using recovery catalog, if you are not using recovery catalog use nocatalog

 

rman target / catalog rman_catalog/catalog_password@catalogdatabase
rman target username/password@target_database nocatalog