Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

Oracle RMAN Backup & Recovery Training Class

A 4-day on-site Oracle RMAN Backup & Recovery Training Course

© 2016 by Burleson Corporation

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 

   
Key Features

* Learn RMAN from Burleson Corporation Instructors including Robert Freeman, the world's leading RMAN expert

* Use Oracle Backup & Recovery Utilities for advanced recovery of complex systems.

* See RMAN setup and configuration.

* Learn Oracle Disaster planning and Oracle Recovery Techniques.

 

  

Course Description

The primary goal is this course is to prepare the students to install, configure and implement backup and recovery systems using RMAN.

This Oracle RMAN course is an intensive 4-day course is designed to provide Oracle professionals with an in-depth understanding of the backup & recovery features of Oracle, specific Oracle concepts and knowledge required for RMAN and tips and techniques success.

exercises are used to demonstrate each feature of RMAN and the student will gain first-hand experience in the key Oracle backup & recovery concepts.

Book Recommended

RMAN backup recovery handbook

Audience

The backup and recovery training course assumes a basic knowledge of computer programming techniques, relational database concepts, SQL, and basic Oracle architecture.

This Oracle RMAN training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle backup & recovery.  This includes Systems Administrators, Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand how to backup & recover any Oracle database. 

Curriculum Design

This Oracle RMAN training was designed by Robert Freeman, an acknowledged leader in Oracle database administration and author of more than 6 bestselling Oracle administration books.  Freeman is one of the most famous Oracle experts and author of eight popular Oracle books, including Oracle9i RMAN Backup & Recovery and the bestselling Oracle9i New Features book. Burleson Corporation instructors offer decades of real world experience in Oracle features, and they will share their secrets in this intense Oracle training. 

Learning Objectives:

The primary objective of this Oracle RMAN training is to provide each student with the knowledge and concepts to successfully implement an RMAN-based backup & recovery strategy.

Using a proven training combination of intense instruction, practicum and numerous Oracle9i sample exams, the student should have a firm understanding of Oracle RMAN backup & recovery.  The student will learn proper Oracle backup & recovery planning and architecture and get experience using the Oracle export and import utilities.  The students will also successfully install and configure RMAN and perform real recoveries, including point-in-time Oracle database recoveries.



Oracle RMAN Backup & Recovery Training Class

RMAN Backup & Recovery Training Course

Copyright © 2016 by Burleson Corporation
 
Syllabus
 
 
  • Introductions
  • The 10 keys of a bulletproof backup strategy
  • Designing effective backup and recovery strategies
    • Archivelog vs. noarchivelog
    • Disaster recovery
    • Types of failures
      • User
      • Process
      • Instance
      • Statement
      • Media
  • Configure database archiving
    • Prepare parameter file
    • Put database into archivelog mode
    • Test archiving
  • Backup the Oracle Database
    • Physical Oracle backups
      • Steps to perform cold backup
      • Steps to perform hot backup
    • Logical Oracle backup
      • Using export/import
    • Complete Oracle Database recovery
    • Complete recovery concepts
    • Types of complete recovery
      • Database
      • Datafile
      • Tablespace
    • Steps to perform complete database recoveries
  • Incomplete Oracle Database recovery
    • Incomplete recovery concepts
    • Types of incomplete recovery
      • Cancel-based
      • Time-based
      • Change-based
    • Steps to perform incomplete database recoveries
  • Introduction to RMAN
    • Discuss RMAN architecture
    • Comparison of RMAN backup methods
  • Create a recovery catalog
    • Maintenance of the recovery catalog
    • Resync recovery catalog
    • RMAN commands: backup and copy
    • Create RMAN scripts
    • Store and execute RMAN scripts
  • Tools for troubleshooting problems
    • Error log and Trace files
    • Detection of corrupt blocks
    • Repair corrupt blocks
    • DBVERIFY utility
    • DBMS_Repair
    • LogMiner utility
    • V$Views
    • Flashback query
  • Standby databases
    • Benefits of a standby database
    • Create standby database
  • Case studies
    • Missing/lost datafile
    • Failure during hot backup
    • Loss of a controlfile
    • Loss of a rollback segment
    • Loss of an online redo log
    • Recovering from user errors
  • New Oracle 10g backup and recovery features
    • Flash recovery area
    • Oracle flashback database
    • Incrementally updated backups: rolling forward image copies
    • Disk topology and automatic performance tuning
    • Automatic datafile creation
    • Recovery through resetlogs
    • Restore failover
    • BACKUP command creates backup sets or image copies
    • Fast incremental backups
    • Channel failover
    • Improved RMAN reporting through V$ views
    • Cross-platform tablespace conversion
    • Enhanced reporting: RESTORE PREVIEW

