1、使用Linux Crontal 定时任务来定时对数据库做备份

每日19点开始0级全备，其他时段每小时做1级增量备份

crontab -l

0 19 * * * nohup /rmanbak/script/backup0-1.sh >/dev/null 2>&1 &

30 8,9,10,11,12,13,14,15,16,17 * * * nohup /rmanbak/script/backup1.sh >/dev/null 2>&1 &

2、0级备份脚本

vi backup0-1.sh

export ORACLE_SID=orcl

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

/u01/app/oracle/product/19.0.0/dbhome_1/bin/rman cmdfile=/rmanbak/script/level0-1.rman log=/rmanbak/script/level0-1.out

echo `date` >> /rmanbak/script/level_0

vi level0-1.rman

connect target /

run{

allocate channel ch1 type disk format '/rmanbak/data/ynsb_%U.BKU' maxpiecesize=20G;

allocate channel ch2 type disk format '/rmanbak/data/ynsb_%U.BKU' maxpiecesize=20G;

backup incremental level 0 database plus archivelog ;

}

delete noprompt obsolete;

delete noprompt archivelog until time "sysdate-7";

exit

3、1级增量备份脚本

vi backup1.sh

export ORACLE_SID=orcl

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

/u01/app/oracle/product/19.0.0/dbhome_1/bin/rman cmdfile=/rmanbak/script/level1.rman log=/rmanbak/script/level1.out

echo `date` >> /rmanbak/script/level_1

vi level1.rman

connect target /

run{

allocate channel ch1 type disk format '/rmanbak/data/ynsb_%U.BKU';

allocate channel ch2 type disk format '/rmanbak/data/ynsb_%U.BKU';

backup incremental level 1 database plus archivelog ;

}

exit