Oracle DB 12c Administrator Certified Professional

(1Z0-063.AE1) / ISBN : 978-1-64459-292-2

Lessons

Lab

TestPrep

AI Tutor (Add-on)

158 Reviews

Get A Free Trial

This course includes:

Free pre-assessment and first 2 lessons

14+ Interactive Lessons | 269+ Exercises

Accessible on mobile and tablet too

Certificate of completion

About This Course

Skills You’ll Get

Interactive Lessons

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

Gamified TestPrep

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

Hands-On Labs

19+ LiveLab | 00+ Minutes

Lesson Plan

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

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

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

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

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

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

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

Understanding Flashback Technology

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

Diagnosing the Database and Managing Performance

Diagnosing Failures
Managing Database Performance
Summary
Exam Essentials

Managing Database Resources

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

Creating Oracle Multitenant Databases

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

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

Oracle Utilities

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

Oracle Security in CDBs and PDBs

Managing Security in a CDB and PDBs
Summary
Exam Essentials

Hands-on LAB Activities