Oracle 11g Certified Professional Exam Prep III

Store and organize RMAN scripts on the operating system and in the recovery catalog, then create, edit, and run full backup scripts to back up databases.

Explore RMAN reporting in Oracle 11g by inspecting backup sets, archive logs, and data files, and learn how the report command guides restore actions to meet retention policies.

Duplicate an Oracle 11g database across two machines by copying to a wind test directory on the second drive, then shut down and mount for a cold backup.

Explore flashback table behavior in Oracle, including locally managed table spaces, extents, and the recycle bin, and learn how overwriting extents affects flashback drop.

Demonstrate flashback database concepts by configuring a flash recovery area, archive logs, performing a test backup, and using a restore point to flashback and complete an incomplete recovery.

Introduce Oracle's ASRM, explore storage virtualization, outline architecture, disk groups, redundancy, mirroring, and failure groups, and explain how ASRM simplifies database storage decisions in single-instance setups.

Demonstrates installing the Oracle database software as a separate Oracle home under the same Oracle base to enable independent patching, aligning with enterprise edition and ASRM setup before database creation.

Explore ASM storage by discovering disks, stamping them with ASRM, and creating disk groups with normal and high redundancy; learn to use ASRM disk and ASRM disk group configuration assistant.

Oracle's resource manager allocates machine resources among user classes, including DBAs, reporting, and transactional users, by buckets and CPU limits, enabling a resource plan.

Explore the resource manager architecture, detailing sessions, consumer groups, resource plans, and directives that allocate cpu, undo, and sessions to groups, with plan switching via the scheduler.

Create a resource plan to allocate cpu resources among groups, nest plans for multi-level allocations, assign resources to each group, and switch plans to fit day or weekend needs.

Explore how to use the Oracle 11g DBMS scheduler to load data into a table, process end-of-month records with a two-step job chain, and email a summary.

Identify performance issues by using the Automatic Database Diagnostic Monitor to compare snapshots, spot the top five slow SQL statements, and guide further analysis with tuning and repair advisors.

Explore oracle 11g additional advisors, including sga and pga memory advisors, undo management, mean time to recover, data recovery, and the segment divisor for coalescing extents.

Demonstrates generating server alerts by corrupting a data file in a new tablespace and auditing the results through Enterprise Manager and the diagnostic repository.

Leverage the diagnostic repository and enterprise manager to view server alerts and active incidents, inspect trace files, and package incident data for Oracle support via command line and support workbench.