ORACLE RMAN BACKUP SCHEDULER IN 14 DAYS

1/ Set RMAN backup policy:

SQL> alter system set control_file_record_keep_time=14;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE RETENTION POLICY TO recovery window of 14 days;

2/ Make scripts

[root@DW scripts]# cat DWdb_full.sh
export ORACLE_SID=DWDB
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export PATH=/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/u01/bin
rman target / log=/data/RMAN/DWDB_rman_level_0_`date +"%d-%m-%Y"`.log << EOF
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
set controlfile autobackup format for device type disk to '/data/RMAN/DWDB_control_%F';
backup as compressed backupset incremental level 0 format '/data/RMAN/%d_%t_%U.rman' database;
sql 'alter system archive log current';
backup as compressed backupset format '/data/RMAN/%d_archive_%s_%t_%U.rman' archivelog all not backed up 1 times delete input;
release channel c1;
release channel c2;
delete noprompt obsolete recovery window of 14 days;
}
EOF
exit;


[root@DW scripts]# cat DWdb_incre.sh
export ORACLE_SID=DWDB
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export PATH=/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/u01/bin
rman target / log=/data/RMAN/DWDB_rman_level_1_`date +"%d-%m-%Y"`.log << EOF
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
set controlfile autobackup format for device type disk to '/data/RMAN/DWDB_control_%F';
backup as compressed backupset incremental level 1 format '/data/RMAN/%d_%t_%U.rman' database;
sql 'alter system archive log current';
backup as compressed backupset format '/data/RMAN/%d_archive_%s_%t_%U.rman' archivelog all not backed up 1 times delete input;
release channel c1;
release channel c2;
delete noprompt obsolete recovery window of 14 days;
}
EOF
exit;

3/ Make Crontab to schedule backup

[root@DW ~]# crontab -l
0 0 * * 6 su - oracle /data/scripts/DWdb_full.sh
0 0 * * 0,1,2,3,4,5 su - oracle /data/scripts/DWdb_incre.sh