Oracle database logical backup of SH files

The ORACLE tutorial you are looking at is :Oracle database logical backup of SH files.

Fully backed SH file: exp_comp.sh

rq=` date +"%m%d" `

su - oracle -c "exp system/manager full=y inctype=complete file=/oracle/export/db_comp$rq.dmp"

Cumulative backup of SH files: exp_cumu.sh

rq=` date +"%m%d" `

su - oracle -c "exp system/ manager full=y inctype=cumulative file=/oracle/export/db_cumu$rq.dmp"

Incremental backup of SH file: exp_incr.sh

rq=` date +"%m%d" `

su - oracle -c "exp system/manager full=y inctype=incremental file=/oracle/export/db_incr$rq.dmp"

root user crontab file

/ var/spool/cron crontabs/root increase the following content

0 2 1 * * /oracle/exp_comp.sh

30 2 * * 0-5 /oracle/exp_incr.sh

45 2 * * 6 /oracle/exp_cumu.sh

Of course, this schedule can be changed according to different needs. This is just one example.