Overview
Course Description
Thank you for reading this post, don't forget to subscribe!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