Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database

Overview/Description
recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.2

Lesson Objectives

Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database

recognize the tools required and steps performed in identifying whether a recovery is necessary, and then recovering various types of database files.

recognize the features of the various options for moving data in Oracle Database 11g.

recognize the steps for importing, exporting, and moving data between Oracle databases using Oracle Data Pump.

recover the database from a media failure and move data using the Data Pump Wizard in a given scenario.

recognize the steps for using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems.

recognize the steps for searching MetaLink for new critical patches and for logging service requests.

recognize ways for managing and applying patches in Oracle Database 11g.