root # crontab -l ( to find any job is scheduled)
root # crontab -e
45 23 * * 1 /u02/bkp_scr/backup_scr.job
11:45 pm and 1- monday scheduled for backup
--------------------------------------------------------------------------------------------
root # mkdir bkp_scr
root # chmod -R 777 bkp_scr
root # mkdir BKP
root # chmod -R 777 BKP
--------------------------------------------------------------------------------------------
Backup Scripts
su - oracle -c "/u01/DEMO/inst/apps/DEMO_demo/admin/scripts/adstpall.sh apps/apps" > /u02/bkp_scr/stop_apps.log
sleep 300
#su - oracle -c "/u01/DEMO/db/tech_st/11.1.0/appsutil/scripts/DEMO_demo/adpreclone.pl dbTier" > /u02/bkp_scr/preclone_db.log
#sleep 300
#su - oracle -c "/u01/DEMO/inst/apps/DEMO_demo/admin/scripts/adpreclone.pl appsTier" > /u02/bkp_scr/preclone_apps.log
#sleep 300
su - oracle -c "/u01/DEMO/db/tech_st/11.1.0/appsutil/scripts/DEMO_demo/addlnctl.sh stop DEMO" > /u02/bkp_scr/stop_dblistener.log
sleep 200
su - oracle -c "/u01/DEMO/db/tech_st/11.1.0/appsutil/scripts/DEMO_demo/addbctl.sh stop immediate" > /u02/bkp_scr/stop_db.log
sleep 200
rm -rf /u02/BKP/appsbkp*
rm -rf /u02/BKP/dbbkp*
rm -rf /u02/BKP/instbkp*
DT='date +%d%m%y'
export DT
tar -cvf /u02/BKP/dbbkp_$(DT).tar.gz /u01/DEMO/db > /u02/bkp_scr/dbbkp.log
sleep 300
tar -cvf /u02/BKP/appsbkp_$(DT).tar.gz /u01/DEMO/apps > /u02/bkp_scr/appsbkp.log
sleep 300
tar -cvf /u02/BKP/instbkp1_$(DT).tar.gz /u01/DEMO/inst > /u02/bkp_scr/instbkp.log
sleep 300
su - oracle -c "/u01/DEMO/db/tech_st/11.1.0/appsutil/scripts/DEMO_demo/addlnctl.sh start DEMO" > /u02/bkp_scr/start_dblistener.log
sleep 200
su - oracle -c "/u01/DEMO/db/tech_st/11.1.0/appsutil/scripts/DEMO_demo/addbctl.sh start" > /u02/bkp_scr/start_db.log
sleep 200
su - oracle -c "/u01/DEMO/inst/apps/DEMO_demo/admin/scripts/adstrtal.sh apps/apps" > /u02/bkp_scr/start_apps.log
