search our courses:
Quick Navigation
Oracle 11g Database Fundamentals Pt 2 course
Download PDF version of Oracle 11g Database Fundamentals pt 2 course outline
Overview
This course is follows on from the Pt 1 course and introduces delegates to the more advanced features of the product. The course covers backup and recovery strategy using Recovery Manager, effective memory management, performance evaluation and tuning tasks, controlling database resources, automating tasks and use of Automatic Storage Management (ASM).
Who Should Attend
Administrators and Technical support staff.
Prerequisites
Attendance of the DBA Fundamentals Pt1 course or equivalent knowledge.
Course Contents (5 days)
- 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
- 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
- Architectural Components
- MEMORY MANAGEMENT
- Automatic Shared Memory Management
- PGA Memory Management
- Automatic Memory Management
- The Memory Advisor
- Memory Allocation Advisors
- Memory Management Data Dictionary Views
- USING ARCHIVELOG & 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
- 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
- RECOVERY MANAGER OVERVIEW
- Overview of Recovery Manager
- RMAN Features and Components
- Connect to RMAN
- Start Up and Shut Down a Target
Database Using RMAN
- 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
- 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
- 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
- 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
- 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
- MANAGE SPACE FOR THE DATABASE
- Transport Tablespaces
- Transport Databases
- 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
- 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
- ORACLE TOTAL RECALL
- Overview of Oracle Total Recall
- Manage Flashback Archives
- Flashback Data Archive and Auditing
- Flashback Data Archive Uses
- 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
- MANAGE SPACE IN SEGMENTS
- Tablespace Monitoring
- Segment Management Enhancements
- Segment Advisor
- Segment Space Estimation
- Online Segment Shrink
- Proactive Tablespace Management
- MANAGE SPACE IN BLOCKS
- Free Space Management
- Monitor Space
- Compress Data
- 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
- DATABASE PERFORMANCE BY SQL TUNING
- Application and SQL Tuning
- SQL Tuning Advisor
- SQL Access Adviso
- SQL Performance Analyzer
- 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
- 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