求 sybase 數(shù)據(jù)庫的cluster suite雙機(jī)腳本

panhua

哪位發(fā)一個(gè)sybase 數(shù)據(jù)庫的redhat cluster suite雙機(jī)腳本，學(xué)習(xí)學(xué)習(xí)啊！
謝謝了

MichaelBibby

貼一個(gè)我自己寫的，謹(jǐn)供參考：

1. 
   
2. #!/bin/bash
   
3. 
   
4. # Author: MichaelBibby <[email]michaelbibby@gmail.com[/email]>
   
5. # Date: 2007.06.19
   
6. 
   
7. # chkconfig: 345 78 78
   
8. # description: Normal RC script for SYBASE.
   
9. 
   
10. . /etc/init.d/functions
    
11. 
    
12. SYBASE_USERNAME="sa"
    
13. SYBASE_PASSWORD=""
    
14. 
    
15. export SYBASE_HOME='/opt/sybase-12.5'
    
16. export SYBASE_OCS='OCS-12_5'
    
17. export SYBASE_ASE='ASE-12_5'
    
18. # ************************************************
    
19. # Warnning: Modify the RUN_xxx to fit your need.
    
20. # Your startup script will be such as:
    
21. #   ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER}
    
22. #   ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER_BACKUP}
    
23. export SERVER='SYBASE'
    
24. export SERVER_BACKUP='SYB_BACKUP'
    
25. # For multi-server
    
26. # export SERVER='server1 server2'
    
27. # export SERVER_BACKUP='server1_backup server2_backup'
    
28. # ************************************************
    
29. 
    
30. export LIB="${SYBASE_HOME}/${SYBASE_OCS}/lib"
    
31. export PATH=$PATH:"${SYBASE_HOME}/${SYBASE_ASE}/bin:${SYBASE_HOME}/${SYBASE_ASE}/install:${SYBASE_HOME}/${SYBASE_OCS}/bin"
    
32. 
    
33. start_db()
    
34. {
    
35.     su - sybase -c "${SYBASE_HOME}/${SYBASE_ASE}/install/startserver \
    
36.     -f ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER}"
    
37. 
    
38.     su - sybase -c "${SYBASE_HOME}/${SYBASE_ASE}/install/startserver \
    
39.     -f ${SYBASE_HOME}/${SYBASE_ASE}/install/RUN_${SERVER_BACKUP}"
    
40. }
    
41. 
    
42. stop_db()
    
43. {
    
44.     ${SYBASE_HOME}/${SYBASE_OCS}/bin/isql \
    
45.     -U${SYBASE_USERNAME} \
    
46.     -P${SYBASE_PASSWORD} \
    
47.     -S${SERVER} <<EOF
    
48. shutdown ${SERVER_BACKUP}
    
49. go
    
50. exit
    
51. EOF
    
52. 
    
53.     ${SYBASE_HOME}/${SYBASE_OCS}/bin/isql \
    
54.     -U${SYBASE_USERNAME} \
    
55.     -P${SYBASE_PASSWORD} \
    
56.     -S${SERVER} <<EOF
    
57. use master
    
58. go
    
59. checkpoint
    
60. go
    
61. shutdown  
    
62. go
    
63. exit
    
64. EOF
    
65. 
    
66. if [ X"$?" == X"0" ]; then
    
67.     exit 0
    
68. else
    
69.     exit 1
    
70. fi
    
71. }
    
72. 
    
73. status_db()
    
74. {
    
75.     chk_sybase=$(ps axw --cols 32768 | grep dataserver | grep -v grep | wc -l)
    
76.     if [ X"$chk_sybase" = X"0" ]
    
77.     then
    
78.         echo -n "Checking Master Server: ${SERVER}"
    
79.         echo_failure
    
80.         echo
    
81.     else
    
82.         echo -n "Checking Master Server: ${SERVER_BACKUP}" && echo_success
    
83.     fi
    
84. 
    
85.     chk_sybase_bs=$(ps axw --cols 32768 | grep backupserver | grep -v grep | wc -l)
    
86.     if [ X"$chk_sybase_bs" = X"0" ];then
    
87.         echo -n "Checking Backup Server: ${SERVER_BACKUP}"
    
88.         echo_failure
    
89.         echo
    
90.     else
    
91.         echo -n "Checking Backup Server: ${SERVER_BACKUP}" && echo_success
    
92.     fi
    
93. 
    
94.     exit 0
    
95. }
    
96.    
    
97. 
    
98. case $1 in
    
99.     start) start_db ;;
    
100.     stop)
     
101.         ps aux | grep -i dataserver | grep -v grep >/dev/null
     
102. 
     
103.         if [ X"$?" == X"0" ]; then
     
104.             stop_db
     
105.         else
     
106.             exit 0
     
107.         fi
     
108.         ;;
     
109.     status) status_db ;;
     
110.     *) echo "USAGE: $0 [start|stop|status]" ;;
     
111. esac
     

復(fù)制代碼

panhua

非常感謝!!!!!!!!!!!!1