1 #!/bin/sh
  2 date=date;
  3 ss=`$date +%Y%m%d`;
  4 sd=$[ss-1];
  5 #sd="20080630";
  6 cp -a  /mnt/cnsrv158/mpe_db_$sd.txt  /mnt/hd06/DB_backup
  7 #backup oracle database
  8 export ORACLE_HOME=/usr/local/oracle/product/10.2.0/db_1
  9 /usr/local/oracle/product/10.2.0/db_1/bin/exp system/sysmgr@mrp file=/mnt/hd06/DB_backup/mrp_oracle_`date +%Y%m%d`.txt \
 10 log=/mnt/hd01/log/tmp/mrp_oracle_log_`date +%Y%m%d` full=y
 11 #BACKUP DB FOR CNSRV158
 12 #su postgres -c 'bb=`date +%Y%m%d`; pg_dump mrp -h 10.167.64.66 > "/mnt/hd06/DB_backup/cnsrv158_mpe_db_$bb.txt"'
 13 #BACKUP DB FOR CNSRV161
 14 #su postgres -c 'bb=`date +%Y%m%d`; pg_dump mrp > "/mnt/hd06/DB_backup/cnsrv161_mpe_db_$bb.txt"'
 15
 16 #nohup su - postgres -c 'bb=`date +%Y%m%d`; pg_dump wikidb > "/mnt/hd06/DB_backup/cnsrv161_wikidb_$bb.txt"' &
 17 #pg_dump wikidb > "/mnt/hd06/DB_backup/cnsrv161_wikidb_$ss.txt"
~