Oracle 12c Database Administration II

Course Description

Thank you for reading this post, don't forget to subscribe!

In this course, you will learn a wide variety of advanced concepts to let you fully master administration of an Oracle database. This course includes a thorough discussion of new Oracle 12c automation features including flashback technologies, automated storage management, automated tuning tools, and automated management tools (such as the new scheduler).

Audience Profile

• Data analysts
• Database administrators
• Systems administrators
• Network managers
• Technical support personnel

Prerequisites

• Oracle Database 12c: SQL I – Introduction
• Oracle 12c SQL & SQL PLUS Express Introduction

Learning Objectives

• Configure for globalization support.
• Secure the Oracle listener.
• Configure and use recovery manager.
• Identify and use diagnostic information.
• Recover your database.
• Flashback a database.
• Automation tools.
• Performance tuning tools.
• Manage database storage, memory, and other database resources.
• Use scheduler to automate tasks.
• Configure and use Automatic Storage Management (ASM)

Course Outline

Module 1: Recovery Manager Configuration
Lessons
• Parameters Affecting RMAN
• Use of a Flashback Recovery Area
• The CONFIGURE Command
• Persistent Settings
• NOCATALOG / CATALOG Mode
• Catalog Management / Virtual Catalog
• Channel Allocation
• Controlfile Autobackup
• Retention Policies
Lab: Recovery Manager Configuration

Module 2: Recovery Manager Operations
Lessons
• Using the BACKUP Command
• Creating Backup Sets / Image Copies
• Parallelization
• Compressed Backups
• Whole Database Copying / Cloning
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands
Lab: Recovery Manager Backups

Module 3: Non-Critical Loss Recovery
Lessons
• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files
Lab: Database Recovery using RMAN

Module 4: Database Recovery
Lessons
• Recovering the Control File
• Reasons for Incomplete Recovery
• Recovery after RESETLOGS
• Incomplete Recovery Using EM
• Incomplete Recovery Using RMAN
• Incomplete Recovery Using SQL
Lab: Flashback Database

Module 5: Flashback Database
Lessons
• When to Use
• Configuration and Use
• Monitoring Flashback Database
• Using EM for Flashback Database
• Flash Recovery Area Maintenance
• Flash Recovery Area Monitoring
Lab: Flashback for User Errors

Module 6: User Error Recovery
Lessons
• The New Recycle Bin
• Flashback a Dropped Table Using EM
• Querying Dropped Tables
• Flashback Versions Query
• Flashback Transaction Query
Lab: Dealing with Block Corruption

Module 7: Block Corruption Management
Lessons
• DBVERIFY and ANALYZE
• DBMS_REPAIR
• Block Media Recovery
• DBMS_BLOCK_CHECKING Parameter
• Using RMAN for Block Corruption
Lab: Automated Management Tools

Module 8: Automatic Databse Management
Lessons
• Management and Advisory Framework
• Automatic Statistics Collection
• The Automated Workload Repository
• Database Advisors
• SQL Tuning Advisors
• SQL Access Advisors
• Active Session History (ASH)
• Automatic Statistics Collection
• Automatic Undo Retention
• Adjusting Thresholds / Managed Metrics
Lab: Using the Scheduler

Module 9: Automatic Storage Management
Lessons
• ASM Architecture
• ASM Initialization Parameters
• ASM Filenames in SQL Commands
• ASM Tablespaces
• Disk Groups / Failure Groups
• ASM Startup/Shutdown / ASMCMD
• ASM Disk Group Administration
Lab: Managing Storage

Module 10: Globalization Support
Lessons
• Timezones and Datetimes
• Language Dependent Behavior
• Locales and Variants
• Case and Accent Insensitive Sorts
• Linguistic Sorting
• Querying GS Configuration
Lab: Scheduler

Module 11: Resource Management
Lessons
• Resource Manager Configuration
• Resource Consumer Groups
• Resource Plans and Directives
• Directives for Resource Allocation
• Adaptive Consumer Group Mapping
• Enabling and Switching Plans
Lab: Listener Security

Module 12: Scheduler
Lessons
• Creating Jobs and Job Classes
• Creating Schedules and Windows
• Scheduler Programs
• Prioritizing Jobs
• Scheduler Component Reuse
• Query Scheduler Information
Lab: Diagnostic Sources

Module 13: Storage Management
Lessons
• Tuning Archiving
• Redo Log Size Advisor
• Segment Advisor
• Managing Resumable Operations
• Proactive Tablespace Management
• Table/Index Size Estimation
• Optimizing Storage Options
• Online Index Rebuilds
Lab: Oracle Auditing

Module 14: Listener Security
Lessons
• Password Authentication
• Securing EXTPROC
• Controlling Access
Lab: Performance Tuning

Module 15: Diagnostic Sources
Lessons
• Alert Logs and Trace Files
• Enterprise Manager and Alerts
• Controlling Trace File Size
• Alert Notification

Module 16: Memory Management
Lessons
• Memory Structures
• Automatic Shared Memory Management
• SGA configuration / SGA_TARGET
• Automatic PGA Memory Management
• The Memory Advisor

Module 17: Performance Tuning
Lessons
• Application Identification
• Enterprise Manager Tools
• SQL Tuning Advisor
• SQL Access Advisor
• DBMS_SQLTUNE
• DBMS_ADVISIOR
• Quick Tune

Module 18: The Virtual Private Database
Lessons