Course Contents
This course is designed to give the Oracle 11g database administrator a firm foundation in the concepts of Backup & Recovery, along with various ways of how to implement and effectively maintain recovery procedures on Oracle databases.
Also the enhancements and changes that have been introduced with 11g will demonstrated for the benefit of all students attending with a hands on approach and given a good understanding of how to manage and administer Oracle data and give an in-depth knowledge of the tools to ensure optimal database availability.
Training Course Contents
Backup and Recovery Overview
- Understanding the structures and processes for backup and recovery.
- Introduce the different methods for backup and recovery
- Diagnose and troubleshoot database problems.
- Understand Oracle Recovery Manager
Backup and Recovery
- Recovery structures and processes
- Backup and recovery configuration
- Types of failure and troubleshooting
- Complete recovery
- Incomplete media recovery
- Export and import utilities
- Test Recovery
- ALTER DATABASE END BACKUP
Oracle Recovery Manager
- RMAN command line prompt
- Recovery Manager architecture
- Setting up Recovery Manager
- Database space requirements and privileges
- Creating and running backup and recovery scripts from RMAN
- Using LIST and REPORT options from Recovery Manager
- Crash Recovery workshop,
- Persistent Parameters
- Block Level recovery
- Depreciated Commands
Create a recovery Catalog
- Catalog Maintenance
- Resync recovery Catalog
- Create and store Backup scripts
- Recovery Catalog views
Enterprise Manager Utilities
- Creating an Backup Configuration
- Configurable Parameters
Standby Databases & Data Guard
- Data Guard Features
- Creating the Standby Database
- Maintaining the Standby Database
- Altering the Physical Structure
- Failover without Data Guard
- Failover Using Data Guard
- Role Transitions Using Data Guard
- Data Guard Protection Modes
Flashback
- Flashback Features
- Enabling Flashback
- Flashback Query
- Additional Query Functions
- Flashback Version Query
- Flashback Transaction Query
- Flashback Table
- Flashback Drop (Recycle Bin)
- Flashback Database
Data Recovery Advisor
- Repairing data failures
- Executing repairs
- Classifying and Closing failures