|
|
[ÀϹÝ] ¹é¾÷À» À§ÇÑ Ç¥ÁØ ½ºÅ©¸³Æ®ÀÇ ÀÛ¼º |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:3836 |
|
|
>>> ¹é¾÷À» À§ÇÑ Ç¥ÁØ ½ºÅ©¸³Æ®ÀÇ ÀÛ¼º
####################################
### ¿À¶óŬ ¹é¾÷ Ç¥ÁØ
####################################
#!/bin/bash
# ¿À¶óŬ ÀͽºÆ÷Æ® ¹é¾÷
# dt=$(date +ora9%Y%m%d)
su - oracle << EEOF
#/opt/oracle/app/product/920/bin/exp system/drim123 file=/backup/oracle/$dt.expora9.dmp log=/backup/oracle/$dt.expora9.log fu
ll=y rows=y direct=y compress=n
/opt/oracle/app/product/920/bin/exp cold/cold123 file=/backup/oracle/expora9.dmp log=/backup/oracle/expora9.log rows=y direct
=y compress=n indexes=y constraints=y grants=y
EEOF
# control file backup
# mv /backup/oracle/control.ctl /backup/oracle/control/control.ctl
su - oracle << EEOF
/opt/oracle/app/product/920/bin/sqlplus '/ AS SYSDBA '
alter database backup controlfile to '/backup/oracle/control.ctl' ;
EEOF
exit
####################################
### ¼Ò½º ¹é¾÷ Ç¥ÁØ ( mysql, ÇÁ·Î±×·¥¼Ò½º, ÇÊ¿äÇÑ ¸ðµç ¼Ò½º )
####################################
#!/bin/bash
#
# Mysql server backup cron policy
#
dt=$(date +%Y%m%d)
echo $dt 'source backup start !!! ' >> /var/log/backup.log
tar -cvzf /backup/src/src.tar.gz /org/kidari --exclude=*.ttf --exclude=*.gz
echo $dt 'source backup end !!!!! ' >> /var/log/backup.log
####################################
### ½Ã½ºÅÛ È®ÀÎ ¹é¾÷ Ç¥ÁØ
####################################
#!/bin/bash
# Mr,lee [df -h] cron is excuting daily
dt=$(date +%Y-%m-%d)
echo 'Start df -h ' $dt >> /var/log/backup.log
df -h >> /var/log/backup.log
echo 'End df -h ' $dt >> /var/log/backup.log
exit 0
####################################
### logrotate Ç¥ÁØ -- ±ÇÇÑÀÌ root ¸¸ °¡´É
####################################
>>> ·Î±× ·ÎÅ×ÀÌÆ® ¹é¾÷À» ÇÒ ´ë»óÀÌ Á¸ÀçÇØ¾ß ÇϹǷΠÃÖÁ¾¿¡ ½ÇÇàµÇ¾î¾ß ÇÑ´Ù.
>>> Å©·Ð¿¡ ¼³Á¤µÇ ÀÖ´Â ºÎºÐ
01 2 * * * root /usr/sbin/logrotate -f /backup/rotate.conf
>>> /backup/rotate.conf ÀÇ ³»¿ë
# kidari
/backup/oracle/expora9.dmp {
mail zenos@drimhitech.com
rotate 7
}
################################################
#[root@localhost cron.weekly]# vi backup.rotate.cron
............................................................
#! /bin/bash
################################################################
# ÇØ´ç µð·ºÅ丮ÀÇ ÆÄÀÏÀÇ ¼³Á¤°³¼ö¸¸Å ³²±â°í »èÁ¦ ÇÏ´Â ½ºÅ©¸³Æ®
# 2005 6 28 lee
################################################################
# º¯¼ö ÃʱâÈ ( µð·ºÅ丮 1 )
################################################################
DIR_NAME="/home/drghgus/bash_test" # À̵¿ÇÒ µð·ºÅ丮·Î ¼³Á¤
EXT_NAME="*.dmp" # ÇöÀç µð·ºÅ丮ÀÇ È®ÀåÀÚ *.dmp ÆÄÀÏÀ» Ž»ö.
REMAIN_FILE_NUM=10 # ³²±â°íÀÚÇÏ´Â ÆÄÀÏÀÇ °¹¼ö
LOG_FILE_NAME="/var/log/backup.log" # ·Î±×ÆÄÀÏÀ» ÁöÁ¤ÇÑ´Ù.
cntFile=0
cd $DIR_NAME
TOT_FILE=$(ls $EXT_NAME | wc -w ) # ¼ÂÆÃµÈ È®ÀåÀÚ°¡ ÀÖ´Â ÈÀÏÀÇ Àüü °¹¼ö
echo $'\n' "¢Ñ $yymmdd $DIR_NAME µð·ºÅ丮 Á¤ ¸® ½Ã ÀÛ " >> $LOG_FILE_NAME
let "lastCnt=$TOT_FILE-$REMAIN_FILE_NUM"
for filename in $EXT_NAME
do
fname=`basename $filename`
let "cntFile +=1"
if [ "$cntFile" -le "$lastCnt" ]
then
rm -f $fname
echo "$cntFile $fname »èÁ¦ " >> $LOG_FILE_NAME
else
echo "$cntFile $fname $b $n ÃÖ±ÙÆÄÀÏ·Î SKIP !!!" >> $LOG_FILE_NAME
fi
done
sleep 1 # Àá½Ã ´ë±â°¡ ÇÊ¿äÇÒ °æ¿ì
echo " ¿Ï·á !!! " >> $LOG_FILE_NAME
|
|
|
|
|
|