Oracle8 Backup and Recovery - Strategies and Backups

This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally users will be presented with the components and features of Recovery Manager and how to maintain a recovery catalog. Finally the user will learn how to perform physical backups with and without RMAN.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Network Administrators Database Administrators Technical Support Analysts System Administrators Application Developers and MIS Managers. Prior to taking this course participants should be familiar with SQL and PL/SQL or have taken courses 61110 61111 61112 and 60113. In addition participants should have taken the Oracle8 Database Administration series courses 61311 61312 61313 61314 and 61315.

Objective

• Identify the database administrator goals and the criteria for defining a backup and recovery strategy.
• Describe the structures and processes in the Oracle architecture.
• Identify the implications of operating a database in a given archive mode and identify the steps to change the archive mode.
• Set the init.ora parameters and configure the database for archive processing.
• Identify the components and features of Recovery Manager.
• Identify the contents and usage criteria for a recovery catalog and concepts related to creating a recovery catalog.
• Maintain the recovery catalog.
• Identify the concepts related to performing physical backups with and without RMAN.
• Describe the additional issues related to creating physical backups by using or without using RMAN.

Topics Include

Unit 1: Oracle Backup and Recovery Architecture

• Identify the database administrator goals and the criteria for defining a backup and recovery strategy.
• Identify the backup and recovery goals for a database administrator.
• Identify the criteria for defining a backup and recovery strategy.
• Identify the characteristics of a user process.
• Identify the characteristics of a server process.
• Identify the functions of the key Oracle memory structures.
• Identify the components of the SGA.
• Identify the functions of the key Oracle background processes.
• Match the key Oracle file structures with their characteristics.

Unit 2: Database Archiving

• Identify the implications of operating an Oracle database in Noarchivelog mode.
• Identify the characteristics of running a database in Noarchivelog mode.
• Identify the implications of operating an Oracle database in Archivelog mode.
• Sequence the steps involved in changing the archive mode of an Oracle database.
• Set the init.ora parameters to configure the database for archiving the online redo log files.
• Manage the database archive processing.
• Identify the v$ views used for obtaining archive log information.

Unit 3: Oracle Recovery Manager

• Identify the features of Recovery Manager (RMAN).
• Identify the Recovery Manager components.
• Identify the features of Backup Manager.
• Identify the contents of a recovery catalog.
• Identify the situations when a recovery catalog is used.
• Identify the guidelines for creating a recovery catalog.
• Sequence the steps for creating a recovery catalog.
• Identify the characteristics of the control file when using Recovery Manager.
• Start the recovery manager by using the RMAN command.
• Identify the events that occur during the connection process after the RMAN command is executed.
• Match the recovery manager commands used for updating the target database information with their functions.
• Allocate a channel for Recovery Manager.
• Identify the characteristics of a channel.
• Identify the methods used to recreate a recovery catalog.
• Display backup information from the recovery catalog by using Recovery Manager commands.
• Display information from the recovery catalog using data dictionary views.
• Identify data dictionary views used for extracting recovery catalog information.

Unit 4: Oracle Backup Methods

• Sequence the steps to perform a closed database backup.
• Perform an open database backup.
• Identify the requirements to perform an open database backup.
• Write the command to create a backup of a controlfile.
• Identify the guidelines to create a backup of a controlfile.
• Identify the issues associated with backing up a read-only tablespace.
• Identify the impact of making a tablespace as read-only.
• Identify the differences between the logging and nologging options.
• Identify the characteristics of an image copy.
• Identify the steps involved in an image copy process.
• Identify the characteristics of a backup set.
• Sequence the steps followed by RMAN to create a datafile backup set.
• Identify the characteristics of the archive log backup process.
• Perform a backup using a stored script.
• Identify the features of a stored script.
• Identify the command to create a script and make a backup.
• Identify the characteristics of an incremental backup.
• Identify the characteristics of a cumulative backup.
• Identify the constraints in performing a backup when using the Recovery Manager.
• Identify the memory usage characteristics of RMAN.
• Match the RMAN dynamic performance views with the information they display.
• Identify the methods for troubleshooting RMAN.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM

• Oracle8 Backup and Recovery - Troubleshooting and Recovery