Auto backup - Oracle cold backup on linux

[auto_db_backup.sh]-------------------------------------------------------------
#! /bin/bash
WEEKAGO=`date -d "-7 days" +%Y%m%d`
NOW=`date +%Y%m%d`
/oracle/product/9.2.0/bin/sqlplus /nolog <connect / as sysdba
shutdown
exit
EOF
tar -cvf /work/db_backup/oradata_$NOW.tar /oradata
tar -cvf /work/app_backup/iepcs_tw_$NOW.tar /usr/local/tomcat4/webapps/ROOT
rm -f /work/db_backup/*_$WEEKAGO.tar
rm -f /work/app_backup/*_$WEEKAGO.tar
/oracle/product/9.2.0/bin/sqlplus /nolog <connect / as sysdba
startup
exit
EOF
--------------------------------------------------------------------------------

[auto_ftp_send_data.sh]-------------------------------------------------------------
#! /bin/bash
NOW=`date +%Y%m%d`
ftp -vn <open 165.244.124.134
user pop "popadmin"
prompt
put /work/db_backup/oradata_$NOW.tar /oradata_$NOW.tar
bye
EOF
--------------------------------------------------------------------------------

[auto_ftp_send_apps.sh]-------------------------------------------------------------
#! /bin/bash
NOW=`date +%Y%m%d`
ftp -vn <open 165.244.124.134
user pop "popadmin"
prompt
put /usr/local/httpd/conf/httpd.conf /$NOW_httpd.conf
put /usr/local/httpd/workers.properties /$NOW_workers.properties
put /usr/local/tomcat4/conf/server.xml /$NOW_server.xml
put /usr/local/tomcat4/webapps/ROOT/WEB-INF/web.xml /$NOW_web.xml
put /home/oracle/.bash_profile /$NOW_oracle_bash_profile
put /work/app_backup/iepcs_tw_$NOW.tar /$NOW_iepcs_tw.tar
bye
EOF
--------------------------------------------------------------------------------

[crontab]-----------------------------------------------------------------------
0 23 * * * /home/oracle/auto_db_backup.sh
10 23 * * 0 /home/oracle/auto_ftp_send_data.sh
50 23 * * * /home/oracle/auto_ftp_send_apps.sh
분 시 일 월 요일 명령
--------------------------------------------------------------------------------

댓글 없음:

댓글 쓰기