免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2295 | 回复: 0

[Veritas NBU] 请教NBU备份AIX下的Sybase15.7报错问题 [复制链接]

论坛徽章:
0
发表于 2014-08-10 00:26 |显示全部楼层
本帖最后由 rebelllz 于 2014-08-10 22:40 编辑

环境是AIX 7100-02,Sybase15.7,NBU装的是7.6.0.3,在单独一台windows上,各机器解析都相互PING过,都没问题,两台小机是做HACMP,要备份Sybase,用dump database SKP to "sybackup::"测试都不能成功,搜了很久没找到解决方法,请教是哪里出错呢
1> dump database SKP to "sybackup::"
2> go
Backup Server: 4.171.1.1: The current value of 'reserved pages threshold' is
85%.
Backup Server: 4.171.1.2: The current value of 'allocated pages threshold' is
40%.
Backup Server: 4.171.1.5: The current value of 'parallel scan' is 2.
Backup Server session id is: 74. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Msg 3240, Level 18, State 2:
Server 'SKP', Line 1:
Unable to obtain the ASE's current working directory. The ASE must have search
permission on its current working directory and the name must be shorter than
255 bytes.
Msg 3240, Level 18, State 1:
Server 'SKP', Line 1:
Unable to obtain the ASE's current working directory. The ASE must have search
permission on its current working directory and the name must be shorter than
255 bytes.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'sybackup::::000'
Backup Server: 4.124.2.1: Archive API error for device='sybackup::::000': Vendor
application name='Veritas NetBackup for SYBASE, Library version=760000, API
routine=syb_open(), Message= Backup failed - syb_open: ERR - BSACreateObject()
failed with error - System detected error, operation aborted.. Please refer to
sybackup log for more info.
Msg 8009, Level 16, State 1:
Server 'SKP', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

备份脚本
!/bin/sh
# sybase_mydb_backup $Revision: 1.3 $
#bcpyrght
#***************************************************************************
#* $VRTScprght: Copyright 2014 Symantec Corporation, All Rights Reserved SY39-6648-5573-26-15-5  $ *
#***************************************************************************
#ecpyrght

#***************************************************************************
# Replace /usr/sybase12 below with the actual Sybase home directory
#***************************************************************************
SYBASE=/sybase/SKP

#***************************************************************************
# Replace SYBASE12 below with the actual name of the SQL Server
#***************************************************************************
SYBSERVER=sapdbs

#***************************************************************************
# Replace SYB_DB below with the actual name of your Sybase database
#***************************************************************************
DATABASE_NAME=SKP

#***************************************************************************
# Replace syb_files below with your actual name of the NetBackup
# server Policy to be used to backup the directory with Sybase script files
#***************************************************************************
#SYB_FILES_POLICY=syb_files

#***************************************************************************
# Replace /usr/sybase12/scripts below with your actual path of the Sybase files
#***************************************************************************
#SYB_FILES_DIR=/usr/sybase12/scripts

#***************************************************************************
# Determine the SYBASE_ASE and SYBASE_OCS env variables for Sybase 12.x
#***************************************************************************
OCS_QUAL=
if [ -f "${SYBASE}"/SYBASE.csh ] ; then
        SYBASE_ASE=`grep "setenv SYBASE_ASE" "${SYBASE}"/SYBASE.csh | cut -f3 -d" " | sort -u | head -1`
        SYBASE_OCS=`grep "setenv SYBASE_OCS" "${SYBASE}"/SYBASE.csh | cut -f3 -d" " | sort -u | head -1`
        export SYBASE_ASE
        export SYBASE_OCS
        OCS_QUAL=/$SYBASE_OCS
elif [ -f "${SYBASE}"/SYBASE.sh ] ; then
        SYBASE_ASE=`grep "SYBASE_ASE=" "${SYBASE}"/SYBASE.sh | cut -f2 -d"=" | sort -u | head -1`
        SYBASE_OCS=`grep "SYBASE_OCS=" "${SYBASE}"/SYBASE.sh | cut -f2 -d"=" | sort -u | head -1`
        export SYBASE_ASE
        export SYBASE_OCS
        OCS_QUAL=/$SYBASE_OCS
fi

echo "Started `date`"
SYBASE=$SYBASE; export SYBASE
# These environment variables are set by NetBackup
echo "SYBACKUP_SERVER = $SYBACKUP_SERVER"
echo "SYBACKUP_POLICY = $SYBACKUP_POLICY"
echo "SYBACKUP_SCHED = $SYBACKUP_SCHED"
echo "SYBACKUP_CLIENT = $SYBACKUP_CLIENT"
echo "SYBACKUP_SCHEDULED = $SYBACKUP_SCHEDULED"
echo "SYBACKUP_USER_INITIATED = $SYBACKUP_USER_INITIATED"

