#!/bin/sh # # sybase: Starts the available Servers # # Version: @(#) /etc/rc.d/init.d/sybase 1.2 # # chkconfig: 345 85 15 # # description: This script will browse through the /opt/sybase/install / # directory and launch all servers configured from this location.
# Source function library. . /etc/rc.d/init.d/functions
# SYBASE should point to the system administrated server area # # Check for the correct SYBASE release area below. # The queryformat should provide the correct setting on the installprefix. # SYBASE=/opt/sybase-12.5 export SYBASE=/opt/sybase
# See how we were called. case "$1" in start) echo -n "Starting Sybase ASE ... " ( cd ${SYBASE}/${SYBASE_ASE}/install ; / unset LANG ; unset LC_ALL ; /
for run_server in RUN_* ; do / su -c "startserver -f ${run_server}" sybase > /dev/null 2>&1 ; / echo -n "${run_server} " ; / done ) echo
touch /var/lock/subsys/sybase ;;
stop) echo -n "Shuting down Sybase ASE configured servers: " killproc dataserver killproc backupserver killproc monserver
(7)管理数据库 运行:/opt/sybase/sybcent41/bin/scjview来配置数据库和创建管理数据库 ( 备份数据库 备份脚本: dumpdb.sh : #rh linux #!/bin/sh su - sybase -c "isql -SWWW -Uusername -P******" <<! dump database dbname to "/software/databak/dump.01" stripe on "/software/databak/dump.02" stripe on "/software/databak/dump.03" go !
/ fullbackup.sh: #!/bin/sh # ************************************************************************* #for full backup after excuted dbcc operation # ************************************************************************* ISQL="/opt/sybase/OCS-12_5/bin" dump="dump" ymd=`date +%y%m%d` bk_user="username" bk_pwd="*******" bk_db="dbname" cd /software/databak #mkdir $ymd LOG="/software/databak/$ymd" #mkdir $LOG touch $LOG/backup.log echo $ymd >$LOG/backup.log echo "/n11*************************" >>$LOG/backup.log echo "Check database $bk_db..." >>$LOG/backup.log d1=`date` su - sybase -c "isql -Ssvname -Uusername -P******** "<<DBCC >$LOG/dbcc-$ymd.log 2>&1 go dbcc checkdb($bk_db) go DBCC
d1=`date` echo $d1,`date` >>$LOG/backup.log echo "/n22*************************" >>$LOG/backup.log d1=`date` dump_file="/software/databak/$dump-$ymd.dat" echo "Dump database $bk_db to " $dump_file >>$LOG/backup.log touch $LOG/dump-$ymd.log su - sybase -c "isql -Ssvname -Uusername -P******* " <<DUMP >$LOG/dump-$ymd.log 2>&1 dump database $bk_db to "$dump_file" go DUMP
#dump database dbname to "/export/backup/dump.01" #stripe on "/export/backup/dump.02" #stripe on "/export/backup/dump.03" echo $d1,`date` >>$LOG/backup.log echo "/n33*************************" >>$LOG/backup.log (9)其他的请参考我的"Sybase12.5 for linux 安装步骤" 查看redhat 是32位还是64位的命令为: getconf WORD_BIT(这是一位朋友告诉我的)