1:  Backup and Recovery Overview

Introduction to Backup and Recovery

DBA Duties

Errors and Failures Requiring Recovery

Oracle Backup and Recovery Techniques and Solutions

Datafiles

Control Files

Redo Log Files

RMAN Backup Concepts

Backup Set

Backup Piece

Channel Allocation

Autobackups

Summary

 

2:  Configuring RMAN and Connecting to the Database

Using the Recovery Catalog

Setting Persistent RMAN Configurations

Retention Policy

Backup Optimization

Determining the Device Type

Setting up Automatic Backups of the Control File

Configuring Parallelism

Configuring the Backup Set Size

Setting Up Encryption and Encryption Algorithm for the Backup

Configuring Archivelog Deletion Policy

Configuring the Snapshot Control File

Configuring and Using the Flashback Recovery Area

Connecting to RMAN

Connecting to RMAN Without Using Recovery Catalog

Connecting to RMAN using a Recovery Catalog

Switching to Archivelog Mode

Setting Up the Archivelog Mode

Taking the First Backup and Performing the First Recovery

Checking RMAN Syntax Using CheckSyntax

Conclusion

 

3:  Backing Up the Database Using RMAN

Introduction

Backing up the Whole Database

Backing up a Database Running in Noarchivelog Mode

Backing Up the Control File

Multiplexing Control Files

Backing up the Server Parameter File

Backing Up Datafiles

Taking Multisection Backups

Backing Up Archived Redolog Files

Delete Input

Back Up Tablespaces

Creating Archival Backups

Creating Compressed Backups

Creating Encrypted Backups

Validating Backups

Backing Up Backup Sets

Making Incremental Backups

Block Change Tracking Overview

Enabling Block Change Tracking

Renaming and Disabling Block Change Tracking

Missing Tracking File

RMAN Reporting on Backups

Using the list Command

Skipping a Tablespace from the Output of the list Command

Listing Information about Backup of Archived Redo Log Files

Listing Image Copies of Database Files

Reporting information about RMAN Backups

Summary

 

4:  Restoring and Recovering the Database Using RMAN

Introduction

Doing a Recovery Operation?

Instance Crash Recovery

User Created Mistake Recovery

User Process Failure Recovery

Media Crash/Failure Recovery

Disaster Recovery

What is Recovery All About?

What Does Recovery Mean?

When is a Recovery Needed?

How is a Recovery Accomplished?

Media Recovery

Restoring and Recovering Control Files

Recovering from the Loss of a Control File When a Mirrored Copy is Available

Restoring Control File with Redo Logs Intact

Recovery When Control Files and Data Files are Lost but the Redo Logs are Intact

Recovery when Control Files, Datafiles, and Redo Logs are Lost

Recovery from the Loss of Control Files when No Backup Files are Available but Redo Logs are Intact

Restoring the Spfile

A Dirty Workaround

Restoring and Recovering Datafiles

Restoration and Recovery of a System Datafile

Recovering a Datafile That is Not Backed Up

Restoring Tablespaces

Restoration of the Archivelogs

Using set newname to Change the Restored File Location

Performing Block Media Recovery

Performing Block Recovery Without RMAN Backups

Performing Disaster Recovery

Performing an Incomplete Recovery

Scn-based Incomplete Recovery

Time-based Incomplete Recovery

Change-based Incomplete Recovery

Recovering to Restore Point

Recovering a Database to a Previous Incarnation

Tablespace Point-in-Time Recovery

Using Data Recovery Advisor

Conclusion

 

5:  Cloning Database with RMAN

Cloning Database with RMAN Overview

Creating a Duplicate Database on Remote Host with the Same Directory Structure

Creating a Duplicate Database on a Remote Host

Duplicating Database to the Remote Host with Different Directory Structure

Creating Duplicate Database with Different Directory Structure

Creating a Duplicate Database on a Local Host

Resynchronize a Duplicate Database

Configure AUXNAME configuration of RMAN

Duplicate on Windows Host

Duplicate Database Without Any Backup (g New Feature)

Duplicate database Without Connecting to the Target Database

Cloning Database Using Enterprise Manager

Creating Standby Database Using RMAN

Recovering Standby Database Using Incremental Backups

Resolving Archived Redo Log Gaps Using Incremental Backups

Conclusion

 

6:  Transportable Tablespaces and Databases

Transportable Tablespace (TTS) Feature

Transporting Tablespace Using RMAN Backups

Transporting Tablespace Manually Without RMAN Backups

Transporting the Tablespace across Different Platforms which have a different endian format

