Oracle Database 10g Administration II Study Guide

1-4188-1108-4 © 2006 Publish date: December 13, 2005

Buy Now: $249.99

Course ID: oracle-database-10g-admin-ii-sg

Recovery from failure is a challenging task that many database administrators must face, especially when the loss of data must be avoided. This Oracle Database 10g Administration II study guide shows you standard failure scenarios and gives you the very best recovery strategies for each scenario. You'll learn strategies for on-line backups, strategies for both complete and incomplete recoveries, how to work with media recovery versus flashback database recovery and much more by choosing this guide from our selection of Oracle computer training books.

The Oracle Database 10g Administration II courseware contains extensive exercises that allow you to simulate failures and perform actual data recovery steps for yourself. In addition, this course discusses many of the new technologies from Oracle including Database Scheduler, Flashback operations, ASM (Automatic Storage Management), and more.

The Oracle Database 10g Administration II courseware comes loaded with in-depth conceptual diagrams, detailed exercises, complete solutions, and hundreds of actual code examples. You'll learn about Oracle flashback technology, resource management, task automation, globalization support objectives, database corruption, diagnostic sources, securing Oracle Listener, monitoring and managing memory and storage, redo log storage management, monitoring instance recovery, flashback databases, RMAN, non-critical recovery operations, database recovery techniques, and Automatic Storage Management.

Course Contents

An overview of Oracle flashback technology

• Understanding flashback technology
• Flashback queries
• Select commands
• Flashback tables
• Versions queries
• Transactions queries
• Understanding guarantee undo retention

Resource management

• The architecture of database resource manager
• Working with consumer groups
• Working with resource plans
• Automatic and adaptive consumer group mapping
• How to enable and monitor the resource manager
• Consumer group switching

Basic automation of tasks using database scheduler

• Scheduler's architecture
• Managing programs
• Managing schedules
• Managing jobs

Advanced automation of tasks using the database scheduler

• Managing job classes
• Managing windows and window groups
• Managing chains
• Understanding events and the scheduler

Globalization support objectives

• Globalization settings
• NLS language and NLS territory
• Date and time localization
• Linguistic
• Working with indexes
• Understanding locale builder

Working with database corruption

• Understanding database corruption
• Using "DB_block_checksum"
• Analyzing and validating structure
• DBverify
• Using "DBMS_repair()"

Diagnostic sources

• Trace and alert files
• Diagnostic highlights
• How to configure the alert log
• How to manage policies

How to secure the Oracle Listener

• How to manage and monitor the Listener
• Securing the listener
• Securing external procedure calls

Monitoring and managing memory

• Working with automatic shared memory
• Working with EM and memory advisors
• Monitoring using memory access mode

Monitoring and managing storage

• Understanding space allocation
• Table management
• Working with the segment advisor

Redo log storage management and monitoring instance recovery

• understanding redo data
• How to tune redo writing and archiving
• Instance recovery
• Working with log checkpoints

Flashback database

• Understanding flashback databases
• How to configure flash recovery areas
• How to perform database flashback
• How to monitor flashback performance
• Flashback database considerations

Configuring RMAN

• An overview of database backup and recovery structures
• The RMAN architecture
• Launching and using RMAN
• Configuring RMAN
• How to allocate RMAN channels

Backup with RMAN

• Understanding backup file types
• How to perform full backups
• How to perform incremental backups
• Creating backup retention policies
• Generating catalog reports
• Unrecoverable reporting
• Need backup reports
• Report schema
• List incarnation

RMAN backup with EM

• How to monitor flash recovery areas
• Understanding EM and RMAN
• How to schedule RMAN backups
• Managing current backups
• Viewing backup reports
• Managing restore points

An overview of non-critical recovery operations

• Understanding recovery process
• Recovering temporary tablespaces
• Recovering read-only tablespaces
• Recovery
• Working with index tablespaces
• Recovering redo log group members
• Recreating password files

Options for database recovery

• Recovery of control files
• Complete media recoveries
• Incomplete media recoveries
• How to perform block media recoveries
• Performing recoveries with EM

An overview of ASM (Automatic Storage Management)

• ASM and broader database architectures
• Defining ASM instances
• How to configure storage in the ASM instance