O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Automating database backups

Everyone needs backups, but no one wants to wake up in the middle of the night to run them manually. That's why automation is so important. There are a number of ways to automate backups, from cron jobs in Linux and Unix to the Windows Task Scheduler. In this section, we'll examine two methods for backup automation.

Automating Backups with scripting

One of the most common ways to automate backups is through the use of OS scripting languages, such as shell scripting in Linux and Unix. A script is written and then placed in an OS scheduler mechanism such as cron. The process is simple, but the scripting can require a little experience. First, we need to create an RMAN script for the backup commands themselves, as shown ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required