Oracle Database 11g: Backup and Recovery

Course:  ORBKUP
Duration:  5 Days
Level:  II
Course Summary

Backup and Recovery of the Oracle database (DBMS), Oracle Database Duplication and Cloning are some of the primary tasks required of Database Administrators and Oracle technical support staff such as Unix/Linux/Windows administrators. The Oracle Database 11g: Backup and Recovery class enables the DBA and other technical support to acquire and develop skills to effectively monitor for corruption, backup, and recover an Oracle11g Database and perform database duplication and cloning. A great option of this class is that it can be customized to be delivered on either a Windows or Unix/Linux OS platform to suit the client???s needs. The course will focus on Oracle RMAN and Oracle Enterprise manager wizards and other utilities to equip the Oracle DBA or technical support to become certified as backup and recovery specialists among other functions as well.

« Hide The Details
Topics Covered In This Course

Recovery Concepts

  • About the Backup and Recovery Structures
  • Managing REDO Data
  • Managing Archived REDO Data
  • Creating a Foundation for Sound Recovery

Oracle Flashback Technology

  • About Flashback Technology
  • FLASHBACK Query
  • SELECT ???.AS OF TIMESTAMP
  • SELECT ???.AS OF SCN
  • Using DBMS_FLASBACK()
  • Configuring UNDO Management for FLASHBACK
  • UNDO_RETENTION
  • Flashback Table
  • Flashback Drop
  • Flashback Versions Query
  • Flashback Transaction Query
  • Flashback Transaction Backout

FLASHBACK Database

  • About Flashback Database
  • Configuring the Flash Recovery Area
  • Performing Database Flashback
  • Monitoring Flashback Performance
  • Flashback Database Considerations
  • Configure Flashback Data Archive

Instance Recovery

  • About Instance Recovery
  • Instance Recovery Parallelism
  • Changing RECOVERY_PARALLELISM
  • MTTR Advisor & Tuning Checkpoints
  • LOG_CHECKPOINTS_TO_ALERT
  • REDO Logfile Size Advisor
  • FAST-START ON-DEMAND Parallelism

Configuring RMAN

  • RMAN Architecture
  • Launch and Use RMAN
  • Configure RMAN Settings
  • Allocate RMAN Channels

Backup With RMAN

  • About Backup File Types
  • Performing Full Backups
  • Performing Incremental Backups
  • Establishing a Backup Retention Policy
  • Generate Reports
  • REPORT UNRECOVERABLE
  • REPORT NEED BACKUP
  • LIST INCARNATION
  • Validate Backup Data Integrity

RMAN Management With EM

  • Monitoring the Lash Recovery Area
  • The EM Interface to RMAN
  • Scheduling RMAN Backups
  • Using the Oracle-Suggested Backup Strategy
  • Manage current Backups
  • Backup Reports
  • Manage Restore points

User-Managed Recovery Operations

  • Recovery Concepts
  • Recover Temporary Tablespaces
  • Recover READ-ONLY Tablespaces
  • Recover Index Tablespaces
  • Recover REDO Log Group Member
  • Recreate the Password File

Recovery With RMAN

  • Complete Media Recovery
  • Incomplete Media Recovery
  • Recovery Using EM

Using the RMAN Recovery Catalog

  • Understanding Catalog Concepts
  • Create the Recovery Catalog
  • Manage Virtual Private Catalogs
  • Data Protection of the Recovery Catalog
  • Using RMAN Scripts

Database Duplication & Cloning

  • Why Perform Database Duplication?
  • RMAN DUPLICATE DATABASE
  • RMAN DUPLICATE
  • DATABASE Cloning

Advanced RMAN Capabilities

  • Backup Optimization
  • Enhancing Parallelism With Section Sizes
  • Archival Backups
  • BACKUPSET Encryption
  • Copying Files Between Databases

Transporting Tablespaces

  • About Tablespace Transportation
  • READ_ONLY Tablespace Transportation
  • READ-WRITE Tablespace Transportation
  • Transport Tablespaces Using EM

Recovering From Corruption With Data Recovery Advisor

  • How Does Corruption Occur?
  • Detecting Corruption
  • ANALYZE
  • V$DATABASE_BLOCK_CORRUPTION View
  • DB_BLOCK_CHECKING
  • DB_BLOCK_CHECKSUM
  • DB_LOST_WRITE_PROTECT
  • DB_ULTRA_SAFE
  • Recovery Using the Data Recovery Advisor
  • Block Media Recovery
  • Isolating Corruption With DBMS_REPAIR()
What You Can Expect

This course enables the participants to acquire and develop key skills to effectively Recover and Monitor an Oracle11g database . The participants will learn to configure the RMAN backup and recovery utility. In addition, they will be introduced to Oracle???s Enterprise manager Wizards for recovery diagnostics, recovery wizard, implementing flashback technologies wizards, the integrated LogMiner, and others. The Database Resource Manager will be discussed as a means for controlling resource utilization on database servers whose resources exceeds its capacity. Many exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

Who Should Take This Course

Database Administrators

Web Server Administrators

System Administrators

Data Center Support Engineers

Senior application designers and developers

Recommended Prerequisites

Participants should have a good understanding and experience in Oracle Data Base Administration.

Training Style

Instructor Led (ILT) with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
ORADG
Oracle 11g Data Guard
3 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]