Oracle 11g: Administration Workshop II

This lesson reviews the Oracle Database architecture with ASM and provides an overview of the technical environment for this course. In this way, core concepts and DBA tools are introduced.

Lessons:

• Describe the core concepts of the Oracle Database architecture with Automatic Storage Management (ASM)

• Use configuration and management DBA tools

• Describe the technical course environment

This lesson explains the configuring of an Oracle Database for recoverability through the use of RMAN, the FRA, retention policies, database archive modes, and the multiplexing of database archive logs.

Lessons:

• Invoke and configure Recovery Manager (RMAN)

• Specify a retention policy

• Configure your database in ARCHIVELOG mode

• Lab:

• Configure multiple archive log file destinations to increase availability

• Placing the database in ARCHIVELOG mode

• Configure the Fast Recovery Area (FRA

• Verifying that the FRA is configured

• Using RMAN to connect to the target database

This lesson describes the use of a recovery catalog in the management of database backups. Delegates will learn how to create, configure and maintain a RMAN recovery catalog.

Lessons:

• Contrast the usage of a recovery catalog with that of the control file for the RMAN repository

• Back up the recovery catalog

• Create and configure a recovery catalog

• Create a virtual private catalog

• Register a database in the recovery catalog

• Lab:

• Synchronize the recovery catalog

• Creating the RCAT recovery catalog instance with the dbca utility

• Use RMAN stored scripts

• Creating the Recovery catalog owner and granting privileges

• Registering the ORCL database

• Creating a recovery catalog in RMAN

• Backing up the RCAT recovery catalog

This lesson demonstrates the use of Enterprise Manager to apply configuration changes to the backup settings such as autobackup of database critical files, backup destinations, backup optimization, compression and encryption.

Lessons:

• Use Enterprise Manager to configure backup settings

• Create a compressed backup

• Enable control file autobackup

• Create an encrypted backup

• Configure backup destinations

• Lab:

• Allocate channels for tape destination

• Configuring RMAN persistent settings

• Configure backup optimization

This lesson demonstrates the use of RMAN in the creation of different types of database backups. It also teaches delegates how to maintain and report on backups.

Lessons:

• Create image file backups

• Report on and maintain backups

• Create a whole database backup

• Lab:

• Create a full database backup

• Taking an archival backup

• Enable fast incremental backup

• Enabling block change tracking

• Create duplex backup sets

• Recovering from a damaged block

• Back up a backup set

• Reporting on existing backups

• Create RMAN multi-section backup

• Backing up the control file

• Create an archival backup for long-term retention

This lesson explores the steps involved in performing recovery after the loss of control files and redo log groups.

Lessons:

• Describe the causes of file loss and determine the appropriate action

• Lab:

• Describe major recovery operations

• Use RMAN to create an image copy backup

• Back up and recover a control file

• Recovering from the Loss of a Data File

• Recover from a lost redo log group

• Recovering from the Loss of all Control Files

• Recovering from the Loss of a Redo Log Group

This lesson demonstrates the use of RMAN to perform complete recovery of critical and noncritical datafiles. Participants will also learn how to recover from different backup source types such as image copies and incremental backup sets.

Lessons:

• Perform complete recovery when a critical or noncritical data file is lost

• Recover using a backup control file

• Recover using incrementally updated backups

• Lab:

• Switch to image copies for fast recovery

• Use RMAN to recovering image copies

• Restore a database onto a new host

• Use RMAN to performing fast recovery

This lesson explores ways of tuning RMAN for best backup and restore performance as well as monitoring the progress of RMAN jobs.

Lessons:

• Monitor the progress of RMAN jobs

• Explain the effect of the following parameters on RMAN performance: MAXPIECESIZE, FILESPERSET, MAXOPENFILES

• Configure RMAN appropriately for asynchronous I/O

• Explain how the RMAN BACKUP DURATION option can cause backups to either execute faster or take longer, (freeing up resources for other processing)

• Configure RMAN multiplexing so as to keep tape drives streaming efficiently

• Lab:

• Evaluate the balance between speed of backup versus speed of recovery

• Monitoring RMAN jobs

• Using EM to monitor RMAN

This lesson explains how to detect and repair database corruption, set up diagnostic repositories and run health checks on an Oracle database.

Lessons:

• Detect and repair database corruption

• Run health checks

• Handle block corruption

• Lab:

• Set up Automatic Diagnostic Repository

• Discovering corruptions

• Repairing corruptions

This lesson describes how Oracle Flashback technology works. Participants will learn how to write and execute the different types of Flashback queries.

Lessons:

• Describe Flashback technology

• Use Flashback Transaction Query

• Perform Flashback Query

• Use Flashback Transaction

• Use Flashback Version Query

• Lab:

• Enable row movement on a table

• Querying a transaction

• Perform Flashback Table operations

• Performing Flashback Transaction backout

This lesson describes the implementation and usage of Oracle Total Recall as well as Flashback recycle bins.

Lessons:

• Describe and use Oracle Total Recall

• Describe and use flashback recycle bins

• Creating and enabling a Flashback  Data Archive (FDA)

• Restore dropped tables from the recycle bin

• Managing FDAs

• Manage space usage in the recycle bin

• Viewing metadata

• Query the recycle bin

• Lab:

• Using Total Recall

• Recycle bin activities (optional)

This lesson describes the Oracle Flashback Database feature and how to set up, monitor and perform Flashback Database operations.

 Lessons:

• Configure Flashback Database

• Lab:

• Perform Flashback Database operations

• Performing Flashback Database to undo unwanted transactions

• Monitor Flashback Database

• Monitoring the Flashback Database retention

• Determining the size of the flashback logs

This lesson explores the components found within the database instance and demonstrates ways of configuring manual or dynamic memory management of the instance SGA and PGA.

Lessons:

• Describe the memory components in the SGA

• Configure automatic PGA memory management

• Implement Automatic Memory Management

• Lab:

• Manually configure SGA parameters

• Diagnosing a memory allocation problem

• Enabling and implementing Automatic Memory Management

This lesson explains the tasks involved with the monitor and tuning of the database performance.

Lessons:

• Monitor the performance of sessions and services

• Lab:

• Describe the benefits of Database Replay

• Monitoring Top Services and Sessions

This lesson describes the use built in advisors to identify and tune specific SQL statements and workloads.

Lessons:

• Use the SQL Tuning Advisor to

• Use the SQL Access Advisor to tune a workload

• Identify SQL statements that are using the most resources

• Lab:

• Tune SQL statements that are using the most resource

• Using SQL Tuning Advisor

This lesson describes the management of database resources through the implementation of resource plans and consumer groups. It also describes how to configure and monitor the Database Resource Manager.

Lessons:

• Configure the Database Resource Manager

• Lab:

• Access and create resource plans

• Creating a resource consumer group

• Create consumer groups

• Specifying CPU resource allocation directives for consumer groups

• Specify directives for allocating resources to consumer groups

• Associating users with a resource consumer group

• Map consumer groups to plans

• Activating a resource plan

• Activate a resource plan

• Testing in SQL*Plus

• Monitor the Resource Manager

• Deactivating a resource plan

This lesson describes how to simplify database management through the proper use of the Scheduler.

Lessons:

• Simplify management tasks by using the Scheduler

• Describe Scheduler jobs on remote systems

• Create a job, program, and schedule

• Use advanced Scheduler concepts to prioritize jobs

• Monitor job execution

• Lab:

• Use a time-based or event-based schedule for executing Scheduler jobs

• Creating a job that runs a program outside the database

• Describe the use of windows, window groups, job classes, and consumer groups

• Creating a program and a schedule

• Use email notification

• Creating a job that uses a program and a schedule

• Use job chains to perform a series of related tasks

• Create a lightweight job

• Monitoring job runs

This lesson describes the use of different space management techniques such as automatic space management, the Segment Advisor and data compression.

Lessons:

• Describe how the Oracle database server automatically manages space

• Reclaim wasted space from tables and indexes by using the segment shrink functionality

• Save space by using compression

• Manage resumable space allocation

• Proactively monitor and manage tablespace space usage

• Lab:

• Describe segment creation in the Oracle database

• Using threshold alerts to proactively manage tablespaces

• Control deferred segment creation

• Using the Segment Advisor to shrink space

• Use the Segment Advisor

• Viewing alerts and alert history in SQL*Plus and Enterprise Manager

This lesson explains the concepts and usage of transportable databases and tablespaces.

Lessons:

• Describe the concepts and use of 4 KB-sector disks

• Lab:

• Use transportable tablespaces

• Viewing a demonstration on “Using 4 KB-sector disks”

• Describe the concepts of transportable databases

This lesson explores the need for and methods through which a database can be duplicated.

Lessons:

• List the purposes of creating a duplicate database

• Use an RMAN backup to duplicate a database

• Choose a technique for duplicating a database

• Duplicate a database based on a running instance

• Duplicate a database with RMAN

• Lab:

• Clone a database and use utilities to complete the setup of a functioning duplicated database