• Online, Self-Paced
Course Description

An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as media failure, user errors, and application errors. This course reviews the major architectural components of the Oracle Database 11g architecture, such as memory structures, background processes, and the logical and physical storage structures. This course also discusses how to prepare an Oracle Database 11g database for recovery and backup using RMAN, ARCHIVELOG mode, retention policies, and a Flash Recovery Area. This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.

Learning Objectives

Oracle Database Architecture

  • identify the characteristics of the database memory structures and process architecture
  • identify the characteristics of the database storage architecture
  • recognize the purposes of configuration and management DBA tools


Backup and Recovery Operations

  • recognize key characteristics of Oracle Database 11g's backup and recovery functionality
  • use Recovery Manager
  • configure ARCHIVELOG mode and retention policy for a database
  • configure the Fast Recovery Area in a database
  • configure the database for recovery


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Development