Oracle 12c Troubleshooting and Maintenance for Administrators

Overview

Course Description

In this course, you will learn how to troubleshoot and maintain an Oracle 12c database. This course is designed to equip the database administrator with essential maintenance and troubleshooting tools.

Audience Profile

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

Prerequisites

  • Oracle 12c SQL & SQL*PLUS Express Introduction
  • Oracle 12c PL/SQL Introduction

Learning Objectives

  • Oracle server architecture.
  • Start and stop an Oracle database.
  • Manage all Oracle file structures.
  • Manage security.
  • Perform appropriate backups.
  • Perform complete and incomplete recoveries.
  • Configure and use recovery manager.
  • Identify and use diagnostic information.
  • Flashback a database.
  • Use the new automation tools.
  • Use the new performance tuning tools.
  • Manage other database resources

Course Outline

Course Outline

Module 1: Basic Oracle Architecture
Lessons
• Architecture Overview
• Database Structures
• Process Structures
• Memory Structures – SGA and PGA
Lab: Architecture

Module 2: Starting and Stopping the Database
Lessons
• Connecting as a Privileged User
• Password File Authentication
• Starting a Database
• Shutting Down a Database
• Reading the Alert Log / Trace Files
• Quiescing the Database
• SPFILE / Parameter Management
Lab: Database Startup and Shutdown
Lab: Using and Managing SPFILES and Parameters

Module 3: Logical Components
Lessons
• Basic Definitions
• Blocks / Extents / Segments / Tablespaces
• Fragmentation / Deallocation
• Managing Undo Segments
• Automatic Undo Management
• Managing Sort Activity
• Managing Data Segments
• Managing Index Segments
• Monitoring Database Segments
• Tablespace Overview
• System Tablespace
• Types of Tablespaces
• Creating Additional Tablespaces
• Altering Tablespaces

Module 4: Oracle Database Files
Lessons
• Basic Structures of an Oracle RDBMS
• Data Files
• Redo Log Files / Archived Redo Logs
• Control Files
• Oracle-Managed Files (OMF)

Module 5: Users and Security
Lessons
• Managing Database Users
• System / Object Privileges
• Managing Roles / Profiles
• Resource and Password Management
Lab: Users and Security

Module 6: Physical NOARCHIVELOG Mode Backups
Lessons
• Oracle Database Backups
• Automatic Recovery Architecture
• NOARCHIVELOG / ARCHIVELOG Physical Backups
• Closed Backups
Lab: Advanced Memory Management
Lab: Oracle Database Files

Module 7: Configuring Archivelog Mode
Lessons
• Physical ARCHIVELOG Mode Backups
• Establishing Multiple Archiving Destinations
• Open backups in ARCHIVELOG Mode
• Controlfile Backup
Lab: Backup and Archivelog Mode

Module 8: Complete Recovery
Lessons
• Recovery Structures and Processes
• Recovery in NOARCHIVELOG and ARCHIVELOG Mode
Lab: Complete Recovery

Module 9: Incomplete Recovery
Lessons
• What is Incomplete Recovery?
• Recovering from Loss of Current Redo Log Files
Lab: Incomplete Recovery

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

Module 11: Recovery Manager Operations
Lessons
• Using the BACKUP Command
• Compressed Backups
• Whole Database Copying
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands
Lab: Recovery Manager Backups

Module 12: Non-Critical Loss Recovery
Lessons
• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files

Module 13: 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: Database Recovery using RMAN

Module 14: 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 Database

Module 15: User Error Recovery
Lessons
• The New Recycle Bin
• Flashback a Dropped Table
• Querying Dropped Tables
• Flashback Versions Query
• Flashback Transaction Query
Lab: Flashback for User Errors

Module 16: Block Corruption Management
Lessons
• DBVERIFY and ANALYZE
• DBMS_REPAIR
• Block Media Recovery
• DBMS_BLOCK_CHECKING
• Using RMAN for Block Corruption
Lab: Dealing With Block Corruption

Module 17: Diagnostic Sources
Lessons
• Alert Logs and Trace Files
• Enterprise Manager and Alerts
• Controlling Trace File Size
• Alert Notification
Lab: Automated Management Tools
Lab: Diagnostic Sources

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

Register for Course

Tuition
Available Registrations: Unlimited
The Tuition ticket is sold out. You can try another ticket or another date.

Cost

$2,650.00

Course Code

FRCORA-21

Course Duration

5

Instructions Method

Instructor Led
Category
REGISTER