여기저기 기웃거리기

SELECT   owner,segment_type, tablespace_name, SEGMENT_NAME, SUM(BYTES/(1024*1024))  SIZE_IN_MEG
FROM DBA_SEGMENTS
WHERE tablespace_name IN (SELECT tablespace_name FROM DBA_TABLESPACES WHERE owner NOT IN
  ('SYS','SYSTEM','PUBLIC','OUTLN','WMSYS','ORDSYS','ORDPLUGINS','MDSYS','CTXSYS'
,'XDB','WKSYS','OLAPSYS'))
--GROUP BY rollup( owner,segment_type,tablespace_name,SEGMENT_NAME)
GROUP BY owner,segment_type,tablespace_name,SEGMENT_NAME
ORDER BY SIZE_IN_MEG DESC

[root@host명 ~/util]
08:29 오후 # cat mysql_dump.sh
#!/bin/bash
# mysql_dump.sh
LOG="/home/db_backup_log/mysql_dump"

today=`date +%Y%m%d`
datetime=`date +'%Y%m%d_%H:%M:%S'`

echo "===================="
echo $datetime >> $LOG

# backup 1. DB이름
mysqldump -u root -p비밀번호 DB이름 > 파일명-$today.sql
#echo DB이름 backup completed!!

# make tarball
tar cvfz /var/www/html/db_backup/db-$today.tar.gz *-$today.sql >> $LOG

# delete the sql file
rm -f *-$today.sql >> $LOG
echo finish!! >> $LOG

datetime=`date +'%Y%m%d_%H:%M:%S'`
echo $datetime >> $LOG
echo "===================="


[root@host명 ~/util]
08:29 오후 # cat apache_log_backup.sh
#!/bin/bash
# apache_log_backup.sh
LOG="/home/apache_log_backup/backup_log"

today=`date +%Y%m%d`
datetime=`date +'%Y%m%d_%H:%M:%S'`

echo "=====================" >> $LOG
echo $datetime >> $LOG

# stop httpd
service httpd stop >> $LOG

# make tarball
tar cvfz /home/apache_log_backup/httpd_access_log-$today.tar.gz /var/www/html/log/access* >> $LOG

tar cvfz /home/apache_log_backup/httpd_error_log-$today.tar.gz /var/www/html/log/error* >> $LOG

# delete log file
rm -f /var/www/html/log/* >> $LOG
echo finish!! >> $LOG
service httpd start >> $LOG

datetime=`date +'%Y%m%d_%H:%M:%S'`
echo $datetime >> $LOG

service httpd start >> $LOG
echo "=====================" >> $LOG