HOME
 

Oracle Database 11g Release 2 DBA - Part II

STL
Course summary
5 days
English
Nationwide
Company-Specific / In-House

Oracle Database 11g Release 2 DBA - Part II



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... This training course offers an overview of a complete Oracle backup and recovery solution. It will also demonstrate how to create a backup and recovery plan using RMAN. Resource Manager will also be used to carry out effective memory management and tune the database performance. The course will also show delegates how Scheduler can be used for task automation.

Suitability - Who should attend?



This five day course is suitable for IT professionals, database administrators and network support who need to do advanced database tasks. These include backup and recovery scenarios, database performance monitoring and management, and tuning.

Training Course Content



Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: BACKUP AND RECOVERY CONSIDERATIONS

Backup process as recommend by Oracle
Design and implement a backup and recovery process
Planning a backup methodology
Planning a Disaster Recovery Plan
Comparing backup methodologies
Testing a backup and recovery plan
Implementing a backup strategy
Implementing a recovery strategy
Validating the recovery strategy

Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES

Structure of backup and restore
Archives, Redo Logs and checkpoints
Multiplexing Control Files and Redo Logs
Recognising database failure

Session 3: MEMORY MANAGEMENT

Automating management of shared memory
Using PGA Memory Management
Automating Memory Management
Using the Memory Advisor
Advisors for allocating memory
Using the Data Dictionary for Memory Management

Session 4: USING ARCHIVELOG AND NOARCHIVELOG MODES

Overview of database archiving
Configuring database archive modes
Setting up multiple archival destinations
Setting up multiple ARCH processes
Using Data Dictionary Tables with archiving

Session 5: TROUBLESHOOTING UTILITIES

Synchronizing the database
Configuring automatic block corruption reports
Automatic Quarantine of Corrupt Redo Segments
Best practice to protect from data corruptions
Analyze Validate Structure
Overview of Automatic Diagnostic Repository (ADR)
Using the ADR Command Line Tool (ADRCI)
Using the Health Monitor to spot faults

Session 6: RECOVERY MANAGER OVERVIEW

Introduction to Recovery Manager
Structure and use of RMAN
Connecting to RMAN
Using RMAN to initiate and stop a database

Session 7: CREATE A RECOVERY CATALOG

Introduction to Recovery Catalog
Creating a Recovery Catalog
Working with the Flashback Recovery Area
Registering a database
Unregistering a database
Control File Information
Using the RESYNC CATALOG command
Working with Virtual Private Catalogs
Merging Catalogs
Backing up and recovering a catalog

Session 8: BACKING UP WITH RMAN

Allocating a channel
Using the Configure Channel command
Methods of backing up with RMAN
Overview of Recovery Manager Commands
Backing up with RMAN
Using the Backup command
Using the Copy command
Backing up file image copies
Understanding the difference between Full, Incremental and Cumulative Backups
Using Data Dictionary Tables

Session 9: MAINTAIN A RECOVERY CATALOG

Using the reset database command
Auditing backups and copies
Using OS commands to keep a backup inventory
Generating lists and reports
Configuration values
Verifying backup and copy integrity
Deleting backups
Dropping database and archival backups

Session 10: RESTORE AND RECOVER WITH RMAN

Introduction to Restore
The Restore Command
Using Noarchivelog mode to restore a database
Restoring and recovering databases with Archivelog mode
Overview of the Until Time and Until sequence
Restoring a Tablespace
Recovering a Tablespace
Recovering tempfiles automatically
Restoring a datafile
Recovering a datafile
Recovering datafiles not backed up
Recovering individual data blocks
Recovering lost Redo log groups
Re-creating Password Authentication files
Using incremental backups
Using the Switch command
The Data Recovery Advisor (DRA)
Restoring and Recovering the Database on to a New Host

Session 11: CREATE A DUPLICATE DATABASE WITH RMAN

Introduction to database duplication
Options for duplication
Creating duplicate database files
Implementing an auxiliary instance
Creating a duplicate database
Cloning a running database without a backup
Targetless database duplication

Session 12: MANAGE SPACE FOR THE DATABASE

Transport Tablespaces
Transport Databases

Session 13: MONITOR, TUNE RMAN

Introduction to Recovery Manager Tuning
Tuning RMAN for best performance
Synchronous and asynchronous I/O
Tuning performance of Instance Recovery
Overview of RMAN Messages
Diagnosing common RMAN faults
RMAN Detected Block Corruptions
Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Session 14: FLASHBACK

Overview of the Flashback database
Configuring the Flashback database
Monitoring the Flashback database
Calculating Flash Recovery Area Space Usage
Flashback Query
How to retrieve Row History with Flashback Versions Query
Auditing Transactions with Flashback Transactions Query
Flashback Table
Recovering dropped tables with Flashback Drop
The Recycle Bin
Recover Tables to a Point in Time with Flashback Table
Flashback Database
Flashback Restore Points
Flashback Transaction Backout

Session 15: ORACLE TOTAL RECALL

Introduction to Oracle Total Recall
Managing the Flashback archives
Flashback data archive and auditing
Usage of the flashback data archive

Session 16: AUTOMATE TASKS WITH THE SCHEDULER

Overview of Scheduler
Configuring Scheduler
Configuring access rights
Configuring Programs
Dropping Programs
Creating Schedules
Creating Jobs
Job Classes
Windows
Window Group
Logging and monitoring
Use Time Based, Event Based and Complex Schedules
Multi Destination Jobs

Session 17: MANAGE SPACE IN SEGMENTS

Monitoring a Tablespace
Segment Management Enhancements
Segment Advisor
Segment Space Estimation
Online Segment Shrink
Proactive Tablespace Management

Session 18: MANAGE SPACE IN BLOCKS

Free Space Management
Monitoring space
Compressing data

Session 19: MANAGE DATABASE PERFORMANCE

Overview of tuning methods
Configuring Statistic Preferences
Optimizer Statistics Collection
Maintaining Sessions And Services performance
Automatic Workload Repository (AWR)
Working with Automatic Database Replay

Session 20: DATABASE PERFORMANCE BY SQL TUNING

Overview of SQL Tuning
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer

Session 21: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT

Introduction to ASM
Creating an instance of ASM
The role of SYSASM
Configuring disk groups within ASM
ASM files
ASM Startup and Shutdown
ASM Disk Failure
ASM Data Dictionary Views
Using RMAN to migrate a database to ASM
Using the ASM Command Line Tool

Session 22: MANAGING RESOURCES WITH RESOURCE MANAGER

Introduction to Database Resource Manager
Creating Resource Plans
Creating Resource Consumer Groups
Creating Resource Plan Directives
Limiting CPU Utilization at the Database Level
Instance Caging
Control Resources via User Groups
Selecting an Instance Plan
Monitoring the Resource Manager
Data Dictionary Views

Expenses



Prices from £3000 (Guideline pricing). Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Oracle Database 11g Release 2 DBA - Part II.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Oracle Database 11g Release 2 DBA - Part II course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here