back to Course Categories | back | print
Oracle9iR2: DBA Fundamentals II          

Duration: 5 days

Description 
In this class DBAs will learn the fundamentals of setting up Oracle Net Services, configuring the shared server architecture and backup and recovery. This class will cover different ways an Oracle9i instance and database can fail and the best options for recovery. Students will learn how to do backup and recovery with and without RMAN. Particpants will create all different kinds of backups. Students will learn how to minimize points of failure and reduce the Mean Time To Recover. Through the numerous backup and recovery labs students will gain confidence that they can recover a database after an Oracle9i server goes down. This class will prepare you for the Oracle9i Database: Fundamentals II certification test (#1Z0-032).

Topics

  • Reviewing how an Oracle9i server works
  • The Oracle Net Architecture
  • Understanding Oracle Net Services Server-Side
  • Understanding Oracle Net Services Client-Side
  • Understanding listeners
  • Oracle Net Manager
  • Dynamic Service Registration
  • Configuring the Listener for IIOP and HTTP Connections
  • Oracle Net troubleshooting
  • The Oracle Shared Server Architecture
  • Configuring Shared Servers
  • Configuring Dispatchers
  • Different types of backups and recovery options
  • Different ways a database can fail
  • How to recover from instance failure
  • Noarchivelog mode versus archivelog mode
  • Performing recovery in noarchivelog mode
  • Performing recovery in archivelog mode
  • Setting up multiple archive destinations
  • Logical versus physical backups
  • Read only tablespaces
  • Mirroring control files
  • Understanding recovery scenarios
  • Backup and recovery strategies
  • Configuration strategies
  • Complete and incomplete recovery
  • Restoring data files to different locations
  • Relocating and recovering a tablespace
  • Mirroring redo log files
  • Multiple remote archive log destinations
  • Standby databases
  • Point-in-time recovery
  • Change based recovery
  • Cancel based recovery
  • Using Oracle Flashback
  • Recovery Manager (RMAN)
  • Registering with the catalog repository
  • Resynchronizing the catalog and database
  • Creating a recovery catalog database
  • RMAN backup and recovery commands
  • RMAN long term, mirrored, and resumable backups
  • RMAN block media recovery
  • RMAN copy command for image backups
  • Using RMAN for incomplete recovery UNTIL TIME
  • Using RMAN for incomplete recovery UNTIL SEQUENCE
  • Using RMAN for complete recovery
  • Using RMAN scripts
  • RMAN list and report commands
  • Failsafe features
  • Trial recovery and block level recovery
  • Log transport services
  • Using DBVerify for finding block corruption
  • Transporting tablespaces
  • Using the export and import utilities

Prerequisites

  • Oracle9i Database Administration course or equivalent experience.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design