Oracle Database 11g: Administration II Course

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise.

Certification Examination
This course along with its prerequisites cover information necessary to complete the certification test Exam #1Z1-053 Oracle Database 11g: Administration II.

This course is designed for individuals who are Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful.

This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.

Upon completion of this course, the participant will be able to:

> Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
> Using 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.
> Controlling resource utilization on database servers whose resource demand exceeds its capacity.
> Automating launching routine maintenance tasks and even application functions using the database Scheduler.
> Handling database corruption.
> Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data.
> Automatic resumption of database operations even in the face of failures and errors.
> 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.
> Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager.

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