Oracle DB 12c Administrator Certified Professional

(1Z0-063.AE1)/ISBN:9781644592922

This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)

Lessons

14+ Lessons | 269+ Exercises | 144+ Quizzes | 107+ Flashcards | 107+ Glossary of terms

TestPrep

50+ Pre Assessment Questions | 2+ Full Length Tests | 50+ Post Assessment Questions | 100+ Practice Test Questions

Hand on lab

19+ LiveLab | 00+ Minutes

Here's what you will learn

Download Course Outline

Lessons 1: Performing Oracle User-Managed Backups

  • Oracle Database Data Protection Options
  • Understanding the Oracle Database as It Relates to Backup and Recovery
  • Configuring the Database for Backup and Recovery
  • Performing Oracle Offline Backups
  • Performing Oracle Online Backups
  • Backing Up the Control File
  • Summary
  • Exam Essentials

Lessons 2: Performing Oracle User-Managed Database Recoveries

  • Performing a Recovery in NOARCHIVELOG Mode
  • Performing a Full Database Recovery in ARCHIVELOG Mode
  • Performing User-Based Incomplete Recoveries
  • Performing Other Types of Recoveries
  • Summary
  • Exam Essentials

Lessons 3: Configuring and Backing Up Oracle Databases Using RMAN

  • Why Use RMAN?
  • Exploring the RMAN Architecture
  • Getting Started with RMAN
  • Configuring RMAN
  • Backing Up Your Database with RMAN
  • Summary
  • Exam Essentials

Lessons 4: Using the RMAN Recovery Catalog

  • Introducing the Recovery Catalog
  • Creating the Recovery Catalog User and Schema Objects
  • Using a Recovery Catalog
  • Using Scripts in the RMAN Recovery Catalog
  • Maintaining the Recovery Catalog
  • Using the RMAN Virtual Private Catalog
  • Summary
  • Exam Essentials

Lessons 5: Recovering Databases with RMAN

  • RMAN Database-Recovery Basics
  • Recovering a Database in NOARCHIVELOG Mode
  • Recovering a Database in ARCHIVELOG Mode
  • Recovering a Database Using Incomplete Recovery
  • Using Image Copies to Recover Your Database
  • Other Basic Recovery Topics
  • Summary
  • Exam Essentials

Lessons 6: Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow

  • Overview of the RMAN Report and List Commands
  • Monitoring, Administering, and Tuning RMAN
  • The Oracle Database Fault Diagnostic Framework
  • Summary
  • Exam Essentials

Lessons 7: Performing Oracle Advanced Recovery

  • Switching between RMAN Incarnations
  • Overview of RMAN Database Duplication
  • Performing an RMAN Tablespace Point-in-Time Recovery
  • Restoring a Database to a New Host
  • Backup Best Practices for Data Warehouses
  • Performing Table and Partition Recovery from Backups
  • ASM-Related Backups
  • Configuring and Using Oracle Secure Backup
  • Oracle Database 12c Multitenant Architecture and RMAN
  • Summary
  • Exam Essentials

Lessons 8: Understanding Flashback Technology

  • Describe the Flashback Technologies
  • Managing Undo Automatically
  • Employing Flashback Technologies
  • Perform Flashback Database Operations
  • Summary
  • Exam Essentials

Lessons 9: Diagnosing the Database and Managing Performance

  • Diagnosing Failures
  • Managing Database Performance
  • Summary
  • Exam Essentials

Lessons 10: Managing Database Resources

  • Managing Storage
  • Managing Storage in a CDB and PDBs
  • Summary
  • Exam Essentials

Lessons 11: Creating Oracle Multitenant Databases

  • Multitenant Container and Pluggable Database Architecture
  • Creating Multitenant Container Databases and Pluggable Databases
  • Summary
  • Exam Essentials

Lessons 12: Managing Oracle Multitenant Databases

  • Establishing Connections to CDB/PDB
  • Start Up and Shut Down a CDB and Open and Close PDBs
  • Evaluate the Impact of Parameter Value Changes
  • Summary
  • Exam Essentials

Lessons 13: Oracle Utilities

  • Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
  • Summary
  • Exam Essentials

Lessons 14: Oracle Security in CDBs and PDBs

  • Managing Security in a CDB and PDBs
  • Summary
  • Exam Essentials

Hands-on LAB Activities

Performing Oracle User-Managed Backups

  • Putting a Database in ARCHIVELOG Mode
  • Executing an Offline Backup

Performing Oracle User-Managed Database Recoveries

  • Recovering the Database from the Loss of All Data Files

Configuring and Backing Up Oracle Databases Using RMAN

  • Configuring RMAN
  • Executing an Online Backup of your ARCHIVELOG Mode Database

Using the RMAN Recovery Catalog

  • Creating a Recovery Catalog Schema

Recovering Databases with RMAN

  • Restoring your ARCHIVELOG Mode Database with RMAN

Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow

  • Using the REPORT Command
  • Using the LIST Command

Performing Oracle Advanced Recovery

  • Performing a Tablespace Point in Time Recovery

Understanding Flashback Technology

  • Purging a Table from the Recycle Bin
  • Using Flashback Table

Diagnosing the Database and Managing Performance

  • Setting the Diagnostic Destination
  • Using ADRCI

Creating Oracle Multitenant Databases

  • Creating a New CDB Using SQL*Plus

Managing Oracle Multitenant Databases

  • Connecting to a CDB Using SQL*Plus
  • Connecting to a PDB Using SQL*Plus

Oracle Utilities

  • Using Data Pump to Migrate a Non-CDB to a CDB

Oracle Security in CDBs and PDBs

  • Creating Common and Local Users