Oracle Technical Track

How to efficiently back up and restore crontab

2 min read

Jul 27, 2018 12:00:00 AM

When a database environment is being patched, entries from crontab are commented and then removed when patching is completed. The process works well when there are only a few entries from crontab, but it does not scale when crontab has dozens of entries and when some entries are commented and some are not. I believe a more efficient method is to backup and restore the existing crontab. Here's a demo: Crontab entries.

[oracle@racnode-dc1-1 ~]$ crontab -l
 */05 * * * * /bin/date > /tmp/date.out 2>&1
 */15 * * * * /bin/date > /tmp/date.out 2>&1
 #*/25 * * * * /bin/date > /tmp/date.out 2>&1
 */35 * * * * /bin/date > /tmp/date.out 2>&1
 */45 * * * * /bin/date > /tmp/date.out 2>&1
 */55 * * * * /bin/date > /tmp/date.out 2>&1

Backup crontab and display contents. Extra precaution in case crontab.save.dinh is removed.

[oracle@racnode-dc1-1 ~]$ crontab -l > crontab.save.dinh; cat crontab.save.dinh
 */05 * * * * /bin/date > /tmp/date.out 2>&1
 */15 * * * * /bin/date > /tmp/date.out 2>&1
 #*/25 * * * * /bin/date > /tmp/date.out 2>&1
 */35 * * * * /bin/date > /tmp/date.out 2>&1
 */45 * * * * /bin/date > /tmp/date.out 2>&1
 */55 * * * * /bin/date > /tmp/date.out 2>&1

Remove crontab.

[oracle@racnode-dc1-1 ~]$ crontab -r; crontab -l
 no crontab for oracle

Restore crontab.

[oracle@racnode-dc1-1 ~]$ crontab crontab.save.dinh; crontab -l
 */05 * * * * /bin/date > /tmp/date.out 2>&1
 */15 * * * * /bin/date > /tmp/date.out 2>&1
 #*/25 * * * * /bin/date > /tmp/date.out 2>&1
 */35 * * * * /bin/date > /tmp/date.out 2>&1
 */45 * * * * /bin/date > /tmp/date.out 2>&1
 */55 * * * * /bin/date > /tmp/date.out 2>&1

If you are lazy like me, then backup can be done in one command.

[oracle@racnode-dc1-1 ~]$ crontab -l > crontab.save.dinh; cat crontab.save.dinh; crontab -r; crontab -l
 */05 * * * * /bin/date > /tmp/date.out 2>&1
 */15 * * * * /bin/date > /tmp/date.out 2>&1
 #*/25 * * * * /bin/date > /tmp/date.out 2>&1
 */35 * * * * /bin/date > /tmp/date.out 2>&1
 */45 * * * * /bin/date > /tmp/date.out 2>&1
 */55 * * * * /bin/date > /tmp/date.out 2>&1
 no crontab for oracle
 [oracle@racnode-dc1-1 ~]$

On this page

Ready to unlock value from your data?

With Pythian, you can accomplish your data transformation goals and more.

Speak with Pythian consultants now →

What We Do

How to efficiently back up and restore crontab

Share this

Share this

More resources

Using Sed For Search and Replace

Detect and Notify Linux Server Restart

How to remove grid 12.2 after an 18c upgrade

Ready to unlock value from your data?