Oracle Database 11g Administration Workshop II

Day 1

  • Lesson 1 : Database Architecture and ASM
  • Lesson 2 : Configuring for Recoverability
  • Lesson 3 : Using the RMAN Recovery Catalog
  • Lesson 4 : Configuring Backup Specifications

Day 2

  • Lesson 5 : Using RMAN to Create Backups
  • Lesson 6 : Performing User-Managed Backup and Recovery
  • Lesson 7 : Using RMAN to Perform Recovery
  • Lesson 8 : Using RMAN to Duplicate a Database

Day 3

  • Lesson 9 : Performing Tablespace Point-in-Time Recovery
  • Lesson 10 : Monitoring and Tuning RMAN
  • Lesson 11 : Using Flashback Technology
  • Lesson 12 : Additional Flashback Operations

Day 4

  • Lesson 13 : Diagnosing the Database
  • Lesson 14 : Managing Memory
  • Lesson 15 : Managing Database Performance
  • Lesson 16 : Space Management

Day 5

  • Lesson 17 : Managing Resources
  • Lesson 18 : Automating Tasks with the Scheduler
  • Lesson 19 : Administering the Scheduler
  • Lesson 20 : Globalization

Lesson 1 : Database Architecture and ASM

  • Describe the Oracle Database architecture
  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM disk groups

Lesson 2 : Configuring for Recoverability

  • Invoke RMAN and set and list simple configurations
  • Configure your database in ARCHIVELOG mode
  • Configure multiple archive log file destinations to increase availability
  • Specify a retention policy
  • Configure the Flash Recovery Area
  • Describe the benefits of using the Flash Recovery Area

Lesson 3 : Using the RMAN Recovery Catalog

  • Contrast the usage of a recovery catalog with that of the control file for the RMAN repository
  • Create and configure a recovery catalog
  • Register a database in the recovery catalog
  • Synchronize the recovery catalog
  • Use RMAN stored scripts
  • Back up the recovery catalog
  • Create a virtual private catalog

Lesson 4 : Configuring Backup Specifications

  • Use Enterprise Manager to configure backup settings
  • Enable control file autobackup
  • Allocate channels to use in backing up
  • Configure backup optimization

Lesson 5 : Using RMAN to Create Backups

  • Create image file backups
  • Create a whole database backup
  • Create a full database backup
  • Enable fast incremental backup
  • Create duplex backup sets
  • Back up a backup set
  • Create an archival backup for long-term retention
  • Create a multisection backup
  • Create a compressed backup
  • Create an encrypted backup
  • Report on and maintain backups

Lesson 6 : Performing User-Managed Backup and Recovery

  • Describe the difference between user-managed and server-managed backup and recovery
  • Manually back up a data file, tablespace, and database
  • Back up and recover a control file
  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Recover from a lost TEMP file
  • Recover from a lost redo log group

Lesson 7 : Using RMAN to Perform Recovery

  • Perform complete recovery when a critical or noncritical data file is lost
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file

Lesson 8 : Using RMAN to Duplicate a Database

  • List the purposes of creating a duplicate database
  • List the methods of duplicating a database
  • Duplicate a database using RMAN Use an RMAN backup to duplicate a database
  • Duplicate a database based on a running instance

Lesson 9 : Performing Tablespace Point-in-Time Recovery

  • List what operations occur when you perform tablespace point-in-time recovery (TSPITR)
  • Define the terminology used with TSPITR
  • Identify the circumstances where TSPITR is a good solution
  • Determine the correct target time for the point-in-time recovery
  • Identify those situations where TSPITR cannot be used, and how to work around them
  • Perform automated TSPITR

Lesson 10 : Monitoring and Tuning RMAN

  • Monitor the progress of RMAN jobs
  • Configure RMAN appropriately for asynchronous I/O
  • Configure RMAN multiplexing so as to keep tape drives streaming efficiently
  • Evaluate the balance between speed of backup versus speed of recovery
  • Explain the effect of the following parameters on RMAN performance: MAXPIECESIZE, FILESPERSET, MAXOPENFILES
  • Explain how the RMAN BACKUP DURATION option can cause backups to either execute faster or take longer, (freeing up resources for other processing)

Lesson 11 : Using Flashback Technology

  • Query the recycle bin
  • Restore dropped tables from the recycle bin
  • Perform Flashback Query
  • Use Flashback Version Query
  • Use Flashback Transaction Query
  • Use Flashback Transaction

Lesson 12 : Additional Flashback Operations

  • Enable row movement on a table
  • Perform Flashback Table operations
  • Configure Flashback Database
  • Perform Flashback Database operations
  • Monitor Flashback Database
  • Set up and use a Flashback Data Archive

Lesson 13 : Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Use and monitor Support Workbench
  • Run health checks
  • Identify the causes of database corruption:
    • Hardware
    • Software
  • Detect and repair database corruption

Lesson 14 : Managing Memory

  • Describe the memory components in the SGA
  • Implement Automatic Memory Management
  • Manually configure SGA parameters
  • Configure automatic PGA memory management

Lesson 15 : Managing Database Performance

  • Monitor the performance of sessions and services
  • Use the SQL Tuning Advisor to:
    • Identify SQL statements that are using the most resources
    • Tune SQL statements that are using the most resources
  • Use the SQL Access Advisor to tune a workload
  • Describe the benefits of Database Replay

Lesson 16 : Space Management

  • Describe how the Oracle database server automatically manages space
  • Proactively monitor and manage tablespace space usage
  • Use the Segment Advisor
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Manage resumable space allocation
  • Describe the concepts of transportable tablespaces and databases

Lesson 17 : Managing Resources

  • Configure the Database Resource Manager
  • Access and create resource plans
  • Create consumer groups
  • Specify directives for allocating resources to consumer groups
  • Map consumer groups to plans
  • Activate a resource plan
  • Monitor the Resource Manager

Lesson 18 : Automating Tasks with the Scheduler

  • Simplify management tasks by using the Scheduler
  • Create a job, program, and schedule
  • Monitor job execution
  • Use a time-based or event-based schedule for executing Scheduler jobs

Lesson 19 : Administering the Scheduler

  • Incorporate advanced Scheduler concepts
    • Windows
    • Window groups
    • Job classes
    • Consumer groups
  • Use job chains to perform a series of related tasks
  • Use advanced Scheduler concepts to prioritize jobs

Lesson 20 : Globalization

  • Determine a correct database character set that meets your business requirements
  • Obtain globalization support configuration information
  • Customize language-dependent behavior for the database and individual sessions
  • Specify different linguistic sorts for queries
  • Retrieve data that matches a search string ignoring case or accent differences

In-house Price for 5 days

  • 60,000 baht(THB) : Economic Class : 1 - 5 people
  • 85,000 baht(THB) : Small Class : 6 - 10 people
  • 115,000 baht(THB) : Medium Class : 11 - 20 people
  • 145,000 baht(THB) : Large Class : 21 - 30 people
  • All prices exclude VAT 7 %
  • Public price : 20,000 baht

Printable Version ดาวน์โหลดหน้านี้ >>