Oracle 10g Database Administration

ProTech Professional Technical Services Canada, Ltd.
Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This class will focus on developing advanced skills necessary to manage an Oracle 10g instance and database. An emphasis will be placed on backup/recovery and recovery options and strategies in an Oracle 10g environment. Students will learn backup and recovery using RMAN, Flashback technologies, the Recycle Bin, Automatic Storage Management, Oracle 10g 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.

Audience: This course is designed for Oracle Administrators.

Topics:
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
Oracle 10g 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
Oracle 10g 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
DBMS_REPAIR
Block Media Recovery (BMR)
Trial recovery and block level recovery
Managing alerts through OEM
Alert notification
Defining thresholds
Trace files
Prerequisites: Students need to have take the Oracle 10g Administration Workshop I or have equivalent experience.
...''

Phone:866-821-9311

School Address:

111 Peter Street
Suite 626
Toronto, ON M5V 2H1 Canada

Jobs & Resumes: Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg
Houses & Roommates: Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg

Java Programming Essentials Using Eclipse
Advanced Java Programming
Java Server Pages Programming with BEA WebLogic
Java Server Pages
Java Servlet Programming
JavaServer Faces Development
Linux System Administration
MySQL Administration and Management
OOAD with UML
Oracle 10g Application Tuning
Oracle 10g Database Performance and Tuning
Oracle 10g New Features for Administrators
Oracle 10g SQL & SQL*Plus
Project Management Fundamentals
Project Management Leadership Skills

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.