Students access recorded, multi-media formatted video sessions of each class lecture. These versatile, multi-media classes show the instructor, any program that is displayed on the instructor’s computer, the instructor’s notes and real-time digital markups, and sound all together in a single presentation!

Students can access the class sessions by streaming on the Internet as often as they like and have the ability to pause, rewind and forward to key sections of interest.

The instructor will be constantly monitoring the class portal and available to answer questions, provide feedback, and other guidance via the portal, community message board, internet chat, and internal class email system. The instructor will post video lectures on a weekly basis for the students to view and perform lab and homework activities. The instructor will host live office hours each week via conference call, chat, and/or video conference.

Registration is on an open, rolling basis; register when you want up to two weeks before the end date. The course requirements must be completed by the end date.

Topics Covered:

• Introduction
  Grid Computing
  Oracle Enterprise Manager 10g Product Controls Database Architecture Review
• Configuring Recovery Manager
  Recovery Manager Features and Components Using a Flash Recovery Area with RMAN Configuring RMAN Control File Autobackups Retention Policies and Channel Allocation Using Recovery Manager to connect to a target database in default NOCATALOG mode Displaying the current RMAN configuration settings Altering the backup retention policy for a database
• Using Recovery Manager
  RMAN Command Overview
  Parallelization of Backup Sets
  Compressed Backups
  Image Copy
  Whole Database and Incremental Backups
  LIST and REPORT commands
  Enable ARCHIVELOG mode for the database
  Use Recovery Manager
• Oracle Secure Backup
  Installation and Configuration
  Implement the Oracle suggested strategy
  RMAN and Oracle Secure Backup
  Database and File-system files backup/restore to tape Using obtool and web interface to configure Oracle Secure Backup devices
  (CLI/GUI)
  Configuring EM for Oracle Secure Backup and test backup to tape (EM) Using RMAN to backup your database to tape (CLI) Using the OB Web tool to backup file system files
• Recovering from Non-critical Losses
  Recovery of Non-Critical Files
  Creating New Temporary Tablespace
  Recreating Redo Log Files, Index Tablespaces, and Indexes Read-Only Tablespace Recovery Authentication Methods for Database Administrators Loss of Password Authentication File Creating a new temporary tablespace Altering the default temporary tablespace for a database
• Incomplete Recovery
  Recovery Steps
  Server and User Managed Recovery commands Recovering a Control File Autobackup Creating a New Control File Incomplete Recovery Overview Incomplete Recovery Best Practices Simplified Recovery Through RESETLOGS Point-in-time recovery using RMAN
• Flashback
  Flashback Database Architecture
  Configuring and Monitoring Flashback Database Backing Up the Flash Recovery Area Using V$FLASH_RECOVERY_AREA_USAGE Flashback Database Considerations Using the Flashback Database RMAN interface Using Flashback Database EM Interface Managing and monitoring Flashback Database operations
• Dealing with Database Corruption
  Block Corruption Symptoms: ORA-1578
  DBVERIFY Utility and the ANALYZE command Initialization parameter DB_BLOCK_CHECKING Segment Metadata Dump and Verification Using Flashback for Logical Corruption and using DBMS_REPAIR Block Media Recovery RMAN BMR Interface Dumping and Verifying Segment Metadata
• Monitoring and Managing Memory
  Oracle Memory Structures
  Automatic Shared Memory Management
  SGA Tuning Principles
  Database Control and Automatic Shared Memory Management Behavior of Auto-Tuned and Manual SGA Parameters Resizing SGA_TARGET PGA Management Resources Using the Memory Advisor
• Automatic Performance Management
  Identifying Tunable Components
  Oracle Wait Events and System Statistics Troubleshooting and Tuning Views Direct Attach to SGA for Statistic Collection Workload Repository Advisory Framework ADDM Scenarios and Usage Tips Using the SQL Tuning and SQL Access Advisor
• Monitoring and Managing Storage I
  Database Storage Structures
  Space Management Overview
  Oracle-Managed Files (OMF)
  Row Chaining and Migrating
  Proactive Tablespace Monitoring
  Managing Resumable Space Allocation
  SYSAUX Tablespace
  Monitoring table and index space usage
