Oracle Administration Training: Oracle 11g Administration II

Course Number: ORC-206
Duration: 5 days
view class outline

Oracle 11g Administration II Training Overview

This advanced Oracle 11g administration training course teaches attendees advanced Oracle^® 11g administration skills necessary for enterprise environments.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=oracle.

Oracle 11g Administration II Training Prerequisites

Oracle 11g Administration I training or equivalent experience.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 11g Administration II Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 11g Administration II Training Objectives

All attendees will learn how to:

Explore automatic database management, monitoring and tuning facilities
Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability
Control resource utilization on database servers whose resource demand exceeds its capacity
Automate launching routine maintenance tasks and even application functions using the database Scheduler
Handle database corruption
Utilize diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data
Automate resumption of database operations even in the face of failures and errors
Set up user-managed and automatically managed backup strategies and database recovery operations
Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others
Explore Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager

Oracle 11g Administration II Training Outline

Managing Memory

About Manual Memory Management
Automatic Memory Management
Memory_Target
Memory_Max_Target
Sga_Target
Sga_Max_Size
Workarea_Size_Policy & Pga_Aggregate_Target
Using EM & The Memory Advisors
Monitor In Memory Access Mode

Managing Storage & The Segment Advisor

Monitor Tablespaces
About Resumable Space Allocation
Table Storage Management
Pctfree Illustrated
Use The Segment Advisor
Using The Shrink Space Option
Cascade To Dependent Objects
Optionally Call Delete_Task()

Managing Resources

Database Resource Manager Architecture
Consumer Groups
Resource Plans
Automatic & Adaptive Consumer Group Mapping
Activating Plans
Monitoring Resource Allocation
Explicit Consumer Group Switching

Automating Tasks With The Scheduler (Basic)

Scheduler Architecture
Rac Environment
Manage Programs
Manage Schedules
Manage Jobs

Automating Tasks With The Scheduler (Advanced)

Manage Job Classes
Manage Windows & Window Groups
Manage Chains
About Events & The Scheduler

Globalization

Globalization Settings
Nls_Lang
Nls_Language & Nls_Territory
Date & Time Localization
Linguistic Indexes
About Locale Builder

Diagnosing Database Problems

About The Fault Diagnosability Infrastructure
ADR Highlights From EM
Using The Alert Log
About The Trace Files
Database Instance Health Snapshot
Using The Support Workbench
Enable Oracle Configuration Manager

Automatic Storage Management

ASM & The Broader Database Architecture
Creating The ASM Instance
Administering The ASM Instance
Sysasm Super Administrator
ASM Storage Parameters
Using DBCA
Using ASMcmd
Configuring Databases For ASM Storage
DBCA
DBUA
ASM Migration Using EM

Recovery Concepts

About The Backup & Recovery Structures
Managing Redo Data
Is Log_Buffer Large Enough?
What V$Log Reveals
What V$Log_History Reveals
What V$Logfile Reveals
What V$Archived_Log Reveals
Managing Archived Redo Data
Archivelog Status
Creating A Foundation For Sound Recovery

Oracle Flashback Technology

About Flashback Technology
Flashback Query
Select...As Of Timestamp
Select...As Of SCN
Using Dbms_Flashback()
Configuring Undo Management For Flashback
Undo_Retention
Flashback Table
Flashback Drop
Flashback Versions Query
Flashback Transaction Query
Flashback Transaction Backout

Flashback Database

About Flashback Database
Configuring The Flash Recovery Area
More About Db_Recovery_File_Dest
Performing Database Flashback
Monitoring Flashback Performance
Flashback Database Considerations
Configure Flashback Data Archive

Instance Recovery

About Instance Recovery
Smon Process & Instance Recovery
Pmon Process & Process Recovery
Instance Recovery Parallelism
Changing Recovery_Parallelism
Mttr Advisor & Tuning Checkpoints
Log_Checkpoints_To_Alert
Redo Logfile Size Advisor
Fast-Start On-Demand Parallelism

Configuring RMAN

RMAN Architecture
RMAN Sample Backup Session
Launch & Use RMAN
Configure RMAN Settings
Allocate RMAN Channels

Backup With RMAN

About Backup File Types
Performing Full Backups
Performing Incremental Backups
Establishing A Backup Retention Policy
Generate Reports
Report Unrecoverable
Report Need Backup
List Incarnation
Validate Backup Data Integrity

RMAN Management With EM

Monitoring The Flash Recovery Area
The EM Interface To RMAN
Scheduling RMAN Backups
Using The Oracle-Suggested Backup Strategy
Manage Current Backups
Backup Reports
Manage Restore Points

User-Managed Recovery Operations

Recovery Concepts
Recover Temporary Tablespaces
Recover Read-Only Tablespaces
Recover Index Tablespaces
Recover Redo Log Group Member
Recreate The Password File

Recovery With RMAN

Complete Media Recovery
Incomplete Media Recovery
TSPITR
DBPITR
Recovery Using EM

Using The RMAN Recovery Catalog

Configuring The Recovery Catalog
Using A Virtual Private Catalog

Advanced RMAN Capabilities

Backup Set Encryption
RMAN Duplicate Database

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.