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.
Oracle Scheduler and Secure Backup Cloud
- 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