Oracle 12c: Database Administration II Part 1

 

Course Description

 

In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to perform complete and incomplete backup and recovery operations, utilize Oracles new FLEX ASM technology, and utilize Oracles new 12 tuning features such as heat map real time ADDM.

 

Once you have completed Oracle 12c: Database Administration II Part 1 the next course is this series is Oracle 12c: Database Administration II Part 2. The Oracle 12c: Database Administration II Part 2 course will continue to build your knowledge in backup and recovery operations, Oracle’s flashback technology, and advanced resource management.

 

In This Course You Will Learn How To:

  • Define Oracles Multitenant architecture
  • Manage Container Databases
  • Use Oracles’ FLEX ASM
  • Understand the ASM architecture
  • Understand Oracles Cloud File Systems (ACFS)
  • Create a Recovery Catalog
  • Use a Recovery Catalog
  • Define and Create a Virtual Private Catalog
  • Set up Oracle Fast Recovery Area
  • Administer the Recovery Catalog
  • Perform RMAN backups
  • Perform Fast incremental Backups
  • Identify critical losses and non-critical losses
  • Perform RMAN Recovery

 

Prerequisites

 

You need to have equivalent Oracle 9i database experience, taken training in 12c: SQL and PL/SQL and have taken the following courses :

  • Oracle 12c: Database Administration I Part 1
  • Oracle 12c: Database Administration I Part 2

 

Outline

 

 

Module 00: Course Introduction - Oracle 12c Database Administration II Part 1

 

 

 

 

Module 01: Installing the Database Software and Creating a Database

  • Demo: Installing the Database
  • Demo: Creating a Database
  • Lab Exercise: Installing the Database Software
  • Lab Exercise: Create a Database

 

Module 02: Multitenant Architecture

  • Define Oracle’s Multitenant Architecture
  • Root Containers
  • Container databases/Pluggable databases

 

Module 03: Managing Container Databases

  • Connect to a container/pluggable databases
  • Startup/Shutdown a container database
  • Preservation of PDB mode upon restart of CDB
  • Lab: Start/Stop a container database
  • Lab: Preserve Pluggable open mode
  • Lab Demo Solution: Start/Stop a container database
  • Lab Demo Solution: Preserve Pluggable open mode

 

Module 04: Container Users and Roles

  • Create container users
  • Create Container Roles
  • Lab: Create local users
  • Lab: Create local roles
  • Lab Demo Solution: Create local users
  • Lab Demo Solution: Create local roles

 

Module 05: Container Profiles and Privileges

  • Create Container Profiles
  • Grant local privileges
  • Lab: Grant local privileges
  • Lab Demo Solution: Grant local privileges

 

Module 06: ASM Overview

  • ASM Overview
  • ASM Privileges
  • ASM Components
  • ASM Quiz

 

Module 07: ASM Instance Management

  • ASM Instance Administration
  • ASM Instance Parameters
  • ASM diskgroups
  • ASM Startup and Shutdown

 

Module 08: FLEX ASM

  • FLEX ASM Architecture
  • FLEX ASM Overview
  • Configuring Flex ASM
  • Managing Flex ASM
  • Quiz Flex ASM

 

Module 09: ASM Files and Directories

  • Using asmcmd
  • ASM Directory Structure
  • Creating ASM files
  • Creating ASM directories
  • Lab: Using asmcmd
  • Lab Demo Solution: Using asmcmd

 

Module 10: Oracle Cloud File System

  • Cloud File System Overview
  • Cloud File System Components
  • Using ACFS with Oracle ASM
  • Oracle Cloud File System Quiz

 

Module 11: Fast Recovery Area

  • Configure fast recovery area
  • Configure flashback database
  • Lab: Archivelog and flashback mode
  • Lab Demo Solution: Archivelog and flashback mode

 

Module 12: Recovery Catalog

  • Definition of recovery catalog
  • Recovery catalog meta data
  • Create the recovery catalog

 

Modules 13: Recovery Catalog Scripts and Databases

  • Create recovery catalog scripts
  • List target databases
  • Synchronizing the recovery catalog

 

Module 14: Administering the Recovery Catalog

  • Backup the recovery catalog
  • Configure recovery catalog settings
  • Create a virtual private catalog
  • Recovery Catalog Quiz

 

Module 15: RMAN Backups Part 1

  • Backup sets
  • Image copies
  • Non-compressed backups
  • Compressed backups
  • Incremental backups
  • Backup ASM files
  • Backup the Recovery Area
  • Lab: Database backup

 

Module 16: Lab Demo Solution: Database Backup

 

 

 

Module 17: RMAN Backups Part 2

  • RMAN encrypted backups
  • Oracle Transparent Data Encryption
  • Password Encryption
  • Dual Mode Encryption
  • RMAN Backups Quiz

 

Module 18: RMAN Critical Recovery

  • Recover a critical data file
  • Incremental recovery
  • Image copy recovery
  • Recovery to an alternate location
  • Oracle’s Data Recovery Advisor
  • Oracle Block Corruption

 

Module 19: Demo: Recover a non-critical file

 

 

 

Module 20: Diagnosing Backup Issues

  • Using Oracles ADR
  • Using RMAN DEBUG feature
  • Reading Backup messages and Output
  • Diagnosing Backups Quiz

 

Module 21: RMAN Recovery Concepts

  • Instance Recovery
  • Complete Database Recovery
  • Incomplete database Recovery
  • Recovery through Resetlogs.
  • RMAN Recovery Quiz

 

Module 22: RMAN Recovery

  • Recovery in NoArchivelog mode
  • Recovery in Archivelog Mode
  • Recovery of ASM disk Groups
  • Point in Time recovery
  • Table recovery using RMAN
  • Lab: Perform Complete Recovery
  • Lab Demo Solution: Demo on Complete Recovery

 

Module 23: Additional Recovery Concepts

  • Parameter file recovery
  • Control file Recovery
  • Non-critical loss recovery
  • Disaster Recovery
  • Encrypted backup recovery
  • Recovery Concepts Quiz