Oracle DB 12c Administrator Certified Professional
(1Z0-063.AE1)
/ ISBN: 978-1-64459-292-2
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
Oracle DB 12c Administrator Certified Professional
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
LiveLab
-
19+ LiveLab
- 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 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
- Why Use RMAN?
- Exploring the RMAN Architecture
- Getting Started with RMAN
- Configuring RMAN
- Backing Up Your Database with RMAN
- Summary
- Exam Essentials
- 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
- 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
- Overview of the RMAN Report and List Commands
- Monitoring, Administering, and Tuning RMAN
- The Oracle Database Fault Diagnostic Framework
- Summary
- Exam Essentials
- 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
- Describe the Flashback Technologies
- Managing Undo Automatically
- Employing Flashback Technologies
- Perform Flashback Database Operations
- Summary
- Exam Essentials
- Diagnosing Failures
- Managing Database Performance
- Summary
- Exam Essentials
- Managing Storage
- Managing Storage in a CDB and PDBs
- Summary
- Exam Essentials
- Multitenant Container and Pluggable Database Architecture
- Creating Multitenant Container Databases and Pluggable Databases
- Summary
- Exam Essentials
- 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
- Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
- Summary
- Exam Essentials
- Managing Security in a CDB and PDBs
- Summary
- Exam Essentials
Hands on Activities (Live Labs)
- Putting a Database in ARCHIVELOG Mode
- Executing an Offline Backup
- Recovering the Database from the Loss of All Data Files
- Configuring RMAN
- Executing an Online Backup of your ARCHIVELOG Mode Database
- Creating a Recovery Catalog Schema
- Restoring your ARCHIVELOG Mode Database with RMAN
- Using the REPORT Command
- Using the LIST Command
- Performing a Tablespace Point in Time Recovery
- Purging a Table from the Recycle Bin
- Using Flashback Table
- Setting the Diagnostic Destination
- Using ADRCI
- Creating a New CDB Using SQL*Plus
- Connecting to a CDB Using SQL*Plus
- Connecting to a PDB Using SQL*Plus
- Using Data Pump to Migrate a Non-CDB to a CDB
- Creating Common and Local Users
×
