Tablespace Backup Using Cron on Linux
April 5, 2012 Leave a comment
Let’s do all things, step by step:
1. Create directories for Backup, Script and Logs.
mkdir -p /u02/Backup/Backup
mkdir -p /u02/Backup/Scripts
mkdir -p /u02/Backup/Logs
2. Create backup script.
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=my_sid
$ORACLE_HOME/bin/rman target / msglog /u02/Backup/Logs/BackupTBS_MYTABLESPACE.log append << EOF
run{
backup tablespace MYTAVLESPACE format '/u02/Backup/Backup/BackupTBS_MYTABLESPACE_%T.bkp';
delete noprompt backup of tablespace MYTABLESPACE completed before 'SYSDATE-1';
}
EOF
save this script as MYTABLESPACE_disk_backup.sh
3. Change permissions and owner of this file.
chown oracle:oinstall MYTABLESPACE_disk_backup.sh
chmod a+x MYTABLESPACE_disk_backup.sh
4. Create cron job.
su - oracle
crontab -e
--add the following line(this script will run at 8:00 PM everyday)
00 20 * * * /u02/Backup/Scripts/MYTABLESPACE_disk_backup.sh
cron format is the following:
minute (0-59), hour (0-23, 0 = midnight), day (1-31), month (1-12), weekday (0-6, 0 = Sunday)
* * * * *
asterisk means –> every
5. Reload cron service
su -
service crond reload
That is all.
About Mariami Kupatadze
DBA Knowledge Base 