Issue/Symptom/Question

Need backups disabled while we are doing maintenance on our linux server.

Applies To

Linux 

Database Backups

RMAN Backups

Resolution/Fix/Answer

To disable the Oracle RMAN database backups you will edit the oracle users crontab.

• Log into the linux database server as oracle
• Type crontab -e at the command prompt to edit the scheduled backups. You will see something like this.
  

00 04-22 * * * /u01/app/oracle/local/rman/bin/backup_database.sh -t archive -s 'PROD PROD_H' 
00 23 * * * /u01/app/oracle/local/rman/bin/backup_database.sh -t full -s 'PROD PROD_H'

• Insert a # sign in front of the command to turn them off as seen below.
   

# 00 04-22 * * * /u01/app/oracle/local/rman/bin/backup_database.sh -t archive -s 'PROD PROD_H' 
# 00 23 * * * /u01/app/oracle/local/rman/bin/backup_database.sh -t full -s 'PROD PROD_H'