Using the convert tablespace command on the source host to transport the whole tablespace (with all its datafiles) from Solaris OS to the Linux OS

Using the convert datafile Command on the Destination Host to Convert the Datafile from the Linux Platform to the Windows OS

Cross-Platform Database Migration

Copying Datafiles from ASM Storage

Conclusion

7:  Managing the Recovery Catalog

Introduction

Creating the Recovery Catalog

Registering a Database in the Recovery Catalog

Unregistering the Database From the Catalog

Dropping the Recovery Catalog

Synching a Catalog

Saving RMAN Scripts in the Recovery Catalog

Creation of RMAN Scripts

Create Script from a File

Delete the Stored Script

Cataloging the Copies of the Files

Backing Up and Recovering the Recovery Catalog

Creating Virtual Private Catalogs

Merging and Moving the Recovery Catalog

Querying the Recovery Catalog

Conclusion

 

8:  Troubleshooting, Monitoring and Tuning RMAN

RMAN Troubleshooting Overview

Interpreting RMAN Error Stack

RMAN in Debug Mode

Using the sbttest Utility

Monitoring RMAN

RMAN Tuning Introduction

It is All About I/O

Be In Synch With Asynchronous I/O

Conclusion

 

9:  User-managed Backup and Recovery Scenarios

Modes of the Backup

Backing Up Database Running in Noarchivelog Mode

Back Up the Database Running in Archivelog Mode

Diving Deep into the Backup Mode

Restore/recover the Database Running in Noarchivelog Mode

User-managed Backup of Controlfile

Backing Up Controlfile in Binary Format

Text Backup of Controlfile

Backing Up Archive Files

Backing Up Spfile, Password File and Network Files

Backing Up Offline and Read Only Datafiles

Verifying User-managed Backups

User-managed Recovery Scenarios

Recovering from the Loss of Controlfiles

Recovering from Loss of all Controlfiles Using Backup Controlfile

Recovering From Loss of a Member of Multiplexed Controlfile

Recovering Read Only Tablespace From Loss of Controlfiles

Recovery of Datafiles and Tablespaces

Recovering Offline and Read Only Datafiles

Recovering a Datafile Which Has No Backup

Recovering Undo Datafile

Performing User-Managed Recovery from Loss of Redo Log Files

Performing Incomplete Recovery

Time-based Incomplete Recovery

Conclusion

 

10:  Using the Media Management Layer

Introduction

The sbttest Utility

Simulating SBT Channel

Introduction to Oracle Secure Backup

A Closer Look at Oracle Secure Backup (OSB)

Oracle Application Servers

Daemons Related to OSB

Installing OSB on Linux

Configuring OSB

RMAN Configuration with OSB

Database Backup and Recovery Using OSB

Doing File System Backup and Restore Using OSB

Oracle Secure Backup Cloud Module

Conclusion

 

11:  Performing Flashback Recovery

Introduction

Oracle Flashback Query

Viewing/Retrieving the Dropped PL/SQL Object codes using Flashback Query

Using Flashback Query on Dropped Table

Oracle Flashback Versions Query

Oracle Flashback Transaction Query

Flashback Transaction Backout

Oracle Flashback Table

Oracle Flashback Drop

Managing the Recycle Bin

Purging Objects From the Recycle Bin

Oracle Flashback Database

Excluding Tablespace from Flashback

Performing Flashback Database When There is Tablespace Excluded From Flashback

Recover Dropped Schema with Flashback Database

Restoring Dropped Tablespace Using Flashback Database

Monitoring Changes in Flashback Database

Oracle Flashback Data Archive (Total Recall)

Modify the Flashback Data Archive

Using Default Flashback Data Archive for the System

Query Flashback Data Archive

Using Flashback Versions Query and Flashback Table with Enterprise Manager

Using Flashback Drop from OEM

Conclusion

 

12:  Backing Up Database Using Data Pump Utility

Introduction

Data Pump Overview

Data Pump Architecture

Data Pump Dump File

Data Pump Modes

Using Data Pump Export Utility (expdp)

Data and Metadata Filtering Using Data Pump

Exporting Remote Database Schema Objects

Exporting Objects Consistent with Specified scn or time

Estimating the Size of the Dump File

Parallelizing Export Process

Compressing the Data While Exporting

Exporting a Tablespace

Export of the Whole Database

Encrypted Export

Using Data Pump to Export/Import Tables

Using Data Pump Import Utility (impdp)

Remapping Through Data Pump

Using dbms_data pump Package to Move Data

Interactive Command Line Mode of Data Pump

Attaching to a Job

Getting the Best Out of the Data Pump

Main Differences Between Data Pump and Original Export/Import Tools

Conclusion

 

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.