Information Technology

Oracle 19c Database Administration II (DBA II) (TTOR20619)

Instructor-Led 27 Agenda

Description

Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases.

Course Overview

Course Objective

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore: Creating CDBs and Regular PDBs Managing CDBs and PDBs Backup and Duplicate Upgrading and Transporting CDBs and Regular PDBs Backup Strategies and Terminology Restore and Recovery Concepts Using Flashback Technologies Duplicating a Database Installing Grid Infrastructure and Oracle Database Patching Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Using General Overall Database Enhancements Monitoring and Tuning Database Performance Managing Application PDBs Managing Security in Multitenant databases Recovery and Flashback Configuring and Using RMAN Diagnosing Failures Performing Recovery Transporting Data RMAN Troubleshooting and Tuning Creating an Oracle Database by using DBCA Oracle Restart Upgrading the Oracle Database Installing Grid Infrastructure for a Standalone server Using Availability Enhancements Tuning SQL Statements

Who Should Attend

This hands-on course is geared for experienced DBAs with basic Oracle 19c skills.

Creating CDBs and Regular PDBs Lesson Id 1

Creating CDBs and Regular PDBs

Manage CDBs and PDBs Lesson Id 2

Manage CDBs and PDBs

Backup and Duplicate Lesson Id 3

Backup and Duplicate

Upgrading and Transporting CDBs and Regular PDBs Lesson Id 4

Upgrading and Transporting CDBs and Regular PDBs

Backup Strategies and Terminology Lesson Id 5

Backup Strategies and Terminology

Restore and Recovery Concepts Lesson Id 6

Restore and Recovery Concepts

Using Flashback Technologies Lesson Id 7

Using Flashback Technologies

Duplicating a Database Lesson Id 8

Duplicating a Database

Install Grid Infrastructure and Oracle Database Lesson Id 9

Install Grid Infrastructure and Oracle Database

Patching Grid Infrastructure and Oracle Database Lesson Id 10

Patching Grid Infrastructure and Oracle Database

Upgrading to Oracle Grid Infrastructure Lesson Id 11

Upgrading to Oracle Grid Infrastructure

Using General Overall Database Enhancements Lesson Id 12

Using General Overall Database Enhancements

Monitoring and Tuning Database Performance Lesson Id 13

Monitoring and Tuning Database Performance

Manage Application PDBs Lesson Id 14

Manage Application PDBs

Manage Security in Multitenant databases Lesson Id 15

Manage Security in Multitenant databases

Recovery and Flashback Lesson Id 16

Recovery and Flashback

Configuring and Using RMAN Lesson Id 17

Configuring and Using RMAN

Diagnosing Failures Lesson Id 18

Diagnosing Failures

Performing Recovery Lesson Id 19

Performing Recovery

Transporting Data Lesson Id 20

Transporting Data

RMAN Troubleshooting and Tuning Lesson Id 21

RMAN Troubleshooting and Tuning

Creating an Oracle Database by using DBCA Lesson Id 22

Creating an Oracle Database by using DBCA

Oracle Restart Lesson Id 23

Oracle Restart

Upgrade the Oracle Database Lesson Id 24

Upgrade the Oracle Database

Install Grid Infrastructure for a Standalone server Lesson Id 25

Install Grid Infrastructure for a Standalone server

Using Availability Enhancements Lesson Id 26

Using Availability Enhancements

Tuning SQL Statements Lesson Id 27

Tuning SQL Statements

Lesson Id	Title	Description
1	Creating CDBs and Regular PDBs	Configure and create a CDB<br />Create a new PDB from the CDB seed<br />Explore the structure of PDBs
2	Manage CDBs and PDBs	Manage PDB service names and connections<br />Manage startup, shutdown and availability of CDBs and PDBs<br />Change the different modes and settings of PDBs<br />Evaluate the impact of parameter value changes<br />Performance management in CDBs and PDBs<br />Control CDB and PDB resource usage with the Oracle Resource Manager
3	Backup and Duplicate	Perform Backup and Recover CDBs and PDBs<br />Duplicate an active PDB<br />Duplicate a Database
4	Upgrading and Transporting CDBs and Regular PDBs	Upgrade an Oracle Database<br />Transport Data
5	Backup Strategies and Terminology	Perform Full and Incremental Backups and Recoveries<br />Compress and Encrypt RMAN Backups<br />Use a media manager<br />Create multi-section backups of exceptionally large files<br />Create duplexed backup sets<br />Create archival backups<br />Backup of recovery files<br />Backup non database files<br />Back up ASM meta data
6	Restore and Recovery Concepts	Employ the best Oracle Database recovery technology for your failure situation<br />Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
7	Using Flashback Technologies	Configure your Database to support Flashback<br />Perform flashback operations
8	Duplicating a Database	Duplicate Databases
9	Install Grid Infrastructure and Oracle Database	Install Grid Infrastructure for a Standalone server<br />Install Oracle Database software
10	Patching Grid Infrastructure and Oracle Database	Patch Grid Infrastructure and Oracle Database
11	Upgrading to Oracle Grid Infrastructure	Upgrade Oracle Grid Infrastructure
12	Using General Overall Database Enhancements	Install Oracle Database software<br />Create, Delete and Configure Databases using DBCA<br />Creating CDBs and Regular PDBs<br />Use Miscellaneous 19c New Features
13	Monitoring and Tuning Database Performance	Managing Memory Components<br />Understanding the Automatic Workload Repository (AWR)<br />Understanding the Advisory Framework<br />Monitoring Wait Events, Sessions, and Services<br />Managing Metric Thresholds and Alerts<br />Understanding and Using the Performance Tuning Methodology<br />Performing Performance Planning<br />Understanding the Automatic<br />Database Diagnostic Monitor (ADDM)
14	Manage Application PDBs	Explain the purpose of application root and application seed<br />Define and create application PDBs<br />Install, upgrade and Patch applications <br />Create and administer Application PDBS<br />Clone PDBs and Application containers<br />Plug and unplug operations with PDBs and application containers<br />Comparing Local Undo Mode and Shared Undo Mode
15	Manage Security in Multitenant databases	Manage Security in Multitenant databases<br />Manage PDB lockdown profiles<br />Audit Users in CDBs and PDBs<br />Manage other types of policies in application containers
16	Recovery and Flashback	Restore and Recovering Databases with RMAN<br />Perform CDB and PDB flashback
17	Configuring and Using RMAN	Configure RMAN and the Database for Recoverability<br />Configure and Using an RMAN recovery catalog
18	Diagnosing Failures	Detect and repair database and database block corruption<br />Diagnosing Database Issues
19	Performing Recovery	Restore and Recovering Databases with RMAN<br />Perform Non RMAN database recovery
20	Transporting Data	Transport Data
21	RMAN Troubleshooting and Tuning	Interpret the RMAN message output<br />Diagnose RMAN performance issues
22	Creating an Oracle Database by using DBCA	Create, Delete and Configure<br />Databases using DBCA
23	Oracle Restart	Configure and use Oracle Restart to manage components
24	Upgrade the Oracle Database	Plan for Upgrading an Oracle Database<br />Upgrade an Oracle Database<br />Perform Post-Upgrade tasks
25	Install Grid Infrastructure for a Standalone server	Rapid Home Provisioning
26	Using Availability Enhancements	Use an RMAN recovery catalog<br />Use Flashback Database
27	Tuning SQL Statements	Understanding the Oracle Optimizer<br />Using the SQL Tuning Advisor<br />Managing Optimizer Statistics<br />Using the SQL Access Advisor<br />Understanding the SQL Tuning Process