SH file for logical backup of Oracle Database

SH file for logical backup of Oracle Database

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.