Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing it from a central location, and running PL/SQL on a remote database as a job. Oracle Database 11g Release 2 also offers backup to Amazon S3 through the Oracle Secure Backup module, this offers a low-cost database backup Web services storage option rather than maintaining a local backup infrastructure. This course demonstrates how to use Oracle Schedule to create email notifications, create file watchers and create and manage remote database and multiple destination jobs. It also discusses the Oracle Secure Backup Cloud module. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup

  • use Scheduler email notifications
  • create a file watcher
  • create remote database and multiple destination jobs
  • use Oracle Secure Backup Cloud module
  • schedule tasks and use Oracle Secure Backup
  • Course Number:
    od_onft_a10_it_enus

    Expertise Level
    Intermediate