Oracle Database 10g: Administration Workshop II

5 Day Course
Hands On
Official Oracle Curriculum
Code OC10GDBA2

This course has been retired. Please view currently available Oracle 12c Training Courses.

Modules

Hide all

Introduction (2 topics)

  • Grid Computing
  • Oracle Enterprise Manager 10g Product Controls

Configuring Recovery Manager (1 topic)

  • Recovery Manager Features and Components

Using Recovery Manager (7 topics)

  • 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 (8 topics)

  • 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 (9 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (7 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (7 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • 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

Prerequisites

- Knowledge of basic database administration - Oracle Database 10g: Administration Workshop I Release 2

Sections