Oracle Database 11g Release 2 DBA - Part II

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: BACKUP AND RECOVERY CONSIDERATIONS

• Oracle Suggested Backup Strategy
• Plan and Implement a Backup and Recovery Strategy
• Define a Backup Strategy
• Define a Disaster Recovery Plan
• The Advantages and Disadvantages of Different Backup Methods
• Test a Backup and Recovery Plan
• Backup Strategy
• Recovery Strategy
• Validate the Recovery Strategy

Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES

• Architectural Components of Backup and Restore
• Redo Logs, Checkpoints and Archives
• Multiplexing Control Files and Redo Logs
• Types of Database Failure

Session 3: MEMORY MANAGEMENT

• Automatic Shared Memory Management
• PGA Memory Management
• Automatic Memory Management
• The Memory Advisor
• Memory Allocation Advisors
• Memory Management Data Dictionary Views

Session 4: USING ARCHIVELOG AND NOARCHIVELOG MODES

• The Archive Modes of a Database
• Altering the Archive Mode of a Database
• Configuring Multiple Archival Destinations
• Configuring Multiple ARCH Processes
• Data Dictionary Tables for Archiving

Session 5: TROUBLESHOOTING UTILITIES

• Database Synchronization
• Automatic Block Corruption reporting
• Automatic Quarantine of Corrupt Redo Segments
• Protection from Data Corruptions
• Analyze Validate Structure
• Automatic Diagnostic Repository (ADR)
• The ADR Command Line Tool (ADRCI)
• Proactive Monitoring with the Health Monitor

Session 6: RECOVERY MANAGER OVERVIEW

• Overview of Recovery Manager
• RMAN Features and Components
• Connect to RMAN
• Start Up and Shut Down a Target Database Using RMAN

Session 7: CREATE A RECOVERY CATALOG

• Recovery Catalog Overview
• Create a Recovery Catalog
• Use a Flashback Recovery Area
• Register and Unregister a Database
• Control File Information
• RESYNC CATALOG command
• Virtual Private Catalogs
• Merge Catalogs
• Backup a Recovery Catalog

Session 8: BACKING UP WITH RMAN

• Channel Allocation
• The Configure Channel Command
• Types of RMAN Backup
• Recovery Manager Commands
• Performing Backups with RMAN
• The Backup Command
• The Copy Command
• Backup File Image Copies
• Perform Full, Incremental and Cumulative Backups
• Use Data Dictionary Tables

Session 9: MAINTAIN A RECOVERY CATALOG

• Reset Database Command
• Change the Availability Status of Backups and Copies
• Catalog Backups Made with Operating System Commands
• Generate Reports and Lists
• Configuration Values
• Cross Check Backups and Copies
• Delete Backups
• Drop Database and Archival Backups

Session 10: RESTORE AND RECOVER WITH RMAN

• Overview of Restore
• The Restore Command
• Restore a Database in Noarchivelog Mode
• Restore and Recover a Database in Archivelog Mode
• Incomplete Recovery using Until Time and Until Sequence
• Restore and Recover a Tablespace
• Automatic tempfile Recovery
• Restore and Recover a Datafile
• Recover a Datafile Not Backed Up
• Recover Individual Data Blocks
• Recover a Lost Redo Log Group
• Re-create a Password Authentication File
• Apply Incremental Backups to Restore Datafile Image Copies
• The Switch command
• The Data Recovery Advisor (DRA)
• Restore and Recover the Database on a New Host

Session 11: CREATE A DUPLICATE DATABASE WITH RMAN

• Overview of Database Duplication
• Database Duplication
• Duplication Options
• Create Files for the Duplicate Database
• Prepare an Auxiliary Instance for Duplication
• Create a Duplicate Database
• Clone a Running Database without a Backup
• Targetless duplication of a database

Session 12: MANAGE SPACE FOR THE DATABASE

• Transport Tablespaces
• Transport Databases

Session 13: MONITOR, TUNE RMAN

• Recovery Manager Tuning Overview
• Tuning RMAN Backup Performance
• Synchronous and Asynchronous I/O
• Instance Recovery Performance Tuning
• RMAN Messages
• Troubleshoot RMAN
• RMAN Detected Block Corruptions
• Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Session 14: FLASHBACK

• Configure and Use Flashback Database
• Monitor Flashback Database
• Flash Recovery Area Space Usage
• Flashback Query
• Retrieve Row History with Flashback Versions Query
• Audit or Recover from Transactions with Flashback Transactions Query
• Flashback Table
• Recover Dropped Tables with Flashback Drop
• The Recycle Bin
• Recover Tables to a Point in Time with Flashback Table
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout

Session 15: ORACLE TOTAL RECALL

• Overview of Oracle Total Recall
• Manage Flashback Archives
• Flashback Data Archive and Auditing
• Flashback Data Archive Uses

Session 16: AUTOMATE TASKS WITH THE SCHEDULER

• Introduction to the Scheduler
• Scheduler Related Parameters
• Access Rights
• Create and enable a Program
• Drop a Program
• Create a Schedule
• Create a Job
• Job Classes
• Windows
• Window Group
• Monitoring and Logging
• Use Time Based, Event Based and Complex Schedules
• Multi Destination Jobs

Session 17: MANAGE SPACE IN SEGMENTS

• Tablespace Monitoring
• Segment Management Enhancements
• Segment Advisor
• Segment Space Estimation
• Online Segment Shrink
• Proactive Tablespace Management

Session 18: MANAGE SPACE IN BLOCKS

• Free Space Management
• Monitor Space
• Compress Data

Session 19: MANAGE DATABASE PERFORMANCE

• Tuning Activities
• Use Statistic Preferences
• Optimizer Statistics Collection
• Monitor The Performance of Sessions And Services
• Automatic Workload Repository (AWR)
• The Benefits of Automatic Database Replay

Session 20: DATABASE PERFORMANCE BY SQL TUNING

• Application and SQL Tuning
• SQL Tuning Advisor
• SQL Access Adviso
• SQL Performance Analyzer

Session 21: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT

• Overview of ASM
• ASM Instance Creation
• SYSASM Role
• Administer ASM Disk Groups
• ASM Files
• ASM Startup and Shutdown
• Asm Disk Failure
• ASM Data Dictionary Views
• Migrate a Database to ASM Using RMAN
• The ASM Command Line Tool

Session 22: MANAGING RESOURCES WITH RESOURCE MANAGER

• Overview of the Database Resource Manager
• Create Resource Plans
• Create Resource Consumer Groups
• Create Resource Plan Directives
• Limit CPU Utilization at the Database Level
• Instance Caging
• Control Resources by User Groups
• Specify an Instance Plan
• Monitor the Resource Manager
• Data Dictionary Views