Oracle Database 11g Administration II

Course:  OR11A2
Duration:  5 Days
Level:  II
Course Summary

Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of Database Administrators and Oracle technical support staff such as Unix/Linux/Windows administrators. Oracle Database 11g: Administration II class enables the DBA and other technical support to acquire and develop skills to effectively administer, monitor, backup and recover an Oracle11g Database. A great option of this class is that it can be customized to be delivered on either a Windows or Unix/Linux OS platform to suit the client's needs. The course will focus on Oracle RMAN , LogMiner, Oracle's latest Flashback technologies, and use of advanced Oracle Enterprise manager wizards for database recovery, transaction backout, database corruption detection and correction, the Fault Diagnosability Infrastructure and others.

« Hide The Details
Topics Covered In This Course

Managing Memory

  • About Manual Memory Management
  • Automatic Memory Management
  • MEMORY_TARGET
  • MEMORY_MAX_TARGET
  • SGA_TARGET
  • SGA_MAX_SIZE
  • WORKAREA_SIZE_POLICY and PGA_AGGREGATE_TARGET
  • Using EM &the Memory Advisors
  • Monitor IN MEMORY ACCESS MODE

Managing Storage &the Segment Advisor

  • Monitor Tablespaces
  • About Resumable Storage Management
  • Table Storage Management
  • PCTFREE Illustrated
  • Using the Segment Advisor
  • Using the Segment Shrink 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

  • 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 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 and Recovery Structures
  • Managing REDO Data
  • Is LOG_BUFFER Large Enough?
  • What V$LOG 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_FLASBACK()
  • 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 and Instance Recovery
  • PMON Process and 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 and 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 Lash 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
What You Can Expect

Oracle Database 11g: Administration II class enables the student participants to acquire and develop key skills to effectively Recover and Monitor an Oracle11g database . The participants will learn to configure the RMAN backup and recovery utility. In addition, they will be introduced to Oracle???s Enterprise manager Wizards for recovery diagnostics, recovery wizard, implementing flashback technologies wizards, the integrated LogMiner, and others. The Database Resource Manager will be discussed as a means for controlling resource utilization on database servers whose resources exceeds its capacity. Many exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

Who Should Take This Course

Database Administrators

Web Server Administrators

System Administrators

Data Center Support Engineers

Senior application designers and developers

Recommended Prerequisites

Oracle Database 11g: Administration I

Oracle SQL Tuning

Oracle Database: SQL Fundamentals

Training Style

Instructor Led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
OBIAD
Oracle BI 11g - System Administration
4 Days
I
Details
OR11A1
Oracle Database 11g Administration I
5 Days
I
Details
OR1212NF
Oracle12c Release 1 & 2 New Features For Administrators
5 Days
I
Details
OR12NEW
Oracle12c New Features For Administrators
5 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com