Scheduling Backups using Wizard(Oracle Configuration)

Lesson 6	Scheduling backups using Backup Wizard
Objective	Configure and schedule a backup using the Backup Wizard.

Scheduling Backups using Backup Wizard

The final steps for implementing your database backup, configuration, and scheduling are as simple as following the instructions of the GUI provided by the Backup Wizard.

Backup Wizard: Configuration

The Configuration page allows you to choose the configuration for backup and to view the details that you have set up previously using the Create Backup Configuration option.
A summary of the configuration includes the following elements:

Name of the configuration
Type of destination (disk or tape)
Channel name (User-specified name of the channel)
File name (Unique backup set name)
Drive and path where backup sets are stored
Recovery Catalog credentials if you are using a recovery catalog

Backup Wizard: Schedule

The Schedule page enables you to schedule the execution of a backup. The choices include:

Immediately submits the task as soon as you finish the Wizard. The task executes only one time.
Once schedules the task only one time at the date and time you choose.
On Interval enables you to schedule a specific time interval between task executions. The interval can be a combination of hours and minutes, or number of days. Select the value you want to change and click the scroll buttons. You can also type in a new value.
On Day of Week enables you to schedule the task on one or multiple days (Sunday, Monday, and so on) of the week. Click the days of the week to select the days you want the task scheduled.
On Date of Month enables you to schedule the task on one or multiple days (1 - 31) of the month. Click the dates of the month to select the dates you want the task scheduled.

If you choose a day, such as 31, that is not within a particular month, the job will not be run within that month. To avoid this possible error, choose the first day of the month.

Wizard radio buttons

As indicated by the selections that follow, the Wizard makes the scheduling process simple and efficient.

Start Execution

Choose the first date and time that you want the task executed. This is the starting time for any task scheduled on an interval.

End Execution

Choose the last date and time that you want the task executed. This option does not apply if you chose the Immediately or Once execution options.

Time Zone

Shows the time zone. The agent schedules the task execution at each destination based on the actual system time of each agent. Tasks are not necessarily run simultaneously.

Run on Multiple Databases

The Run on Multiple Databases option allows you to access the Multiple Destination page so that you can specify the destination database(s) to submit the job.

Backup Wizard: Job Information

The Job Information page allows you to specify the name and description for the backup job and what you would like to do with the job as it will appear within the Oracle Enterprise Manager Console Job System.
The choices for what to do with the job are listed below:

Submit the job now. The job is submitted to the Management Server.
Do not submit the job now, but add it to the Job Library for later use. The Enterprise Manager job is added to the Job Library. From the Console, you can edit or submit the job at a later date.
Submit the job now and add it to the Job Library.

You can view the status of the job by selecting the Active and History page tabs within the job window of the console.
The Summary page appears when you click the Finish button. Information about the backup management job you just created using the Wizard is summarized before submission to the Oracle Enterprise Manager job system.
In the following simulation, we will backup the PETS database.
Backing Up with Backup Wizard
The next lesson is the module wrap-up.