Download PDF
of this course

Certification Exam Prep Seminar: Oracle Database 12c: Advanced Administration (EPDB12CAA)

  • 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 12c: Advanced Administration certification exam.

  • Oracle Database 12c: Advanced Administration (1Z0-063)

*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

Backup and Recovery Concepts (Part 1)

  • Identify the importance of checkpoints, redo log files, and archive log files
  • Configure ARCHIVELOG mode

Backup and Recovery Concepts (Part 2)

  • Back up and recover a NOARCHIVELOG database
  • Configure control files and redo log files for recoverability

Configuring Recovery Manager

  • Create and maintain the Fast Recovery Area
  • Configure database parameters that affect RMAN operations
  • Change RMAN default settings with CONFIGURE
  • Manage RMAN's persistent settings
  • Start the RMAN utility and allocate channels

Configuring Recovery Manager: 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

Basics of Using RMAN to Create Backups

  • Create backupsets and image copies
  • Create a whole database backup
  • Perform full and incremental backups
  • Enable fast incremental backup
  • Report on and maintain backups

Additional RMAN Backup Types

  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed, and encrypted backup
  • Perform backup of non-database files
  • Configure and use Oracle Secure Backup

Performing Recovery

  • Determine the need for performing recovery
  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Recover the control file
  • Recover a redo log group member

Additional Recovery Tasks

  • Recover temporary tablespaces, index tablespaces and read-only tablespaces
  • Recreate the password file
  • Perform incomplete recovery using RMAN, database recovery following a RESETLOGS operations, and table recovery from backups
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Use RMAN to migrate your database to ASM
  • Restore a database onto a new host
  • Perform disaster recovery

Performing Tablespace Point-in-Time Recovery

  • Identify situations that require TSPITR
  • Perform automated TSPITR

Using RMAN to Duplicate a Database

  • Choose a technique for duplicating a database
  • Duplicate a database based on a running instance
  • Create a backup based duplicate database

Using Flashback Technologies

  • Use Flashback technology to query data
  • Recover from user errors using Flashback versions query
  • Perform a Flashback table operation
  • Perform transaction-level recovery using Flashback
  • Transaction query
  • Set up and use a Flashback Data Archive
  • Configure and use Flashback Database
  • Monitor the Flashback Database

Dealing with Database Corruption

  • Define block corruption and list its causes and symptoms
  • Implement the DB_BLOCK_CHECKING parameter to detect corruptions
  • Repair corruptions using RMAN
  • Perform Block Media Recovery

Using Data Recovery Advisor

  • Describe Data Recovery Advisor
  • Repair data failures using Data Recovery Advisor
  • Perform a proactive health check of the database

Diagnosing the Database

  • Describe the Automatic Diagnostic Workflow
  • Set up Automatic Diagnostic Repository
  • Use Support Workbench

Monitoring and Tuning RMAN and RMAN Enhancements in Oracle Database 12c

  • Monitor RMAN sessions and jobs
  • Tune RMAN
  • Configure RMAN for Asynchronous I/O
  • Use RMAN enhancements

Transporting Data

  • Describe and use transportable tablespaces and databases

Multitenant Container and Pluggable Database Architecture

  • Describe multitenant architecture
  • Explain pluggable database provisioning

Configuring and Creating CDBs and PDBs and Managing CDBs and PDBs

  • Create and configure a CDB
  • Create a PDB using different methods
  • Unplug and drop a PDB
  • Migrate a non-CDB to a PDB database
  • Establish connection to a CDB/PDB
  • Start up and shut down a CDB and open and close PDBs
  • Change instance parameters for a CDB/PDB

Managing Tablespaces, Common and Local Users, Privileges, and Roles (in CDB/PDBs)

  • Manage permanent and temporary tablespaces in CDB and PDBs
  • Manage common and local users
  • Manage common and local privileges
  • Manage common and local roles
  • Enable common users to access data in specific PDBs

Performing Back up, Recovery, and Flashback for a CDB/PDB

  • Perform backup of a CDB and PDB
  • Perform recovery of a CDB and PDB
  • Perform Flashback for a CDB
  • Use Data Recovery Advisor

Managing Performance in a Multitenant Architecture

  • Monitor operations and performance in a CDB and PDBs
  • Manage allocation of resources between PDBs and within a PDB

Moving Data, Performing Security Operations, and Interacting with Other Oracle Products (for CDB/PDBs)

  • Use Data Pump
  • Use SQL*Loader
  • Perform audit operations
  • Use other products with a CDB and PDBs: Database Vault, Data Guard, LogMiner


Course ID: EPDB12CAA

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