Oracle

Oracle DB 12c Administrator Certified Professional

(1Z0-063-2nd)
Lessons
Lab
TestPrep
Get A Free Trial

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

Related Courses

All Course