Oracle

Oracle DB 12c Administrator Certified Professional

(1Z0-063-2nd)
Lessons
Lab
TestPrep

Skills You’ll Get

Download Course Outline

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
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
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
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
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
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
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
8

Understanding Flashback Technology

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

Diagnosing the Database and Managing Performance

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

Managing Database Resources

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

Creating Oracle Multitenant Databases

  • Multitenant Container and Pluggable Database Architecture
  • Creating Multitenant Container Databases and Pluggable Databases
  • Summary
  • Exam Essentials
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
13

Oracle Utilities

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

Oracle Security in CDBs and PDBs

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

1

Performing Oracle User-Managed Backups

  • Creating a Tablespace
  • Using UNDO TABLESPACE
  • Resizing Data Files
  • Putting a Database in ARCHIVELOG Mode
  • Executing an Offline Backup
2

Performing Oracle User-Managed Database Recoveries

  • Recovering the Database from the Loss of All Data Files
3

Configuring and Backing Up Oracle Databases Using RMAN

  • Configuring RMAN
  • Creating a Table Using Compression
  • Executing an Online Backup of your ARCHIVELOG Mode Database
4

Using the RMAN Recovery Catalog

  • Creating a Recovery Catalog Schema
5

Recovering Databases with RMAN

  • Restoring your ARCHIVELOG Mode Database with RMAN
6

Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow

  • Using the REPORT Command
  • Using the LIST Command
  • Using the V$SESSION View
7

Performing Oracle Advanced Recovery

  • Performing a Tablespace Point in Time Recovery
8

Understanding Flashback Technology

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

Diagnosing the Database and Managing Performance

  • Setting the Diagnostic Destination
  • Using ADRCI
  • Managing Initialization-Parameter Files
10

Creating Oracle Multitenant Databases

  • Creating a New CDB Using SQL*Plus
  • Unlocking the Pluggable Database
11

Managing Oracle Multitenant Databases

  • Connecting to a CDB Using SQL*Plus
  • Connecting to a PDB Using SQL*Plus
  • Displaying the Connection Name
  • Unlocking and Connecting to the User Account
  • Altering the Session of the Database Container and the Pluggable Database
  • Creating a New Pluggable Database
12

Oracle Utilities

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

Oracle Security in CDBs and PDBs

  • Creating Common and Local Users
  • Creating a Database User and Granting Privileges to a User
  • Creating and Granting Roles to a User
  • Revoking Privileges and Dropping a Role
  • Creating a Profile
  • Granting the System Privilege

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More