Oracle Introduction

This 4 day course covers Oracle 10g Backup and Recovery. It will provide delegate's with a detailed knowledge of Oracle's Backup and Recovery mechanism and procedures.

 

Delegates will learn to Backup an Oracle Database using a variety of options. They will perform closed database backups, open database backups, whole backups, partial backups, full backups and incremental backups. They will perform these using both operating system tools and Oracle's Rman Utility.

 

Delegates will also perform recovery from a variety of failure scenarios. These scenarios will entail recovering a database from the loss of data files, control files, on-line and archived log files, and data files without a backup.  Delegates will also learn how to recover a database from data corruptions resulting from 'user errors'.  Recovery from 'user errors' will be dealt with using traditional 'Incomplete Recovery' techniques and the new 10g flashback technology.

 

Day 4 will contain a Backup and Recovery Workshop. At the start of the workshop delegates will perform an appropriate database backup.  During the workshop they will recover their database from a number of failure scenarios. Delegates will not be informed of the nature or cause of the database failure. Nor will they be given instruction as to the recovery method to use.  After each scenario delegates will be expected to determine whether an additional backup is required given the recovery they performed. After each scenario delegates will be quizzed as to the nature of the problem they encountered and the recovery method they used and whether this represented an appropriate or optimum solution.

 

At the end of the course delegates should be confident in their ability to backup an Oracle database and have the knowledge to develop appropriate backup strategies to suit a variety of database environments.  Delegates should also be able to recover an Oracle database from any file loss they are likely to encounter. Delegates will also be familiar with the techniques employed to recover from a user corrupting data within the database and be able to apply these techniques in all but the more complex scenarios.  Data corruption issues can become very complex if they go undiscovered for some time and these issues are dealt with in the advanced recovery course.

For delegates to manage the "Backup" and "Recovery" of business critical Oracle data.

At the end of this course delegates will be able to:-

 

• Determine whether an Oracle database is in archivelog or noarchivelog mode.
• Set or change the log mode of the database as appropriate.
• Configure and customize automatic archiving of log files.
• Determine the appropriate files to backup when the database is in noarchivelog mode and when the database is in archivelog mode.
• Backup an Oracle database using operating system tools.
• Backup an Oracle database using Rman.
• Use operating system tools or Rman to recover an Oracle database after the loss of a data file, control file or redo log group.
• Recover the database after the loss of a data file without a backup.
• Use incomplete recovery to reverse out an unwanted change to a database.
• Use flashback techniques to reverse out a data corruption in the database.
• Use dbverify or Rman reporting to identify corrupt blocks.
• Use traditional techniques or Rman to fix corrupt blocks.
• Clone an Oracle database for recovery or other business purposes.
• Delegates will also learn how to minimize backup and recovery time and resource overheads.

CHAPTER 1 - Architecture Review

Instance and Media Recovery Structures

Database Buffer Cache, DBWn, and Data files Redo Log Buffer, LGWR, and Redo Log Files Multiplexed Redo Log Files Database Checkpoints Types of Checkpoints CKPT Process Multiplexed Control Files ARCn Process and Archived Log Files Database Synchronization

 

CHAPTER 2 - Backup and Restoration in No-Archivelog Mode No-Archivelog Mode Backup in No-Archivelog Mode Making a Consistent Whole Database Backup Backing up On-line Redo Logs?

Querying Views to Obtain Database File Information No-Archivelog Mode Means No Recovery Restoration in No-Archivelog Mode Restoration with Redo Log File Backups Restoration without Redo Logs Backups

 

CHAPTER 3 - Configuring For Recovery:- Archivelog Mode Archivelog Mode Redo Log History Changing the Archiving Mode Automatic Archiving Manual Archiving Specifying the number of Archive Processes Specifying the Archive Log Destination Specifying Multiple Archivelog Destinations LOG_ARCHIVE_DEST_n Options Specifying a Minimum Number of Local Destinations Controlling Archiving to a Destination Specifying the Filename Format Obtaining Archive Log Information

 

CHAPTER 4 - Backup in Archivelog Mode

User-Managed Backups

Backup in Archivelog Mode

Open Database Backup Requirements

Open Database Backup Options

Making a Backup of an On-line Tablespace Backup Status Information Failure During On-line Tablespace Backup Read-Only Tablespace Backup Backup Issues with No-Logging Options Manual Control File Backups Backing Up the Parameter File DBVERIFY Command-Line Interface

 

