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...
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...