SH file for logical backup of Oracle Database

The ORACLE tutorial is the SH file of the logical backup of the Oracle database.

Full backup 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 SH file: exp_cumu.sh

Rq = 'date + "% m % d "'

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

SH file for Incremental Backup: 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 Add 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 timetable can be changed according to different requirements. This is just an example.