back to Course Categories | back | print
Oracle10g Administration Workshop II (R1 and R2)          

Duration: 5 days

This class will focus on developing advanced skills necessary to manage an Oracle10g instance and database. This class covers Oracle10g Release 1 and Release 2 features. An emphasis will be placed on backup/recovery and recovery options and strategies in an Oracle10g environment. Students will learn backup and recovery using RMAN, Flashback technologies, the Recycle Bin, Automatic Storage Management, Oracle10g advisors, the Scheduler, Resource Management, Globalization and Network security will be covered. Through the numerous backup and recovery labs students will gain confidence that they can recover a database using the different available Oracle10g technologies. This class will prepare you for the Oracle Certified Professional exam.


  • Listener security management
  • Controlling database access
  • Securing EXTPROC
  • Globalization
  • Configuring NLS
  • Working with different locales
  • Linguistic sorts
  • Working with Datatime datatypes
  • Setting up time zones
  • Case and case insensitive sorts
  • Oracle10g memory structures
  • PGA Management
  • Memory advisors
  • Automatic Memory Management (AMM)
  • Managing Storage
  • Resumable statements
  • Tablespace management
  • Segment advisor
  • Monitoring indexes
  • Identifying unused indexes
  • Redo logfile size advisor
  • Oracle10g backup/recovery technologies
  • Configuring RMAN
  • Persistent settings
  • Retention policies
  • Control file autobackups
  • The Flash Recovery Area
  • Recovery Manager commands
  • Parallelization of backup sets
  • Compressing backups
  • Block change tracking
  • Monitoring RMAN backups
  • Copying a database
  • Cloning a database
  • 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
  • Configuring Flashback
  • Managing Flashback
  • Monitoring Flashback
  • Managing the Flash Recovery Area
  • Guidelines for 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
  • Recovery Options
  • Creating new temporary tablespaces
  • Recreating redo log files
  • Recovering an index tablespace
  • Loss of password authentication file
  • 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
  • Recovery from User errors
  • Recycle bin
  • Flashback dropped tables
  • Flashback versions query
  • Flashback transaction query
  • Flashback table
  • Using Flashback through OEM
  • Failsafe features
  • Log transport services
  • Database corruption
  • Using DBVerify for finding block corruption
  • Diagnostic information
  • The ANALYZE command
  • Block Media Recovery (BMR)
  • Trial recovery and block level recovery
  • Managing alerts through OEM
  • Alert notification
  • Defining thresholds
  • Trace files
  • Automatic Storage Management (ASM)
  • ASM Architecture
  • Features of ASM
  • Creating an ASM instance
  • Tablespaces and ASM
  • Managing ASM
  • Migrating a tablespace to ASM storage
  • Transporting tablespaces
  • Resource Management
  • Resource Consumer Groups
  • Resource Plans
  • Resource Plan Directives
  • Adaptive Consumer Group Mapping
  • Working with Sub-Plans
  • Working with the Scheduler
  • Scheduler jobs
  • Creating and managing schedules
  • Creating a Job Class
  • Setting priorities
  • Monitoring Jobs
  • Running jobs outside the database


  • Students need to have take the Oracle10g Administration Workshop I or have equivalent experience.


Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800

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