Oracle8i Backup and Recovery: Strategies and Backups

This is the first course in a two-part series that covers the critical skills in planning and implementing database backup and recovery strategies. This course introduces the learners to the backup and recovery goals and functions of the various structures and processes in the Oracle architecture. In addition participants learn to manage archive processing and maintain a recovery catalog. This course also identifies the concepts associated with performing physical backups with or without Recovery Manager (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

Database Administrators System Administrators Network Administrators and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course. This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 3 1Z0-025.

Objective

• Identify the features of the Oracle backup and recovery architecture.
• Manage database archiving.
• Maintain a recovery catalog using Recovery Manager (RMAN).
• Display the database archive modes and identify the effects of running a database in a given archive mode.
• Identify different methods to perform physical database backups.

Topics Include

Unit 1: Oracle Backup and Recovery Architecture

• Select the backup and recovery goals of a database administrator.
• Identify the factors to be considered when defining a backup and recovery strategy.
• Differentiate between the user and server processes for user interaction with a database.
• Match the key Oracle memory structures with their functions.
• Match the functions of the key background processes with their functions.
• Match the key Oracle server file structures with their uses.

Unit 2: Database Archiving

• Identify the implications of operating an Oracle database in NOARCHIVELOG mode.
• Identify the implications of operating an Oracle database in ARCHIVELOG mode.
• Sequence the steps to change the archive mode of an Oracle database.
• Manage the database archive process.
• Configure the database for archiving the online redo log files by setting parameters in the init.ora file.
• Identify the data dictionary views used to obtain the archive log information.

Unit 3: Oracle Recovery Manager

• Select the features of Recovery Manager (RMAN).
• Start Recovery Manager by using the RMAN command.
• Identify the events that occur during the connection process after the RMAN command is executed.
• Select the situations in which a recovery catalog is used.
• Identify the guidelines for creating a recovery catalog.
• Sequence the steps to create a recovery catalog.
• Select the control file characteristics that help in backup and recovery.
• Register a database in the recovery catalog by using RMAN.
• Reset the recovery catalog information to reflect the current state of the target database by using RMAN.
• Select the situations in which the recovery catalog must be resynchronized.
• Record information in the recovery catalog by using the CATALOG command.
• Maintain a recovery catalog by using the CHANGE command.
• Perform the operations to manage channel allocations.
• Identify the options for re-creating a recovery catalog.
• Write the commands to display information from the recovery catalog by using data dictionary views.
• Generate a report with the given requirements by using the REPORT command.
• Generate a report with the given requirements by using the LIST command.

Unit 4: Oracle Backup Methods

• Sequence the steps to perform a closed database backup.
• Perform an open database backup.
• Write the command to create a backup of a control file.
• Identify the issues associated with backing up a read-only tablespace.
• Differentiate between the Logging and Nologging options available for Direct-Load insert operations.
• Select the characteristics of an image copy.
• Select the tasks that RMAN performs in an image copy process.
• Identify the characteristics of a backup set.
• Select the tasks that RMAN performs to create a data file backup set.
• Identify the characteristics of the archive log backup process.
• Identify the constraints in performing a backup when using RMAN.
• Perform a backup by using a stored script.
• Identify the characteristics of an incremental backup.
• Identify the characteristics of a cumulative incremental backup.
• Select the memory utilization characteristics of RMAN.
• Identify the data dictionary views used for backups based on the activity and status information they display.
• Select 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

• Oracle8i Backup and Recovery: Troubleshooting and Recovery