Database 9i: Administration (DBA): Level 2

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

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