• Monitoring and Managing Storage II
  Automatic Undo Management
  Redo Log Files
  Table Types
  Partitioned Tables
  Index-Organized Tables (IOT)
  Managing index space with SQL
  Configure optimal redo log file size
  View "Automatic Tuning of Undo Retention"
• Automatic Storage Management
  ASM General Architecture and Functionalities Dynamic Performance View Additions Managing an ASM Instance ASM Disk Groups Using asmcmd Command Line Migrating Your Database to ASM Storage Creating an ASM instance in a separate Oracle Home Migrating a tablespace to use ASM storage
• VLDB Support
  Creating Bigfile Tablespaces
  Packages and data dictionary changes to support VLDB Creating and maintaining temporary tablespace groups (TTG) Partitioning and Partitioned Indexes Skipping unusable indexes Creating and using hash-partitioned global indexes DML Error Logging Interpreting Bigfile ROWIDs
• Managing Resources
  Database Resource Manager Concepts and Configuration Creating a New Resource Plan Active Session Pool Mechanism Maximum Estimated Execution Time Creating a Complex Plan Administering and Monitoring Resource Manager Resource Plan Directives Creating Resource Consumer Groups
• Automating Tasks with the Scheduler
  Scheduler Concepts
  Creating a Job Class and a Window
  Managing Jobs, Programs, Chains, Events, Schedules, priority Viewing and Purging Job Logs Creating a program and a schedule Creating a job that uses a program and a schedule Altering the program and schedule for the job and observing the behavior change of the job Monitoring job runs
• Database Security
  Virtual Private Database: Overview
  Creating a Column-Level Policy
  Writing a Policy Function
  Policy Types
  Column level VPD with column masking
  Transparent Data Encryption
  Setting the listener password
  Implement VPD
• Data Movement
  External Tables Concepts
  Creating a Directory object and External Table Data Pump Transport Database RMAN CONVERT DATABASE Command Transport Tablespace Create a Directory Object Create a Temporary Table
• Using Globalization Support
  Globalization Support Features
  Encoding Schemes
  Database Character Sets and National Character Sets Specifying Language-Dependent Behavior Locale Variants Using Linguistic Comparison and Sorting Data Conversion Between Client and Server Character Sets Determining the Default NLS Settings
• Workshop
  Workshop Methodology, requirements, and setup Scenario 1: Database performance Scenario 2: Finding and Tuning Inefficient SQL Scenario 3: SGA Management - REDO Scenario 4: Running out of Undo Space Scenario 5: Missing datafile Scenario 6: Managing space in a tablespace - REDO Scenario 7:
  Missing TEMP data file

Benefits:
The University of Colorado at Boulder has partnered with Oracle Corporation to bring you the very best in training and development. This unique partnership combines the exemplary education program of the University of Colorado with the hands-on expertise of Oracle Corporation. Some of the benefits of taking an Oracle course with our program include:

• Students will learn material that help prepare them for the Oracle certification exam
• Students receive exclusive supplementary Oracle University training workbooks
• Students receive a 50% discount on selected Oracle certification exam practice test software
• Students receive a 25% discount on Oracle certification exams
• Free membership to the Oracle Technology Network: The definitive source for Oracle technical information when developing for the Internet. An online community with access to free software, OTN-sponsored Internet developer conferences, and discussion group

• Use RMAN to create and manage backup sets and image copies
• Recover the database to a previous point in time
• Use Oracle Secure Backup to backup and recover a database
• Use Oracle's Flashback technology to recover your database
• Detect block corruptions and take appropriate measures to correct them Use the various Database advisors and views to monitor and improve database performance
• Control database resource usage with the Resource Manager
• Simplify management tasks by using the Scheduler Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions
• Administer a VLDB
• Implement a secure database Transport data across platforms

Not Required

To view the lectures online, you will need at least Internet Explorer 7, or FireFox 2, or Google Reader at http://google.com/reader.