Database 9i: Administration (DBA): Level 2

Course Overview

Develop your ability to manage the industry's most advanced information system. Learn several methods to backup and to recover your Oracle database. Hands-on workshops give you experience in a realistic technical environment. Develop skills for basic network administration. Simplify your duties with Oracle Recovery Manager. This course gives the Oracle database administrator (DBA) a firm foundation in Oracle Net administration and backup and recovery operations.

Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server.

This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes two interactive workshops that provide participants with the opportunity to walk through numerous real-world networking, backup, and recovery case studies.

Audience

Database Administrators

Skills Gained

• Define networking requirements and the solutions provided by Oracle to implement these requirements
• Configure the network environment for an Oracle client-server system
• List the Oracle architecture components related to backup and recovery operations
• List the different backup methods and recovery operations that can be used to resolve database failure
• Perform backups both with and without RMAN
• Describe the database utilities
• Develop network configuration and recovery techniques through various workshop scenarios

Examinations

This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Prerequisites

Delegates should have completed course Oracle 9i DBA Fundamentals Level 1 and have an understanding of basic operating system commands (e.g. move, copy, delete files).

Course Outline

NETWORKING OVERVIEW:

• Network environment challenges; network configuration; Oracle 9i networking

BASIC ORACLE NET ARCHITECTURE:

• Oracle net connections; identifying key components of Oracle net architecture and their interaction

ORACLE NET SERVER-SIDE CONFIGURATION:

• The listener responses; configuring the listener; Listener.Ora file; starting and stopping the Oracle net listener; describing automatic instance registration; configuring the listener for IIOP and HTTP

BASIC ORACLE NET SERVICES CLIENT-SIDE CONFIGURATION:

• Configuring the Oracle net services client; Oracle net configuration assistant

USAGE AND CONFIGURATION OF THE ORACLE SHARED SERVER:

• Components of the Oracle shared server; Oracle shared server architecture; configuring shared servers; configuring dispatchers; identifying useful data dictionary views

BACKUP AND RECOVERY OVERVIEW:

• Basics of backup, restore and recovery; types of failures in an Oracle environment; backup/recovery

INSTANCE AND MEDIA RECOVERY STRUCTURES:

• Oracle processes, memory structures and files for recovery; checkpoints; redo log/archived log files

CONFIGURATION OF THE DATABASE ARCHIVING MODE:

• Archive log and no archive log mode configuration; automatic and manual archiving of redo log filesORACLE

RECOVERY MANAGER ARCHITECTURE:

• Components of RMAN; RMAN repository and control file usage; channel allocation; media management library interface; connecting to recovery manager; configuration of RMAN environment

USER-MANAGED BACKUPS:

• Describing user-managed backups and recovery operations; closed database backups; open database backups; backing up the control file; backup issues associated with 'read only' tablespaces; backup operations with no logging options; using DBVerify utility

RMAN BACKUPS:

• Identifying RMAN specific backups; using RMAN BACKUP command; backing up the control file; backing up the archived redo log files; using RMAN COPY commandUSER

MANAGED COMPLETE RECOVERY:

• Describing media recovery; performing recovery in no archive log mode; recovery in archive log mode; read-only table space recovery; relocating and recovering a table spaceRMAN

COMPLETE RECOVERY:

• Use of RMAN for restoration and recovery; recovery on archive log and no archive log mode

USER MANAGED INCOMPLETE RECOVERY:

• Steps of incomplete recovery; situations which require incomplete recovery; performing an incomplete recovery; recovering from the loss of current online redo logs

RMAN INCOMPLETE RECOVERY:

• Incomplete recovery using UNTIL TIME; incomplete recovery using UNTIL SEQUENCE

RMAN REPOSITORY MAINTENANCE:

• Cross-checking of backups and copies; making a backup exempt from the retention policy

RMAN CATALOG CREATION AND USAGE:

• Recovery catalog contents; additional features requiring recovery catalog; create recovery catalog; recovery catalog maintenance; creating storing and executing scripts; backup of recovery catalog

TRANSPORTING DATA BETWEEN DATABASES:

• Export; import; import/export considerations

LOADING DATA INTO A DATABASE

BACKUP AND RECOVERY AND NETWORKING WORKSHOP

Database 9i: Administration (DBA): Level 2 / ORD9i-A2