各系统备份设置交接.docx

外包DBA

209

7页

0次

2023-01-25

免费下载

各系统备份设置

1. ERP AP

# crontab –l

#0 11 * * * /usr/bin/nd /var/tmp -mme +1 -exec rm -f {} \;

#0 12 * * * /usr/bin/nd /tmp -mme +2 -exec rm -f {} \;

0 1 1,15 * * /tsm/sh/erp_lebak.sh

#0 13 * * * /usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/appl/conc/out -mme +3 -exec

rm -f {} \;

#30 14 * * * /usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/appl/conc/log -mme +3 -exec

rm -f {} \;

#20 09 * * * /usr/bin/nd /d01/PROD/inst/apps/PROD_erp/appltmp -mme +4 -exec rm -f {} \;

00 00 * * * /usr/bin/nmon -f -m /d01/nmon/log -s 600 -c 144

20 12 * * * /home/appprod/scripts/delete_tmple.sh

清理日志脚本

# more /home/appprod/scripts/delete_tmple.sh

#!/bin/sh

/usr/bin/nd /var/tmp -mme +1 -exec rm -f {} \;

/usr/bin/nd /tmp -mme +2 -exec rm -f {} \;

/usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/appl/conc/out -mme +15 -exec rm -f {} \;

/usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/appl/conc/log -mme +15 -exec rm -f {} \;

/usr/bin/nd /d01/PROD/inst/apps/PROD_erp/appltmp -mme +3 -exec rm -f {} \;

cat /dev/null >/d01/PROD/inst/apps/PROD_erp/logs/appl/conc/log/reports.log

/usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/ora/10.1.2/forms -mme +3 -exec rm -f {} \;

cat /dev/null >/d01/PROD/inst/apps/PROD_erp/logs/ora/10.1.2/network/apps_prod.log

/usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/ora/10.1.2/reports/cache -mme +2 -exec

rm -f {} \;

/usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/ora/10.1.3/Apache -mme +4 -exec rm -f

{} \;

备份文件脚本

# more /tsm/sh/erp_lebak.sh

dsmc sele /d01/PROD/ -subdir=yes > /tsm/backuplog/lelog/erp_fsbak_`date +"%Y-%m-%d_%H:

%M:%S"`.log

$ crontab –l

#30 2 * * * /usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/appl/conc/out -mme +15 -exec

rm -f {} \;

#00 3 * * * /usr/bin/nd /d01/PROD/inst/apps/PROD_erp/logs/appl/conc/log -mme +15 -exec

rm -f {} \;

0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/appprod/scripts/chgpri.sh

更改权限脚本

$ more /home/appprod/scripts/chgpri.sh

cd /d01/PROD/apps/apps_st/appl/xxcus/12.0.0/forms/US

chmod 755 *

cd /d01/PROD/apps/apps_st/appl/xxcus/12.0.0/reports/US

chmod 755 *

Appprod

用户环境变量

. /d01/PROD/apps/apps_st/appl/APPSPROD_erp.env

export PATH=$PATH:$ADMIN_SCRIPTS_HOME:$HOME

export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/forms/ZHS

2. ERP DB

# crontab –l

#30 12 * * * /usr/bin/nd /var/tmp -mme +1 -exec rm -f {} \;

#10 12 * * * /usr/bin/nd /tmp -mme +3 -exec rm -f {} \;

00 22 * * 1-6 /tsm/sh/backup_erpdb.sh

#00 18 1,15 * * /tsm/sh/back_erpdb_le.sh

00 18 1 * * /tsm/sh/back_erpdb_le.sh

#00 12 * * * /usr/bin/nd

/d02/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD/trace -mme +4

-exec rm -f {} \;

00 00 * * * /usr/bin/nmon -f -m /d02/nmon/log -s 600 -c 144

00 12 * * * /home/oraprod/scripts/delete_tmple.sh

# more /tsm/sh/backup_erpdb.sh

export log=/tsm/backuplog/dblog/erpdb_fullbk_`date +"%Y.%m.%d_%H.%M.%S"`.log

cmd=/tsm/sh/backup_erpdb.rman

echo `date` > $log

chmod 777 $log

su - oraprod -c "

rman target / cmdle=$cmd msglog=$log"

echo `date` >> $log

strRet=''

strRet=`awk '/ERROR MESSAGE/' $log`

if [ -z "$strRet" ] ;

then

exit 0 ;

else

of 7

免费下载

备份

关注

评论