Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

«
»

Crontab job for RMAN Backup as Level 0 and level 1

Posted by Mir Sayeed Hassan on February 18th, 2018

Crontab job for RMAN Backup as Level 0 and level 1

Create all the directories and give the permission in /backup folder

[oracle@Testdb ~]$ cd /backup/rman/

Example:

$mkdir friday_level_0

And others

[oracle@Testdb rman]$ ls
friday_level_0  monday_level_1  saturday_level_1  sunday_level_1  thursday_level_1  tuesday_level_1  wednesday_level_1
$chmod –R 777 *

Go to the /home/oracle and create the directory as scripts

$mkdir scripts

Friday

[oracle@Testdb scripts]$ vi friday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/friday.rcv > /backup/rman/friday_level_0/rman`date +%F`.log
[oracle@Testdb scripts]$ vi friday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
crosscheck backup;
delete backup;
backup as compressed backupset
incremental level 0
skip inaccessible
tag friday_level_0
format '/backup/rman/friday_level_0/TEST_df_%U'
database;
backup spfile format '/backup/rman/friday_level_0/TEST_spf_%T.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_friday
format '/backup/rman/friday_level_0/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Saturday

[oracle@Testdb scripts]$ vi saturday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/saturday.rcv > /backup/rman/saturday_level_1/rman`date +%F`.log
[oracle@Testdb scripts]$ vi saturday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as compressed backupset
incremental level 1 cumulative
skip inaccessible
tag saturday_level_1
format '/backup/rman/saturday_level_1/TEST_df_%U'
database;
backup spfile format '/backup/rman/saturday_level_1/TEST_spf_%T.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_saturday
format '/backup/rman/saturday_level_1/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Sunday

[oracle@Testdb scripts]$ vi sunday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/sunday.rcv > /backup/rman/sunday_level_1/rman`date +%F`.log
[oracle@Testdb scripts]$ vi sunday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as compressed backupset
incremental level 1 cumulative
skip inaccessible
tag sunday_level_1
format '/backup/rman/sunday_level_1/TEST_df_%U'
database;
backup spfile format '/backup/rman/sunday_level_1/TEST_spf_%T.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_sunday
format '/backup/rman/sunday_level_1/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Monday

[oracle@Testdb scripts]$ vi monday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/monday.rcv > /backup/rman/monday_level_1/rman`date +%F`.log
[oracle@Testdb scripts]$ vi monday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as compressed backupset
incremental level 1 cumulative
skip inaccessible
tag monday_level_1
format '/backup/rman/monday_level_1/TEST_df_%U'
database;
backup spfile format '/backup/rman/monday_level_1/TEST_spf_%T%s.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_monday
format '/backup/rman/monday_level_1/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Thuesday

[oracle@Testdb scripts]$ vi tuesday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/tuesday.rcv ; /backup/rman/tuesday_level_1/rman`date +%F`.log
[oracle@Testdb scripts]$ vi tuesday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as compressed backupset
incremental level 1 cumulative
skip inaccessible
tag tuesday_level_1
format '/backup/rman/tuesday_level_1/TEST_df_%U'
database;
backup spfile format '/backup/rman/tuesday_level_1/TEST_spf_%T.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_tuesday
format '/backup/rman/tuesday_level_1/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Wednesday

[oracle@Testdb scripts]$ vi wednesday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/wednesday.rcv > /backup/rman/wednesday_level_1/rman`date +%F`.log
[oracle@Testdb scripts]$ vi wednesday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as compressed backupset
incremental level 1 cumulative
skip inaccessible
tag wednesday_level_1
format '/backup/rman/wednesday_level_1/TEST_df_%U'
database;
backup spfile format '/backup/rman/wednesday_level_1/TEST_spf_%T.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_wednesday
format '/backup/rman/wednesday_level_1/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Thursday

[oracle@Testdb scripts]$ vi hursday
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/thursday.rcv > /backup/rman/thursday_level_1/rman`date +%F`.log
[oracle@Testdb scripts]$ vi thursday.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as compressed backupset
incremental level 1 cumulative
skip inaccessible
tag thursday_level_1
format '/backup/rman/thursday_level_1/TEST_df_%U'
database;
backup spfile format '/backup/rman/thursday_level_1/TEST_spf_%T.ora';
sql 'alter system archive log current';
backup as compressed backupset
tag archivelog_thursday
format '/backup/rman/thursday_level_1/TEST_arch_%U'
archivelog all not backed up 1 times;
crosscheck archivelog all;
delete archivelog until time 'SYSDATE - 3';
crosscheck backup;
delete obsolete;
}

Level – 0

[oracle@Testdb scripts]$ vi level-0.rcv
export ORACLE_SID=test
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / nocatalog@/home/oracle/scripts/level-0.rcv > /backup/SWINT_rman`date +%Y%m%d`.log
[oracle@Testdb scripts]$ vi level-0.rcv
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
configure controlfile autobackup format for device type disk to '/backup/TEST_cf%F';
backup as compressed backupset section size 20G
incremental level 0
skip inaccessible
tag friday_level_0
format '/backup/TEST_df_t%t_s%s_p%p_%T'
database;
backup spfile format '/backup/TEST_spf_%T.ora';
}

Login as the root and create the crontab command as shown below

[root@Testdb etc]# pwd
/etc

Syntax for crontab:

[root@Testdb etc]# vi crontab

SHELL=/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin

MAILTO=root

HOME=/

# run-parts

01 * * * * root run-parts /etc/cron.hourly

02 4 * * * root run-parts /etc/cron.daily

22 4 * * 0 root run-parts /etc/cron.weekly

42 4 1 * * root run-parts /etc/cron.monthly

# For details see man 4 crontabs

# Example of job definition:

# .—————- minute (0 – 59)

# |  .————- hour (0 – 23)

# |  |  .———- day of month (1 – 31)

# |  |  |  .——- month (1 – 12) OR jan,feb,mar,apr …

# |  |  |  |  .—- day of week (0 – 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat

# |  |  |  |  |

# *  *  *  *  * user-name  command to be executed

Then login as oracle user  as su – oracle and create the crontab –e file

[oracle@Testdb ~]$ crontab –e
0 1 * * 2 /home/oracle/scripts/tuesday
0 1 * * 3 /home/oracle/scripts/wednesday
0 1 * * 4 /home/oracle/scripts/thursday
0 1 * * 5 /home/oracle/scripts/friday
0 1 * * 6 /home/oracle/scripts/saturday
0 1 * * 0 /home/oracle/scripts/sunday
0 1 * * 1 /home/oracle/scripts/Monday

=====Hence tested & verified in our test env=====

This entry was posted on Sunday, February 18th, 2018 at 3:09 pm and is filed under RMAN. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

«
»