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

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: USING ARCHIVELOG AND NOARCHIVELOG MODES

• Configuring a database in Archivelog mode
• Configuring a database in Noarchivelog mode
• Configuring multiple redo log archive processes
• Configuring multiple archival destinations

Session 4: PHYSICAL BACKUP WITHOUT RMAN

• Closed and Open Backups
• Using operating system commands for database backup
• Performing Offline Backups
• Performing Online Backups
• Backup in Logging and Nologging Modes
• Control File Backups
• Data Dictionary Views for Backup Operations

Session 5: COMPLETE DATABASE RECOVERY WITHOUT RMAN

• Recovery in NOARCHIVELOG Mode
• Recovery in ARCHIVELOG Mode

Session 6: INCOMPLETE RECOVERY WITH ARCHIVING

• When to use Incomplete Recovery
• Performing an incomplete Recovery
• Recover from Losing Current and Inactive Noarchived Redo Log Files

Session 7: ADDITIONAL RECOVERY ISSUES

• Minimizing downtime
• Rapid crash recovery
• Checkpointing and cache recovery
• Parallel recovery
• Trial recovery
• Recover a database with missing data files
• Rebuilding lost or damaged control files
• Recovering read-only tablespaces

Session 8: GLOBALIZATION

• Overview of globalization
• Language encoding schemes
• NLS character sets
• NLS language and territory definitions
• NLS data dictionary views
• Multi language linguistic sorts
• Date times with timezones
• Display formats
• Date functions
• Case and accent insensitive sorts

Session 9: TROUBLESHOOTING UTILITIES

• Using Log and Trace Files to Diagnose Problems
• Detecting Block Corruption
• The ANALYZE Command
• The DBMS_REPAIR Package
• Use DBVERIFY to Validate the Database File Structure
• Block Media Recovery

Session 10: RECOVERY MANAGER OVERVIEW

• RMAN Features and Components
• Connecting to RMAN without a Recovery Catalog
• Start Up and Shut Down a Target Database Using RMAN

Session 11: CREATING AND MAINTAINING A RECOVERY CATALOG

• Creating a Recovery Catalog
• Use a Flashback Recovery Area
• Register a Database
• Connecting to RMAN
• Control File Information
• RESYNC CATALOG command
• Configure Persistent RMAN Settings
• Retention Policies
• Control File Autobackups

Session 12: BACKING UP WITH RMAN

• Types of RMAN Backup
• Backup Commands
• Backup sets parallelization
• Compressed backups
• Performing backups
• Full closed and open backups
• Incremental and cumulative backups
• The copy command
• Block change tracking
• Troubleshooting

Session 13: MAINTAINING A RECOVERY CATALOG

• Reset Command
• Change the Availability Status of Backups and Copies
• Catalog Backups Made with Operating System Commands
• Cross Check Backups and Copies
• Use data dictionary tables
• Update the repository after backup deletion

Session 14: RESTORING AND RECOVERING WITH RMAN

• Perform recovery in noarchivelog mode
• Perform complete recovery in archivelog mode
• Incomplete recovery using UNTIL TIME and UNTIL SEQUENCE
• Restore and recover a tablespace
• Restore and recover datafiles
• Recover a datafile not backed up
• Apply incremental backups to restore datafile image copies
• The SWITCH command

Session 15: 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

Session 16: MANAGING RESOURCES WITH RESOURCE MANAGER

• Overview of the Database Resource Manager
• Create resource plans and consumer groups
• Create resource plan directives
• Control resource by user groups
• Specify an instance plan
• Fixed CPU Quotas
• Integrate Resource Manager and Profiles
• Automatic session assignment
• Monitor the Resource Manager

Session 17: AUTOMATIC STORAGE MANAGEMENT

• Overview of ASM
• ASM initialization parameter files
• Administer ASM disk groups
• Execute SQL commands with ASM file names
• ASM instance startup and shutdown
• Migrate a database to ASM

Session 18: AUTOMATING TASKS WITH THE SCHEDULER

• Introduction to the Scheduler
• Scheduler Architecture
• Managing jobs and programs
• Prioritize jobs
• View job execution details
• Run external jobs

Session 19: AUTOMATIC DATABASE MANAGEMENT

• Monitoring the Oracle database
• Monitoring and managing storage
• Monitoring and managing memory
• Automatic PGA Memory Management
• Automatic Shared Memory Management
• Self monitoring architecture
• Automatic Workload repository
• Metrics, thresholds and alerts
• Automatic Database Diagnostics Monitor (ADDM)
• Monitoring and Tuning usage model
• Setting up Notification rules
• Using the Advisors

Session 20: MEMORY MANAGEMENT, ALERTS AND WAITS

• Memory Management
• Automatic memory management
• Memory advisors
• System generated alerts
• Threshold and event based alerts
• Wait Interface

Session 21: SQL PERFORMANCE TUNING

• Automated statistics collection
• Application statistics collection
• SQL Tuning advisor
• SQL Access advisor
• Segment advisor
• 10g Hints

Session 22: SECURING THE ORACLE LISTENER

• Listener Password Authentication
• Controlling Database Access
• Securing the EXTPROC Service Entry