Backup Exec 2012: can not backup Oracle RAC 11G R2
Created: 28 Jan 2013 | 2 comments
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 Comments • Jump to latest comment
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.
"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
Would you like to reply?
Login or Register to post your comment.