Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1

Course code

Orcl_Db12NF

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

Course overview

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course constituted by three modules; the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases.

Objectives

Course Objectives

Create and manage pluggable databases
Describe the challenges and benefits of a sharded database
Handle the ADR automatic file space
Diagnose database issues by using the Trace File Analyzer collector
Use the new SQL*Plus history commands and SQL enhancements such as long identifiers
Use the SQLcl new utility as the new SQL command line interface
Create and manage a multitenant container database

Prerequisites

Suggested Prerequisite

Knowledge of Oracle Database 11g R2

Required Prerequisite

Oracle Database 12c: Install and Upgrade Workshop
Using Oracle Enterprise Manager Cloud Control 13c Ed 2

Audience

End Users
Database Administrators
Database Administrators
System Administrator
System Administrator

Course Outline

Course Topics

1. Introduction

Understanding DB architectures
Diagnosing database problems
Global objectives of the course
Schedule of the week
Using SQL new features and tools
Lessons grouped by modules

2. Creating Application PDBs and Installing Applications

PDBs and applications
Application common objects
Create and manage an application container
Types of containers
Patch and upgrade applications
Regular PDBs vs application PDBs
Application containers
Install applications

3. Managing Security

Enabling Common Users to Access Data in PDBs
Encrypting data in PDBs
Creating common users, roles and profiles in CDB and PDBs
Protecting data with Database Vault policies in CDB and PDBs
Common objects in Application PDBs and operations on Data-Linked objects
Granting privileges commonly in CDB and PDBs
Auditing users in CDB and PDBs
Managing PDB lockdown profiles

4. Moving and Migrating Data

Transporting a database over the network
Exporting non-CDB data and importing non-CDB data into PDB
Using SQL*Loader with PDBs
Exporting and importing between PDBs
Exporting from PDB and importing into a non-CDB
Full Transportable export/import
Using Oracle Data Pump with PDBs

5. Diagnosing Database Problems

TFA Collector utility
Tracing Data Pump
New ADRCI Command
Automatic Diagnostic Repository
MVs refreshed statistics history
Trace File Analyzer (TFA) Collector process and repository
ADR Retention
Network Performance

6. Using SQL New Features and SQLcl

Use SQL row-limiting clause
Use new 128 bytes identifier length for database objects
Describe the support for invisible and hidden columns
Increase length limits of data types
Use the new VALIDATE_CONVERSION function
Recall SQL*Plus commands in the same session from history
Describe the new SQLcl utility

7. Creating PDBs

Cloning regular and application containers PDBs
Converting regular PDBs to application root or PDBs
Cross-Platform transportable PDB
Plugging unplugged regular and application PDBs into CDB
Plugging unplugged PDBs with encrypted data
Perform hot cloning and relocation
Configure and use locla UNDO mode
Plugging or cloning a non-CDB into a CDB

8. acking up, Recoverying and Flashing Back

Instance failure and instance recovery
CDB and PDB backups
PDB point-in-time recovery
New syntax and clauses in RMAN
PDB tempfile, essential and non-SYSTEM tablespaces recovery
CDB and PDB flashback
Duplicating PDBs
Using RMAN backup to plug an unplugged PDB

9. Performing Miscellaneous Operations

Using catcon.pl utility to install/remove options from CDB/PDB
Jobs coordinator and resources
Creating a standby of a CDB
Using Xstreams with a CDB and PDB
Mining statements of a PDB using LogMiner
Scheduling operations in a PDB

10. Understanding CDB Basics

Challenges
Configurations
CDB root and pluggable database containers
SYSTEM objects in the USER container
New Multitenant Architecture: Benefits
Non-CDB Architecture vs Oracle Multitenant Container Database
A pristine installation
Provisioning a pluggable database

11. Creating CDB and Regular PDBs

Tools
Create a CDB using new clauses
What’s new in CDB after CDB creation
ADR
Data dictionary views
Provisioning new PDBs: overview
What to do in CDB after CDB creation

12. Managing CDB and PDBs

Creating and renaming Services
Switching Connection
Opening CDBs and PDBs
Managing CDB and PDBs
Mounting a CDB
Evaluating the impact of parameter value changes
Changing the different modes and settings of PDBs
Starting Up a CDB Instance

13. Managing Storage

Creating Permanent Tablespaces in a CDB
Objects in Tablespaces
UNDO Tablespaces
Tablespaces Created During PDB Creation
Temporary Tablespaces
Defining Default Permanent Tablespaces

14. Managing Performance

Monitoring PDB memory usage
AWR report
Managing SGA and PGA for PDBs
Controlling the Degree of Parallelism of Queries
PDB-Level snapshot views
AWR and ADDM behaviour at CDB and PDB levels
Sizing the CDB
Tuning a CDB

15. Managing Resources Allocation

Controlling PDB IO rate limit
Managing resources within a PDB
CDB Resource plan basics: Limits + cpu_count init parm per PDB
Creating and setting PDB performance profiles
Allocating resources in the CDB and PDBs
Managing resources between PDBs

16. Understanding Database Sharding

Benefits of Sharding
Advantages of Oracle Sharding over NoSQL
Creating Sharded Tables
Sharded Table Family
What Is Database Sharding?
Application Considerations for Sharding
Components of Database Sharding
Complete Deployment of a System-Managed SDB

Back to trainings (Oracle)

Request the training

Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1

Course code:

Orcl_Db12NF

Duration:

5 Days, 40 Acad. Hours

Apply

Download pdf