Oracle Database Administration from Zero to Hero - Automating RMAN Backup Jobs

This lecture covers automating RMAN backup scripts on Linux and Windows platforms. It explains using Cron Tab for scheduling in Linux and Task Scheduler in Windows. The lecture provides examples of Cron Tab configurations and discusses writing backup scripts using bash. It concludes with a summary of the automation process.

What is the primary responsibility of a DBA when setting up RMAN backup jobs?

• To manually run backups every day

• To automate backup jobs using scheduled tasks

• To write backup scripts in Python

• To use only third-party software for backups

Which command is used to edit Cron tab entries as the Oracle user?

• crontab -e

• cron TAB -E

• cron -edit

• crontab -list

In a Cron tab entry, what does an asterisk (*) in the day of the month field signify?

• The job will run every hour

• The job will run every month

• The job will run every day

• The job will run every week

What is the purpose of the online tool Cron Tab Guru?

• To create new Cron tab entries

• To convert Cron tab entries to scripts

• To verify and understand Cron tab expressions

• To schedule tasks on Windows

What is a key feature of the RMAN commands in a backup script?

• They require a separate configuration file

• They can only be executed manually

• They are embedded within the script and passed as multi-line input

• They must be written in Python

What is an important setting to enable in Windows Task Scheduler for automated tasks?

• Run only when the user is logged on

• Run whether the user is logged on or not

• Run only during weekends

• Run only during weekdays

Which tool is used in Windows to automate backup jobs?

• Task Scheduler

• Cron tab

• Backup Wizard

• Job Manager