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 ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.