Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.



Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |


Lesson 15

"The truth is more important than the facts." - Frank Lloyd Wright (1868-1959)


Read first then play the video:

   OEM-VIDEO -Scheduling a database backup


Scheduling a Database backup



As a DBA, you are responsible for scheduling a Database backup for your organization’s database. The following is a summary of your assigned task:


Using the “Backup” tool

Using the Backup Wizard

Specifying a backup date and time

Identifying backup target databases

Submitting a backup job


In this exercise you will learn how to schedule a time to backup one or multiple databases from the "Backup" tool using the Oracle Enterprise Management tool (OEM).

Expand the databases.

Select the DBS4RMAN database.

Go to the "Database Wizards" tools and click on the "Backup" icon to schedule a database backup.

On the "Backup Wizard" window, click next.

Use the "Predefined Backup Strategy" option and click next.

Choose the default backup option and click next.

Specify a backup time and click next.

Identify the database target to be backed up. We are going to use these two databases and click finish.

These are the two target databases.

Click Okay to submit the backup job.

Highlight the "Jobs" item. Notice that there are two jobs for each database. A backup job for the DBS4RMAN database and another job for the SCHOOL database.

These two jobs will backup the entire database with the specified time in the script.