You can develop advanced skills to effectively configure and  administer an Oracle Server Database

Course Description: 

 Through hands-on experience in administering an Oracle 10g Database you can understand a wide variety of advanced concepts to let you fully master administration of an Oracle Database.

 This course includes a thorough discussion of new Oracle10g automation features including Flashback Technologies, Automated Storage Management, Automated Tuning Tools and Automated Management Tools such as the new Scheduler.

You can learn how to: 

• Configure for globalization support, Secure the Oracle listener, Configure and use Recovery Manager, Identify and use diagnostic information, Recover your database, Use the new Automation Tools, Use the new Performance Tuning Tools, Manage database storage, Manage memory and other database resources, Use Scheduler to automate tasks, and Why to flashback a database 

Who Needs to Attend: 

Data Analysts, Database Administrators, Systems Administrators, Network Managers and Technical Support Personnel 

Prerequisites: 

Knowledge of SQL, the Introduction to Oracle 10g SQL and SQL* Plus  course or equivalent experience.  The Introduction to Oracle 10g PL/SQL  course or equivalent experience is highly recommended.

Course Labs:

Lab   1: Recovery Manager Configuration

Lab   2. Recovery Manager Backups

Lab   3: Database Recovery using RMAN

Lab   4: Flashback Database

Lab   5: Flashback For User Errors

Lab   6. Dealing With Block Corruption

Lab   7: Automated Management Tools

Lab   8: Using the Scheduler

Lab   9: Managing Storage

Lab 10: Scheduler

Lab 11: Listener Security

Lab 12: Diagnostic Sources

Lab 13: Oracle Auditing

Lab 14: Performance Tuning

Course Content:

Recovery Manager Configuration

• Parameters affecting RMAN

• Use of a Flashback Recovery Area

• The CONFIGURE Command

• Persistent Settings

• NOCATALOG / CATALOG mode

• Channel allocation

• Controlfile Autobackup

• Retention Policies

Recovery Manager Operations

• Using the BACKUP command

• Creating Backup Sets / Image Copies

• Parallelization

• Compressed Backups

• Whole Database Copying

• Incremental Backups

• Block Change Tracking

• RMAN Backup Monitoring

• REPORT and LIST commands

Non-Critical Loss Recovery

• Password and network files

• Read-Only tablespaces

• Temporary tablespaces

• Index tablespaces

• Redo log members / Control files

Database Recovery

• Recovering the control file

• Reasons for incomplete recovery

• Recovery after RESETLOGS

• Incomplete recovery using EM

• Incomplete recovery using RMAN

• Incomplete recovery using SQL

Flashback Database

• When to use

• Configuration and use

• Monitoring Flashback Database

• Using EM for Flashback Database

• Flash Recovery Area maintenance

• Flash Recovery Area monitoring

User Error Recovery

• The new Recycle Bin

• Flashback a dropped table using EM

• Querying dropped tables

• Flashback Versions Query

• Flashback Transaction Query

Block Corruption Management

• DBVERIFY and ANALYZE

• DBMS_REPAIR

• Block Media Recovery

• DBMS_BLOCK_CHECKING parameter

• Using RMAN for block corruption

Automatic Database Management

• Management and Advisory Framework

• Automatic Statistics Collection

• The Automated Workload Repository

• Database Advisors

• SQL Tuning Advisors

• SQL Access Advisors

• Active Session History (ASH)

• Automatic Statistics Collection

• Automatic Undo Retention

• Adjusting thresholds / managed metrics

Automatic Storage Management

• ASM Architecture

• ASM Initialization Parameters

• ASM filenames in SQL commands

• ASM tablespaces

• Disk groups / Failure groups

• ASM & Startup / Shutdown

• ASM Disk Group Administration

Globalization Support

• Timezones and Datetimes

• Language dependent behavior

• Locales and variants

• Case and accent insensitive sorts

• Linguistic sorting

• Querying GS configuration

Resource Management

• Resource Manager Configuration

• Resource Consumer Groups

• Resource Plans and Directives

• Directives for resource allocation

• Adaptive Consumer Group Mapping

• Enabling and switching plans

Scheduler

• Creating jobs and job classes

• Creating schedules and windows

• Scheduler programs

• Prioritizing jobs

• Scheduler component reuse

• Query Scheduler information

Storage Management

• Tuning Archiving

• Redo Log Size Advisor

• Segment Advisor

• Managing resumable operations

• Proactive tablespace management

• Table/Index size estimation

• Optimizing storage options

• Online index rebuilds

Listener Security

• Password authentication

• Securing EXTPROC

• Controlling access

Diagnostic Sources

• Alert Logs and Trace Files

• Enterprise Manager and Alerts

• Controlling trace file size

• Alert notification

Memory Management

• Memory Structures

• Automatic Shared Memory Management

• SGA configuration / SGA_TARGET

• Automatic PGA Memory Management

• The Memory Advisor

Performance Tuning

• Application Identification

• Enterprise Manager Tools

• SQL Tuning Advisor

• SQL Access Advisor

• DBMS_SQLTUNE

• DBMS_ADVISIOR

• Quick Tune

The Virtual Private Database

Unique Training Solutions for Unique Customers                                                                    12/6/2006