Database Architecture and ASM
o Oracle Database Architecture Overview
o ASM General Architecture
o Creating an ASM Instance
o Using Enterprise Manager to Manage ASM Users
o ASM Storage Concepts
o The ASMCMD Utility
o ASM Scalability and Performance
Configuring for Recoverability
o Purpose of Backup and Recovery Functionality
o Typical Backup and Recovery Tasks
o Oracle Backup and Recovery Solutions
o Using Recovery Manager (RMAN)
o Using a Flash Recovery Area
o Flash Recovery Area Space Management
Using the RMAN Recovery Catalog
o RMAN Repository Data Storage: Comparison of Options
o Storing Information in the Recovery Catalog
o Registering a Database in the Recovery Catalog
o Recovery Catalog Resynchronization: Concepts
o Using RMAN Stored Scripts
o Backing Up and Recovering the Recovery Catalog
o Using a Virtual Private Catalog
Configuring Backup Specifications
o Using RMAN to Create Backups
o Configuring Persistent Settings for RMAN
o Using Enterprise Manager to Configure RMAN Settings
o Control File Auto-backups
o Managing Persistent Settings
o Configuring Devices for Backup
o Configuring and Allocating Channels for Use in Backups
o Configuring Backup Optimization
Creating Backups
o Creating an Oracle-Suggested Backup
o Creating Backup Sets & Image Copies
o Creating a Whole Database Backup
o RMAN Backup Types
o Monitoring Block Change Tracking
o Creating Duplex Backup Sets
o Archival Backups: Concepts
o Encrypting Backups
Performing User-Managed Backup and Recovery
o Restoring and Recovering
o Causes of File Loss
o Critical Versus Non-critical
o Recovering from a TEMPFILE Loss
o Re-creating Indexes
o Recovering from a Lost Index Tablespace
o Authentication Methods for Database Administrators
o Recovering a Read-Only Tablespace
Using RMAN to Perform Recovery
o Using RMAN RESTORE and RECOVER Commands
o Performing Recovery Using Enterprise Manager
o Recovery Using Incrementally Updated Backups
o Perform a Fast Switch to Image Copies
o Restoring and Recovering the Database on a New Host
o Performing Disaster Recovery
Using RMAN to Duplicate a Database
o Using RMAN to Create a Duplicate Database
o Creating a Duplicate Database
o Creating an Initialization Parameter File for the Auxiliary Instance
o Allocating Auxiliary Channels
o Understanding the RMAN Duplication Operation
o Using EM to Clone a Database
o Cloning a Running Database
Performing Tablespace Point-in-time Recovery
o Tablespace Point-in-Time Recovery (TSPITR) Concepts
o Tablespace Point-in-Time Recovery: Architecture
o Understanding When to Use TSPITR
o Determining the Tablespaces for the Recovery Set
o Using Enterprise Manager to Perform TSPITR
o Understanding TSPITR Processing
o Troubleshooting RMAN TSPITR
Monitoring and Tuning RMAN
o Parallelization of Backup Sets
o Monitoring RMAN Sessions
o Interpreting RMAN Message Output
o Using the DEBUG Option
o Tuning RMAN
o RMAN Multiplexing
o Comparing Synchronous and Asynchronous I/O
o Tape Subsystem Performance Rules
Using Flashback Technology
o Flashback Technology
o Transactions and Undo
o Guaranteeing Undo Retention
o Preparing Your Database for Flashback
o Flashback Drop and the Recycle Bin
o Using Flashback Technology to Query Data
o Possible Workflow
o Flashback Transaction Wizard
Using Flashback Database
o Flashback Table
o Enabling Row Movement on a Table
o Enabling Row Movement on a Table
o Flashback Database Architecture
o Configuring Flashback Database
o Performing Flashback Database Using EM
o Flashback Database Considerations
o Flashback Data Archive
Diagnosing the Database
o Automatic Diagnostic Workflow & Repository
o Location for Diagnostic Traces
o Viewing the Alert Log Using Enterprise Manager
o The Support Workbench and Oracle Configuration Manager
o Create a Service Request
o Package and upload diagnostic data to Oracle Support
o Incident Packaging Configuration
o Health Monitor Overview & Data Recovery Advisor
Managing Memory
o Oracle Memory Structures
o Automatic Memory Management Overview
o Oracle Database Memory Parameters
o Auto Memory Parameter Dependency
o Automatic Shared Memory Management: Overview
o Automatic PGA Memory Management
o Using the Memory Advisor to Size the SGA
o Memory Tuning Guidelines for the Library Cache
Managing Database Performance
o Tuning Activities
o Performance Planning & Performance Tuning Methodology
o Instance Tuning
o Troubleshooting and Tuning Views
o Automatic Workload Repository
o SQL Tuning & SQL Advisors
o Using the SQL Tuning Advisor
o SQL Access Advisor: Overview
Using the Segment Advisor
o Space Management: Overview
o Proactive Tablespace Monitoring
o Thresholds and Resolving Space Problems
o Monitoring Tablespace Space Usage
o Shrinking Segments
o Space Reclamation with ASSM
o Automatic Segment Advisor
o Minimum Compatibility Level
Managing Resources
o Database Resource Manager: Overview
o Database Resource Manager Concepts
o Accessing Resource Plans
o Default Maintenance Resource Manager Plan
o Creating Consumer Groups
o Resource Allocation Methods for Resource Plans
o Resource Allocation Methods for Resource Plans
o Monitoring the Resource Manager
Automating Tasks with the Scheduler
o Simplifying Management Tasks
o Key Components and Steps
o Creating an Event-Based Schedule
o Creating Complex Schedules
o Creating Job Chains
o Creating Job Chains
Administering the Scheduler
o Advanced Scheduler Concepts
o Job Classes
o Windows
o Prioritizing Jobs Within a Window
o Remote Jobs
o Installing the Scheduler Agent
o Dictionary Views Supporting Remote Jobs
Globalization
o Globalization Support Features
o What Every DBA Needs to Know
o Understanding Unicode
o Database Character Sets and National Character Sets
o Language- and Territory-Dependent Parameters
o Linguistic Searching and Sorting
o Case- and Accent-Insensitive Search and Sort
o NLS Data Conversion with Oracle Utilities
