Oracle Backup and Recovery

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.

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

Objectives
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.

Content

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