CONTENTS AT A GLANCE
1 Database Architecture and ASM
2 Configuring Database Recoverability
3 Creating and Maintaining an RMAN Catalog
5 Recovering Using RMAN Backups
6 User-Managed Backup and Recovery
9 Configuring and Using Flashback
10 Memory Management Techniques
11 Using Database Tuning Advisors
12 Disk Space and Resource Management
13 Configuring Database Diagnostics
14 Using the Scheduler for Task Automation
CONTENTS
1 Database Architecture and ASM
Understanding Database Architecture and ASM
Oracle Logical Storage Structures
Oracle Physical Storage Structures
Exercise 1-1 Find New ASM-related Processes in ASM and RDBMS Instances
Set Up Initialization Parameter Files for ASM and Database Instances
Exercise 1-2 Query Disk Groups and Available Raw Devices
Start Up and Shut Down ASM Instances
Exercise 1-3 Stop ASM Instance with Active Connections
Disk Group Mirroring and Failure Groups
Disk Group Dynamic Rebalancing
Enterprise Manager Database Control and ASM Disk Groups
Exercise 1-4 Use the asmcmd Utility to Create a Backup of the SPFILE
2 Configuring Database Recoverability
Configuring for Database Recoverability
Configure Multiple Archive Log File Destinations to Increase Availability
Leveraging Multiple Archive Destinations
Exercise 2-1 Identify the Archive Log File Destinations
Define, Apply, and Use a Retention Policy
Exercise 2-2 Query and Change the Retention Policy
Configure the Flash Recovery Area
Exercise 2-3 Query the Location, Contents, and Size of the Flash Recovery Area
3 Creating and Maintaining an RMAN Catalog
Identify Situations that Require RMAN Recovery Catalog
Using the Control File for RMAN Metadata
Using a Recovery Catalog for RMAN Metadata
Create and Configure a Recovery Catalog
Configure the Recovery Catalog Database
Create the Recovery Catalog Owner
Synchronize the Recovery Catalog
Changing the DBID of a Database
Cataloging Additional Backup Files
Exercise 3-1 Cataloging Additional Backup Files
Manually Resynchronize the Recovery Catalog
Create and Use RMAN Stored Scripts
Exercise 3-2 Creating a Parameterized Stored Script
Retrieving RMAN Stored Script Metadata
Backing Up the Recovery Catalog
Recovering from a Lost Recovery Catalog
Exporting and Importing the Recovery Catalog
Upgrading the Recovery Catalog
Create and Use a Virtual Private Catalog
Understanding Virtual Private Catalogs
Creating and Managing a Virtual Private Catalog
Allocate Channels to Use in Backing Up
Exercise 4-1 Create a Compressed Backupset
Create a Whole Database Backup
Exercise 4-2 Perform a Full Backup of Two Tablespaces
Enable Fast Incremental Backup
Understanding Block Change Tracking
Enabling Fast Incremental Backup
Exercise 4-3 Relocate the Block Change Tracking File
Monitoring Block Change Tracking
Create Duplex Backup and Back Up Backupsets
Exercise 4-4 Configuring Multiple Disk Locations for a Duplexed Disk Backup
Creating Backups of Backupsets
Backing Up Read-Only Tablespaces
Create an Archival Backup for Long-term Retention
Understanding Archival Backups
Create a Multisection, Compressed, and Encrypted Backup
Creating a Multisection Backup
Report On and Maintain Backups
5 Recovering Using RMAN Backups
Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMAN
Using the RMAN RESTORE and RECOVER Commands
Performing Complete Recovery of a Noncritical Datafile
Exercise 5-1 Restore and Recover the USERS Tablespace
Performing Complete Recovery of a Critical Datafile
Perform Incomplete Recovery Using RMAN
Performing Server-Managed Incomplete Recovery
Exercise 5-2 Perform Incomplete Recovery to Restore the USERS Tablespace
Recover Using Incrementally Updated Backups
Implementing an Image Copy Strategy
Switch to Image Copies for Fast Recovery
Performing a Fast Switch to Image Copies
Exercise 5-3 Use the SWITCH Command to Recover a Datafile Quickly
Using the RMAN SET NEWNAME with Fast Switch
Restore a Database onto a New Host
Understanding Restoration to a New Host
Restoring and Recovering on the New Host
Recover Using a Backup Control File
Restoring the SPFILE from the Autobackup
Restoring the Control File from the Autobackup
Exercise 5-5 Restore the Control File from an Autobackup
Performing Recovery in NOARCHIVELOG Mode
Using Incremental Backups in NOARCHIVELOG Mode
Performing Recovery of the Entire Database
6 User-Managed Backup and Recovery
Exercise 6-1 Create a Replacement Tempfile for the TEMP tablespace
Starting a Database Without a Tempfile
Recover from a Lost Redo Log Group
Understanding Log Group Status
Recovering from Log Group Member Failures
Recovering from Loss of an Entire Log Group
Recover from the Loss of the Password File
Review of Authentication Methods
Exercise 6-2 Re-create the Password File after Accidental Deletion
Perform User-Managed Complete Database Recovery
Performing Complete Closed Database Recovery
Exercise 6-3 Perform a Complete Database Recovery
Performing Complete Open Database Recovery
Perform User-Managed Incomplete Database Recovery
Performing User-Managed, Time-Based Incomplete Recovery
Exercise 6-4 Perform Incomplete Time-based Recovery
Perform User-Managed and Server-Managed Backups
Identifying Files for Manual Backup
Backing Up a Database in NOARCHIVELOG Mode
Backing Up a Database in ARCHIVELOG Mode
Identify the Need for Backup Mode
Back up and Recover a Control File
Backing Up the Control File in ARCHIVELOG mode
Exercise 6-5 Recover from the Loss of All Control Files
Creating a Duplicate Database Using RMAN
Using RMAN to Create a Duplicate Database
Using Enterprise Manager to Create a Duplicate Database
Exercise 7-1 Clone a Running Database
Exercise 7-2 Recover a Dropped Table Using a Cloned Database
Identify the Situations that Require TSPITR
Verifying Tablespace Dependencies
Identifying Objects Lost after TSPITR
Monitoring RMAN Sessions and Jobs
Exercise 8-1 Monitor RMAN Channels
Exercise 8-2 Monitor Multiple RMAN Jobs
Leveraging RMAN Error Logs and Messages
Exercise 8-3 Debug Part of an RMAN Session
Identifying Backup and Restore Steps
Understanding RMAN Multiplexing
Configure RMAN for Asynchronous I/O
Understanding Asynchronous and Synchronous I/O
9 Configuring and Using Flashback
Restore Dropped Tables from the Recycle Bin
Exercise 9-1 Move Objects to the Recycle Bin
Restoring Tables from the Recycle Bin
Exercise 9-2 Restore a Table from the Recycle Bin, Keeping the Original Dependent Object Names
Accessing Tables in the Recycle Bin
Configuring Flashback Parameters
Understanding Flashback Transaction Query
Flashback Transaction Query Prerequisites
Using Flashback Transaction Query
Using EM with Flashback Transaction Query
Choosing Transaction Back-out Options
Perform Flashback Table Operations
Exercise 9-3 Use Flashback Table on a Table
Set Up and Use a Flashback Data Archive
Understanding Flashback Data Archive
Using Flashback Data Archive Data Dictionary Views
Assigning Flashback Data Archive Permissions
Managing Flashback Data Archives
Assigning a Table to a Flashback Data Archive
Querying Flashback Data Archives
Configure, Monitor Flashback Database and Perform Flashback Database Operations
Understanding Flashback Database
Configuring Flashback Database
10 Memory Management Techniques
Implement Automatic Memory Management
Understanding Oracle Memory Structures
Configuring Automatic Memory Management
Exercise 10-1 Enable Automatic Memory Management
Monitoring Automatic Memory Management
Manually Configure SGA Parameters
Understanding Automatic Shared Memory Management
Exercise 10-2 Enable Automatic Shared Memory Management
Configure Automatic PGA Memory Management
Configuring PGA Memory Management
11 Using Database Tuning Advisors
Overview of SQL Tuning Advisor
Exercise 11-1 Run SQL Tuning Advisor for a SQL Statement
Use the SQL Access Advisor to Tune a Workload
Understanding the SQL Access Advisor
Using the SQL Access Advisor with EM
Using the SQL Access Advisor with DBMS_ADVISOR
Database Replay Workload Capture
Database Replay Workload Preprocessing
Database Replay Workload Replay
Database Replay Analysis and Reporting
12 Disk Space and Resource Management
Manage Resumable Space Allocation
Understanding Resumable Space Allocation
Configuring Resumable Space Allocation
Using Resumable Space Allocation
Exercise 12-1 Configure Resumable Space Allocation for the HR User
Describe the Concepts of Transportable Tablespaces and Databases
Configuring Transportable Tablespaces
Exercise 12-2 Transport a Tablespace Using SQL and PL/SQL
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
Exercise 12-3 Perform Segment Analysis and Shrink Operations
Understand the Database Resource Manager
Understanding Resource Manager Terminology
Understanding Resource Manager Allocation Methods
Create and Use Database Resource Manager Components
Creating and Assigning Consumer Groups
Understanding Resource Allocation Methods
Exercise 12-4 Create and Use a New Resource Manager Plan
Understanding Resource Manager Views
13 Configuring Database Diagnostics
Set Up Automatic Diagnostic Repository
Understanding Alerts, Problems, and Incidents
Understanding Block Corruption
Using the DB_BLOCK_CHECKING Parameter
Using the Data Recovery Advisor
Exercise 13-1 Use Data Recovery Advisor
14 Using the Scheduler for Task Automation
Create a Job, Program, and Schedule
Understanding the Scheduler Architecture
Use a Time-based or Event-based Schedule for Executing Scheduler Jobs
Creating and Scheduling Time-based Jobs
Exercise 14-1 Creating a Job with the Scheduler API
Creating and Scheduling Event-based Jobs
Understanding Lightweight Jobs
Exercise 14-2 Create and Run a Lightweight Job
Use Job Chains to Perform a Series of Related Tasks
Create Windows and Job Classes
Use Advanced Scheduler Concepts to Prioritize Jobs
Using Classes, Windows, and the Resource Manager
Customize Language-Dependent Behavior for the Database and Individual Sessions
Using Globalization Support Features
Exercise 15-1 Make Globalization and Client Environment Settings
Exercise 15-2 Control Globalization Within the Session
Work with Database and NLS Character Sets
Linguistic Sorting and Selection