Oracle DB 12c Administrator Certified Professional
(1Z0-063.AE1) / ISBN : 978-1-64459-292-2
About This Course
Skills You’ll Get
Get the support you need. Enroll in our Instructor-Led Course.
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
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
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