Oracle Database 11g Release 2 DBA - Part II - United Kingdom

Oracle Database 11g Release 2 DBA - Part II Course Outline

Module 1: Backup and Disaster Recovery

• Backup and Recovery
  • Overview
• Backup Strategies
  • Overview of Backup Strategies
  • Issues in Backup and Recovery
  • Oracle Backup and Recovery Solutions
  • Oracle Backup and Recovery Strategy
  • New Backup and Recovery Features for Oracle 11g Release 2
  • Backing Up a Database in Windows
  • Restore the Database on Windows

Module 2: Archivelog and Nonarchival

• Archivelog and Nonarchival
  • Modes
  • Uses for Archived Redo Logs
  • Running a Database in NOARCHIVELOG Mode
  • Advantages of Archiving Filled Groups
  • Redo Log File Use in Archivelog Mode
  • Changing the Database Archiving Mode

Module 3: Managing Memory

• Managing Memory
• Memory Management
• Types of Memory Management
• Automatic Memory Management
• Manual Memory Management
• Methods of Manual Memory Management
• Basic Memory Structures Associated with Oracle Database
• Oracle Database Memory Structures
• Enabling Automatic Memory Management

Module 4: Recovery Manager

• Recovery Manager
  • Recovery Manager (RMAN)
  • RMAN Architecture
  • RMAN Environment Structure
  • Methods of RMAN Backup
  • Restoring and Recovering Database Files
  • Preview a Database Restore and Recovery
  • Recovering the Whole Database

Module 5: Flashback Technology

• Flashback Technology
  • Overview
  • Features
  • Flashback Features Allow Users to
  • Configuring Database for Flashback Transaction
  • Configuring Database for Automatic Undo Management
  • Configuring Database for Oracle Flashback Transaction Query
  • Granting Necessary Privileges
  • For Oracle Flashback Query and Oracle Flashback Version Query
  • For Oracle Flashback Transaction Query
  • For DMBS_FLASHBACK Package

Module 6: Reviewing and Diagnosing Databases

• Database Logs
  • Standard DML Operations (INSERT, UPDATE, DELETE, MERGE) ..LOG ERRORS INTO

Module 7: Monitoring and Improving Database Performance

• Database Advisors
  • Overview
  • Performance Advisors
  • What Does an Automatic SQL Tuning Advisor Do?
  • Configuring the Automatic SQL Tuning Advisor

Module 8: Controlling Database Resources

• Overview
• With the Resource Manager, a user can
• Resource Plan
• Resources Manager Administration Privileges
• Types of Resources Managed by the Resource Manager
• Disabling the Resource Manager
• Using Several Resource Allocation Methods

Module 9: Automating Tasks with Scheduler

• Automate Tasks
  • Overview
  • Maintenance Windows
  • Configuring Automated Maintenance Tasks
  • Enabling and Disabling Maintenance Tasks for All Maintenance Windows
  • Configuring Resource Allocations for Automated Maintenance Tasks
  • Predefined Maintenance Windows

Who should attend this Oracle Database 11g Release 2 DBA - Part II Course?

The Oracle Database 11g Release 2 DBA - Part II Training Course is designed for individuals who have a foundational understanding of Oracle databases and have completed the Part I Course. This Oracle Training Course can benefit a wide range of professionals, including:

• Experienced Database Administrators
• Oracle Application Developers
• IT Managers
• Database Developers
• System Administrators
• Security Specialists
• Data Warehouse Administrators

Prerequisites of the Oracle Database 11g Release 2 DBA - Part II Course

Candidates are required to have attended the Oracle Database 11g Release 2 DBA - Part I Course, as well as have a basic understanding of Oracle SQL, before pursuing this Oracle Course.

Oracle Database 11g Release 2 DBA - Part II Course Overview

Oracle Database 11g Release 2 DBA - Part II is an advanced training course that delves into the intricacies of database backup and recovery strategies. This comprehensive training equips Database Administrators and technical support staff with the knowledge and skills to safeguard and restore Oracle databases effectively.

Proficiency in Oracle Database 11g Release 2 DBA - Part II is crucial for database professionals who manage mission-critical databases. With data's increasing volume and complexity, ensuring data integrity and availability is paramount. This training empowers database professionals to design, implement, and execute robust backup and recovery plans, minimising downtime and data loss.

In The Knowledge Academy’s intensive 2-day Oracle Database 11g Release 2 DBA - Part II Training, delegates will gain in-depth knowledge of solutions and strategies for Oracle backup and recovery. They will also learn about restoring and recovering database files, previewing a database restore and recovery, and healing the whole database. Our highly professional trainers with years of experience in teaching such courses will conduct this training course and help you understand it.

Course Objectives

• To understand the principles of database backup and recovery
• To identify and evaluate various backup and recovery strategies
• To implement Oracle Recovery Manager (RMAN) for effective backup and recovery
• To utilise Oracle Flashback technologies for point-in-time recovery
• To configure and manage Oracle Data Guard for disaster recovery
• To monitor and troubleshoot backup and recovery operations
• To optimise database performance and resource utilisation
• To enhance database security and compliance

After completing this Oracle Training, delegates will receive a certificate of completion, validating their proficiency in database backup and recovery strategies. This certification enhances their professional credentials and demonstrates their expertise in this critical area of database administration.

What’s included in this Oracle Database 11g Release 2 DBA - Part II Course?

• World-Class Training Sessions from Experienced Instructors  
• Oracle Database 11g Release 2 DBA - Part II Certificate
• Digital Delegate Pack