Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rac backup woes...

Status
Not open for further replies.

B14speedfreak

Technical User
Mar 23, 2006
182
Hi all,

I guess this could be quite possibly be a problem with our media server (but then so could any rman question) so thanks in advance for reading and any help.

Anyhow we are running a 5 node RAC which are doing hotbackups on via netbackup 5.1 on a solaris 5.8 box. These have been running fine for quite a while. However today I have a bit of an issue. The backup doesn't work from netbackup and I get the following error stack:


Recovery Manager: Release 9.2.0.6.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
RMAN>
RMAN>
connected to target database (not started)

RMAN>
connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22
> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 07/13/2006 04:47:07
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27103: internal error
Linux Error: 11: Resource temporarily unavailable

RMAN>

Recovery Manager complete.
[root@sunatlsunx008 netbackup]#

However if I kick the backup off manually at the RAC end rather than through netbackup, it starts writing to tape and seems to work fine. I have tried restarting the netbackup deamons but still no luck.

Here is the script that I am running:

DATE=`date +%m%d%Y-%H%M%S`; export DATE
USER=`id | cut -f2 -d"(" | cut -f1 -d")"`
ORACLE_SID=ausl1; export ORACLE_SID
ORACLE_USER=oracle; export ORACLE_USER
ORACLE_HOME=/u01/oracle/product/9.2.0 export ORACLE_HOME

#delete log files older than 35 days
find /var/adm/netbackup -name "auslive*" -mtime +35 -type f -exec rm {} \;

#if [ "${USER}" = "root" ]
#then
# su - ${ORACLE_USER} "cd /rac/DBA/scripts/BACKUP/" #-c "${CMD_STRING}"
# SUCCESS=$?
#else
# eval "/rac/DBA/scripts/BACKUP"
# SUCCESS=$?
#fi

<<EOF su - oracle
<<EOF1 /u01/oracle/product/9.2.0/bin/rman msglog /var/adm/netbackup/AUSLIVE_b
ackup.${DATE} append


connect target /
connect catalog rman/rman@rman
#change archivelog all validate;
run {

allocate channel ch1 type sbt_tape;
allocate channel ch2 type sbt_tape;
#allocate channel ch3 type sbt_tape;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' CONNECT = 'SYS/fowler
@rman_ausl2';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' CONNECT = 'SYS/fowler
@rman_ausl3';
#CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' CONNECT = 'SYS/fowle
r@rman_ausl4';
change archivelog all validate;
send "NB_ORA_CLASS=ORAhot_AUSLIVE";
#send "NB_ORA_CLIENT=sunatlsunx008";
send "NB_ORA_CLIENT=sunatlsunx008";
send "NB_ORA_SCHED=full";
backup
incremental level=0
filesperset 150
format "bk_%s_%p_%t"
tag "hot_${ORACLE_SID}_${DATE}"
database;
sql "alter system archive log current";
backup
filesperset 10
format "ct_%s_%p_%t"
current controlfile;
sql "alter system archive log current";
backup
filesperset 150
format "al_%s_%p_%t"
archivelog all not backed up 2 times;
backup
filesperset 50
format "al_%s_%p_%t"
archivelog until time 'SYSDATE-4' delete input;
release channel ch1;
release channel ch2;
#release channel ch3;
}
exit
EOF1
EOF


Anyone any ideas why my script won't run through netbackup??? We havn't changed anything so am a bit proplexed really. Thanks again in advance for any posts,

THanks again,

B14.. aka... marky mark...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top