Download PDF
of this course

Certification Exam Prep Seminar: Oracle Database 11g Administration II (EPDB11GA2)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 1 Day

Price: SGD 322.00

This exam prep seminar helps you prepare to take the Oracle Database 11g Administration II certification exam.

  • Oracle Database 11g: Administration II (1Z0-053)

*Prices are subject to change based on location.

Exam Prep Seminars:

  • Provide a thorough review of exam objectives.
  • Illustrate the breadth of topics and skills necessary to pass the exam.
  • Give exclusive tips and strategies to prepare for the certification exam.
  • Increase confidence.

This seminar is for exam review purposes only and does not meet the Hands-on Course training requirement (if applicable to your certification track). We recommend that candidates who have no experience or have not completed any relevant training, opt for the associated training package instead.


Who Should Attend

  • Database Administrators
  • Project Manager
  • Sales Consultants
  • Technical Consultant

Course Certifications

This course is part of the following Certifications:


Course Objectives

  • Learn from one of Oracle University's top instructors.
  • Review key technologies and certification concepts related to Oracle Database 12c: Advanced Administration.
  • Understand the depth and breadth of the Oracle Database Administrator.
  • Get information that will help you complete your preparation and study.
  • Receive tips and information that will help you on the test.

Course Content

Database Architecture and ASM

  • Describe Automatic Storage Management (ASM)
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Use RMAN to migrate your database to ASM
  • Execute SQL commands with ASM file names

Performing User-Managed Backup and Recovery

  • Perform user-managed and server managed backups
  • Identify the need of backup mode
  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Recover from a lost TEMP file and Recover from a lost redo log group
  • Recover from the loss of password file
  • Recovering a Read-Only Tablespace and Recovering from a Lost Index Tablespace
  • Back up and recover a control file

Configuring for Recoverability

  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Configure the Flash Recovery Area
  • Use Flash Recovery Area
  • Describe the RMAN repository and recovery catalog

Using the RMAN Recovery Catalog

  • Identify situations that require RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and Use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

Configuring Backup Specifications

  • Configure backup settings
  • Describe the Media Management Library interface
  • Allocate channels to use in backing up
  • Configure backup optimization

Using RMAN to Create Backups

  • Use the RMAN BACKUP command to create backup sets
  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup and block change tracking
  • Create duplex backup and back up backup sets
  • Create a multisection,compressed and encrypted backup
  • Create an archival backup for long-term retention
  • Report on and maintain backups

Using RMAN to Perform Recovery

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • Perform Disaster recovery

Using RMAN to Duplicate a Database

  • Using a duplicate database
  • Creating a duplicate database

Performing Tablespace Point-in-Time Recovery

  • Identify the situations that require TSPITR
  • Perform automated TSPITR

Monitoring and Tuning RMAN

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronus I/O

Using Flashback Technology and Additional Flashback Operations

  • Restore dropped tables from the recycle bin
  • Perform Flashback Query
  • Use Flashback Transaction
  • Perform Flashback Table operations
  • Configure, Monitor Flashback Database and Perform Flashback Database operations
  • Set up and use a Flashback Data Archive

Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Detect database corruption
  • Perform Block Media Recovery

Managing Memory

  • Implement Automatic Memory Management
  • Manually configure SGA parameters
  • Configure automatic PGA memory management

Managing Database Performance

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Understand Database Replay

Space Management

  • Describe the concepts of transportable tablespaces and databases
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Manage resumable space allocation

Managing Resources

  • Understand the database resource manager
  • Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks

Administering the Scheduler

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

Automatic Performance Management

  • Diagnose database performance issues
  • Use asynchronous COMMIT effectively

Managing Schema Objects

  • Determine appropriate table types for your requirements: heap, partition, IOT, or cluster
  • Perform DBA tasks on schema objects

Database Security

  • Implement Transparent Data Encryption (TDE)
  • Describe Data Pump (DP) encryption
  • Identify components of Recovery Manager (RMAN)–encrypted backups
  • Define basic concepts of a Virtual Private Database (VPD)
  • Apply a column-level VPD policy

Using Globalization Support

  • Determine a correct database character set that meets your business requirements
  • Obtain globalization support configuration information
  • Customize language-dependent behavior for the database and individual sessions
  • Specify different linguistic sorts for queries
  • Retrieve data that matches a search string ignoring case or accent


Course ID: EPDB11GA2

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register