- 论坛徽章:
- 0
|
本帖最后由 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元直接打款,比较急 |
|