Professional Training On Oracle 11g Dba Ii

Duration: 30 Hours
Prerequisites
• Oracle 11g DBA I
Course Contents

1. Oracle Data Pump
• Data Pump Component
• Data Pump New Features
• How Does Data Pump Access Data?
? Direct Path Loads and Unloads
? Situations in Which Direct Path Load / Unload Is Not Used
? External Tables
• Accessing Data Over a Database Link
• What Happens During Execution of a Data Pump Job?
? Coordination of a Job
? Tracking Progress within a Job
? Filtering Data & Metadata During Job
? Transforming Metadata during a Job
? Maximizing Job Performance
? Loading and Unloading of Data
? Monitoring Job Status
? Monitoring the Progress of Executing Jobs
• File Allocation
? Specifying Files and Adding Additional Dump Files
? Default Locations for Dump, Log, and SQL Files
• Moving Data Between Different Database Versions
• Original Export and Import Versus Data Pump Export and Import
• How Data Pump Export Parameters Map to Those of the Original Export Utility
• How Data Pump Import Parameters Map to Those of the Original Import Utility
2. RMAN Concepts
• Configuring the Environment for RMAN Backups
? Showing and Clearing Persistent RMAN Configurations
? Configuring the Default Device for Backups: Disk or SBT
? Configuring the Default Type for Backups: Backup Sets or Copies
? Configuring Channels
? Configuring Control File and Server Parameter File Autobackups
? Configuring RMAN to Make Backups to a Media Manager
? Configuring the Backup Retention Policy
? Configuring Backup Optimization
? Configuring Oracle Flashback Database and Restore Points
• About RMAN Channels
? Channel Control Options for Manual and Automatic Channels
? Channel Failover
• About RMAN Backups
? About Image Copies
• RMAN Backup Types
? Incremental Backups
? RMAN Backup Errors
? Tests and Integrity Checks for Backups
? Detecting Physical and Logical Block Corruption
? Backup Validation with RMAN
• Restoring Files with RMAN
? Mechanics of Restore Operations
? File Selection in Restore Operations
? Datafile Media Recover