Using Backup and Recovery Concepts

Introduction

The Backup Concepts and Configuration module introduces you to backup architecture concepts. It discusses the various backup modes and using RMAN. It also delves into the various recovery scenarios and how best to get the data back.

• Multiplexing Control Files
• Using Redo Log Files
• Using Archived Redo Log Files
• Using Fast Recovery Area
• Backing Up the Control Files
• Backing up Database
• Performing Backup Using RMAN

Exercise 1 - Multiplexing Control Files

In this exercise you will learn the following about multiplexing control files:

• Establishing connection to the database
• Multiplexing Control Files using init.ora
• Multiplexing Control Files using spfile

Exercise 2 - Using Redo Log Files

In this exercise, you will learn the following about the Redo Log Files:

• Multiplexing Redo Log Files
• Creating New Groups
• Adding New Members
• Renaming Log Members
• Dropping Redo Log Groups
• Dropping Redo Log Members
• Clearing Online Redo Log Files

Exercise 3 - Understanding Archived Redo Log Files

In this exercise, you will learn the following about archived redo log files:

• Setting the Archive Destination
• Setting ARCHIVELOG

An archived redo log file is a copy of a redo log file before it is overwritten by new redo information. Because the online redo log files are reused in a circular fashion, there is no way of bringing a backup of a data file up to the latest committed transaction unless you configure the database in the ARCHIVELOG mode.

Exercise 4 - Understanding the Fast Recovery Area

In this exercise, you will learn the following about Fast Recovery Area:

• Configure Fast Recovery Area Using SQL Commands
• Fast Recovery Area Occupants

To simplify the management of backup and recovery files, the fast recovery area can be created for a database. The fast recovery area is an Oracle managed directory, file system, or Oracle Automatic Storage Management disk group that provides a centralized storage location for backup and recovery files. Oracle Recovery Manager can store its backup set and image copies in the fast recovery area and use them when restoring files during media recovery.

Exercise 5 - Performing Control File Backups

In this exercise, you will learn the following about backing up the control files:

• Performing a Text Backup of Control File
• Performing a Binary Backup of Control File

Exercise 6 - Performing Database Backups

In this exercise, you will learn the following about to backup database:

• Performing user-managed hot backups

Exercise 7 - Performing Backup Using RMAN

In this exercise, you will learn the following about to perform backup using RMAN:

• Creating Full and Incremental Backup