RETURN_STATUS=0

#***************************************************************************
# Replace "database_dump" below with your actual NetBackup schedule name
# which is used for a full backup of the Sybase database.
#***************************************************************************
if [ "${SYBACKUP_SCHED}" = "sapprd" ]
then
############# NetBackup has started a "database_dump" backup ##############
DUMP_TYPE=DATABASE

else
############# NetBackup has started a "transaction log" backup ##############
DUMP_TYPE=TRANSACTION
fi

#***************************************************************************
# Replace "Default-Application-Backup" below with your actual NetBackup
# Application Backup type schedule name for the Sybase database.
#***************************************************************************
        echo dump $DUMP_TYPE $DATABASE_NAME to \"sybackup::-SERV $SYBACKUP_SERVER -CLIENT $SYBACKUP_CLIENT -POL $SYBACKUP_POLICY -SCHED Default-Application-Backup\" > ./syb_${DATABASE_NAME}_dump

#**************************************************************************
# Remove the '#' from the beginning of the line below if you are going to
# use multiple stripes for the backup. Repeat this line for each stripe.
# Replace "Default-Application-Backup" below with your actual NetBackup
# Application Backup type schedule name for the Sybase database.
# **************************************************************************
# echo stripe on \"sybackup::-SERV $SYBACKUP_SERVER -CLIENT $SYBACKUP_CLIENT -POL $SYBACKUP_POLICY -SCHED Default-Application-Backup\" >> ./syb_${DATABASE_NAME}_dump

echo go >> ./syb_${DATABASE_NAME}_dump

#***************************************************************************
# Log the isql command. This line may appear in NetBackup log files.
# Do NOT replace "xxxxxxxx" with a user id or password.
#***************************************************************************
        echo "$SYBASE$OCS_QUAL/bin/isql -Uxxxxxxxx -Pxxxxxxxx -I$SYBASE/interfaces -S$SYBSERVER < ./syb_${DATABASE_NAME}_dump"

#***************************************************************************
# Replace "sa" with your Sybase server Administrator's login name.
# Replace "manager" with your Sybase server Administrator's password.
#***************************************************************************
        $SYBASE$OCS_QUAL/bin/isql -Usapsa -PG1234) -I$SYBASE/interfaces -S$SYBSERVER < ./syb_${DATABASE_NAME}_dump
        RETURN_STATUS=$?

if [ "${DUMP_TYPE}" = "DATABASE" ]
then
#       Initiate a backup of any file related to the Sybase database, such as script files.

        echo "bpbackup -c $SYB_FILES_POLICY $SYB_FILES_DIR"
        /usr/openv/netbackup/bin/bpbackup -c $SYB_FILES_POLICY $SYB_FILES_DIR
        BPBACKUP_STATUS=$?

        if [ "$BPBACKUP_STATUS" -ne 0 ]
        then
                echo ""
                echo "bpbackup of $SYB_FILES_DIR returned $BPBACKUP_STATUS"
        fi
fi


echo "Finished `date`"

echo "exit $RETURN_STATUS"
echo ""

exit $RETURN_STATUS

这里SYBSERVER=sapdbs无论我填HA群集的sapdbs或者是sybase的SKP都是一样备不了
#***************************************************************************
# Replace SYBASE12 below with the actual name of the SQL Server
#***************************************************************************
SYBSERVER=sapdbs

我试过sa  sapsa  用户都不行

现在
1> dump database SKP to "sybackup::"
停在了
Backup Server: 4.171.1.1: The current value of 'reserved pages threshold' is
85%.
Backup Server: 4.171.1.2: The current value of 'allocated pages threshold' is
40%.
Backup Server: 4.171.1.5: The current value of 'parallel scan' is 2.
Backup Server session id is: 74. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Msg 3240, Level 18, State 2:
Server 'SKP', Line 1:
Unable to obtain the ASE's current working directory. The ASE must have search
permission on its current working directory and the name must be shorter than
255 bytes.
Msg 3240, Level 18, State 1:
Server 'SKP', Line 1:
Unable to obtain the ASE's current working directory. The ASE must have search
permission on its current working directory and the name must be shorter than
255 bytes.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'sybackup::::000'
然后没反应了,dump 其他的库也是一样的情况

各位高手帮帮忙,帮忙提出解决方法的支付宝100元直接打款,比较急
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP