- 論壇徽章:
- 0
|
本帖最后由 rebelllz 于 2014-08-10 22:40 編輯
環(huán)境是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 用戶都不行
現(xiàn)在
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元直接打款,比較急 |
|