DBA Part II - Backup & Recovery and Networking

5 Day Course
Code OBRN

Newer versions of this course are available on either Oracle versions 10g or 11g.

Modules

Topics Covered (30 topics)

  • Backup and Recovery Strategies
  • Disaster Recovery Plan
  • Failure Scenarios
  • Oracle Recovery Structures and Processes
  • Using ARCHIVELOG and NOARCHIVELOG Modes
  • Physical Backups
  • Complete Database Recovery
  • Incomplete Recovery with Archiving
  • Additional Recovery Issues
  • The Export and Import Utilities
  • Loading Data with SQL*Loader
  • Troubleshooting Utilities
  • Recovery Manager Overview
  • Creating and Maintaining a Recovery Catalog
  • Backing up and Restoring with RMAN
  • Data Guard
  • Oracle Networking Overview
  • Configuring the Oracle Network
  • Oracle Net Architecture
  • Net Configuration
  • Oracle Net Manager
  • Oracle Net Configuration Assistant
  • Net Server Side Configuration
  • Net Client Side Configuration
  • Listener Configuration using Oracle Net Manager
  • Configuration of Net Service Names
  • Configuration of the Oracle Shared Server
  • Overview of Oracle Internet Directory
  • Troubleshooting the Network Environment
  • Network Environment Security

Prerequisites

A working knowledge of SQL*Plus and an understanding of Oracle database administration is required. This can be obtained by attendance on the Pre-Requisite courses. A good working knowledge of operating system commands is also required. Pre-Requisites Courses: SQL*Plus (OSP) and DBA Part I - Architecture & Administration (ODA). Note: Before taking any exam, ensure you have the recommended experience.

Sections