CHAPTER 5 - Recovering Data Files in Archivelog Mode Complete Recovery in Archivelog Mode Recovery Steps in Archivelog Mode Advantages and Costs of Recovery in Archivelog Mode Data File Recovery Determining Which Files Need Recovery RECOVER Command Using Archived Redo Log Files During Recovery Restoring Data files to a New Location.

Complete Recovery Scenarios

Recovery of a Closed Database

Recovery of an Open Database

Open Database Recovery When the Database Is Initially Closed Recovery of a Data File Without a Backup Re-Creating Lost Data files Without a Backup Read-Only Tablespace Recovery Read-Only Tablespace Recovery Issues Temp File Recovery

 

CHAPTER 6 - Recovering Non-Data Files in Archivelog Mode Complete Recovery of Non Data Files Recovering Control Files Loss of a Single Control Files Loss of all Control Files Recreating Control Files Loss of Redo Log Member Loss of Inactive Redo Log Group Loss of Active Redo Group Loss of the Current Log Group Loss of the Current (or Active) Group

 

CHAPTER 7 - Incomplete Recovery

Incomplete Recovery Overview

Situations Requiring Incomplete Recovery Types of Incomplete Recovery Incomplete Recovery Guidelines Incomplete Recovery and the Alert Log Procedures for Incomplete Recovery (Non-structural Changes) RECOVER Command Overview Time-Based Recovery: Example Cancel-Based Recovery: Example Using a Backup Control File During Recovery Incomplete Recovery of a Tablespace

 

CHAPTER 8 - User Corruptions and Flashback Technology Flashback Drop and the Recycle Bin Restoring Tables from the Recycle Bin Recycle Bin: Automatic Space Reclamation Bypassing the Recycle Bin Querying the Recycle Bin Querying Data from Dropped Tables Restore Points Flashback Table Performing Flashback Table Flashback Table: Considerations Flashback Query Flashback Versions Query Flashback_Transaction_Query Flashback Database Flashback Database Architecture Configuring Flashback Database Excluding Tablespaces from Flashback Database Monitoring Flashback Database Guaranteed Restore Points

 

CHAPTER 9 - Rman Overview and Configuration Features of Recovery Manager Recovery Manager Components Channel Allocation Automatic Channel Allocation Manual Channel Allocation Media Management Connection Types with RMAN Connecting Without a Recovery Catalog Additional RMAN Command-Line Arguments Recovery Manager Command Modes Types of RMAN Commands The LIST Command The REPORT Command Configuring Persistent Settings for RMAN The SHOW Command Control File Auto-backups Managing Persistent Settings Using a Flash Recovery Area with RMAN Flash Recovery Area Space Usage V$FLASH_RECOVERY_AREA_USAGE Setting Parameters That Affect RMAN RMAN Usage Considerations

 

CHAPTER 10 - RMAN Backups

RMAN Backup Concepts

Recovery Manager Backups

Image Copies and Backup Sets

Characteristics of Backup Sets

Backup Piece

Backup Piece Size

The BACKUP Command

Multiplexed Backup Sets

Parallelization of Backup Sets

Duplexed Backup Sets

Backups of Backup Sets

Archived Redo Log File Backups

Backup Constraints

Compressed Backups

Image Copies

Image Copy Parallelization

Tags for Backups and Image Copies

Backup Command Options

Whole Database Backup

RMAN Backup Types

Differential Versus Cumulative

Backup in NOARCHIVELOG Mode

Control File and Server Parameter File Auto-backups Backing Up the Server Parameter File Block Change Tracking Enabling Block Change Tracking Incrementally Updating Backups Monitoring RMAN Backups RMAN Dynamic Views

 

CHAPTER 11 - Complete Recovery

Restoration and Recovery

RMAN RESTORE command

RMAN RECOVER command

RMAN Recovery:

Recovering a Database in ARCHIVELOG Mode Using RMAN to Recover a Tablespace Restore Data Files to a New Location The SWITCH command Recovering a Control File Auto-backup

 

CHAPTER 12 - Incomplete Recovery

Performing Incomplete Recovery

Time-Based Recovery

Time-Based: Example

Log Sequence Recovery

Log Sequence: Example

Incomplete Recovery and the Alert Log

 

CHAPTER 13 - RMAN Maintenance

Cross Checking Backups and Copies

The CROSSCHECK Command

Deleting Backups and Copies

The DELETE Command

Changing the Availability of Backups and Copies Exempting a Backup or Copy The CHANGE … KEEP Command Cataloging Archived Redo Log Files The CATALOG Command Uncataloging RMAN Records The CHANGE … UNCATALOG Command