Backup Exec failed to take RAC DB backup

Rajdeep_Singh · ‎07-27-2010

Hi,

I have configured Backup exec server at windows XP to take RMAN backup of RAC database, existed at linux(OEL 5) system.while I tried to execute backup job getting following error.

	Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jul 27 10:35:15 2010

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

 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=192.168.50.127,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={A55871A8-4D3D-4F94-AE07-919E9562EC6F},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\ctdevrac-01-node-01.clear-trail.com\live01';
 BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP;
 BACKUP CURRENT CONTROLFILE 
     FORMAT 'BE_U';
 
 RELEASE CHANNEL ch0;
 }
 
connected to target database (not started)

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 07/27/2010 10:35:15
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

Recovery Manager complete.

Following are links used to configured Backup exec server and Remote Agent.

http://support.veritas.com/docs/310332
http://support.veritas.com/docs/303003
http://support.veritas.com/docs/279329

Thanks in advance to give any idea to ractify the issue.

Regards,
Rajdeep

RahulG · ‎07-28-2010

Check if the Backup exec version which you are running is compatibile with the Linux version ...

RahulG · ‎07-28-2010

try using sys account for oracle backups, as we are getting the following error :
" could not obtain a fully authorized session "

Rajdeep_Singh · ‎07-28-2010

Hi,

I m using Backup Exec 12.5 version for media server and remote agenet. Even I have succesfully taken backup of oracle single instance DB with same Backup exec version. But incase of RAC only facing this issue.

sys user details i had configured during execution of ./AgentConfig script.

I have run RMAN script manaully on remote agent Linux server, now it has genrated following error.

$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jul 28 08:45:51 2010

connected to target database: LIVE01 (DBID=94182707)

RMAN> RUN {
ALLOCATE CHANNEL ch0
    TYPE 'SBT_TAPE';
BACKUP
    INCREMENTAL LEVEL=0
    FORMAT 'BE_%U'
    DATABASE FORCE;
BACKUP CURRENT CONTROLFILE
    FORMAT 'BE_%U';

RELEASE CHANNEL ch0;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch0 channel at 07/28/2010 08:46:55
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27023: skgfqsbi: media manager protocol error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001003) The job failed because Backup Exec could not find the required information in the Remote Agent Utility. Run the Remote Agent Utility and check that the appropriate information has been entered.

Thanks.............

Rajdeep

RahulG · ‎07-28-2010

Its an issue with the remore agent configuration .. reconfiguring the agent would resolve the issue .

RahulG · ‎07-28-2010

refer http://support.veritas.com/docs/310324
follow the steps below
1. Uninstall RALUS agent
2. Install RALUS again using root
3. While you are logged into system as root , configure the AGENT CONFIG
4. For database access use account called ORACLE ( software owner) and computer name would be
RAC-SIDname-DBID combination.
5 For instance configuration , use the account that SYSDBA
6. Ensure the account oracle is specified in the modify list with RAC-SIDname-DBID.
Then perform the backup with debug enabled.

Rajdeep_Singh · ‎07-29-2010

Hi Rahul,

I have applied all suggested step but still problem persist.

Following is RAC configuration

Database- live01
Instance name -live011,live012

Media server: 192.168.50.127

As per our above discussion my "database access" configution detail is given below. pls check & confirm.

     Entry 1
          ObjectName: DBAID
          Port: 5633
     Entry 2
          ObjectName: Machine
          HostUsername: oracle
          FQDN: RAC-LIVE01-94182707
          Port: 5633

As per support document one statement is given see below.

" The virtual node name appears under the Oracle Real Application Clusters resource in the media server’s backup selections list."

Post configuring I haven't got "virtual node name" under Oracle Real Application Clusters resource in the media server’s.

I feel this would be the issue.

Kindly advice step to reconfiguration steps by which "virtual node name" come under Oracle Real Application Clusters resource in media server.

Thanks
Rajdeep

Thomas_Liebsche · ‎07-29-2010

Hi,

Is Oracle actually running at all?





ORA-01034: ORACLE not available

Means usually that the database is not running at all.

regards,

Thomas

Rajdeep_Singh · ‎07-29-2010

Hi,

It is RAC db having multiple instance while Backup exec tried to take RMAN backup use database name instead of instance name that why oracle not available error is comming.

Pls let me know why it trying to connect DB name instead of instance name.

As per http://support.veritas.com/docs/310324 RAC virtual node name should be visible under icon "Oracle Real Application Clusters resource" in the media server’s.

while i am browsing this icon nothing shown to me.Let me know the solution to make visible "Virtual node name" under "Oracle Real Application Clusters resource" icon in media server.

May be that would be cause RAC backup failing, chosing DBNAME instead of Instane name.

Pls share your input.........

Regards,
Rajdeep

Rajdeep_Singh · ‎07-29-2010

Hi,

Please refer attached debug trace file as per "http://support.veritas.com/docs/318253 " documnet may help to rectify the issue.

Kindly check attached log and put input on the issue..............

Regards,
Rajdeep

VOX

Backup Exec failed to take RAC DB backup