Oracle10g Administration (Part 2)
Categories: Oracle Courses
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Oracle10g Administration (Part 2)

Introduction:
One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This 5-day course presents all the standard failure scenarios and the best recovery strategies for each. Strategies for on-line backups, complete and incomplete recovery, media recovery vs. flashback database recovery and many other subjects are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.

Additionally, some of the most exciting new technologies ever released by Oracle are considered within this course. Subjects like the Database Scheduler, Flashback operations, Automatic Storage Management (ASM) and many others are included. This course book is filled with in-depth conceptual diagrams, hundreds of actual code examples, detailed exercises and complete solutions.

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database. Specific subjects to be considered are:

- Using flashback technology to recover from user errors and from database failures.
- Controlling resource utilization on database servers whose resource demand exceeds its capacity.
- Automating routine tasks and functions using the database Scheduler.
- Handling database corruption and even preventing such occurrences wherever possible.
- Utilizing diagnostic sources in troubleshooting database problems.
- Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
- Automatic resumption of database operations even in the face of failures and errors.
- User-managed and automatically managed backup strategies and database recovery operations. 

Audience:
Oracle database administrators

Prerequisites:
- Oracle 10g Introduction to SQL (Parts 1 and 2) or Oracle 10g Introduction to SQL (Accelerated)
- Oracle 10g Administration (Part 1)
- Some people may also find Oracle 10g Database Programming with PL/SQL helpful.

The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites. 

 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration5 days
 
£1,075.50
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).