|
Provided by: 123-CBT Computer Based Training Oracle8i Backup and Recovery Troubleshooting Recovery |
 |
Course Overview
Oracle's computer-based training course Oracle8i Backup and Recovery: Troubleshooting and Recovery is the second course in a two part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to recover from the loss of a Recovery Catalog and Control File. Finally, this course will present the features and usage guidelines of a standby database and how to manage one.
Learn To:
- Identify the ways of handling different types of errors.
- Identify and diagnose errors and detect corruption by using different tools.
- Identify and understand the recovery process for a database running in noarchive mode and recover a failed database.
- Identify and understand the complete recovery process for a database in archivelog mode and perform complete recovery in various situations.
- Identify and understand the incomplete recovery process for a database in archive mode and perform incomplete recovery in various situations.
- Identify the uses, modes, levels and compatibility issues of Export utility, and use the Export utility to create an export file.
- Identify the uses, modes and NLS considerations of the Import utility, and the steps in which a table is imported.
- Identify and import objects into a schema.
- Identify and sequence steps to start an Oracle database with a missing data file.
- Identify the methods to enable parallel recovery, recover from lost control file, Recovery Catalog, data file corruptions.
- Identify the features and usage guidelines of standby database.
- Identify and manage standby database
- Identify the characteristics of the offline data files in a standby database.
Content Emphasis
Skills-Based
Audience
Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Backup and Recovery: Strategies and Backups (63321). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 3, 1Z0-025.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle Recovery Methods
Duration: 1 - 2 Hour(s)- Identify the ways of resolving statement failure.
- Identify the causes of statement failure.
- Identify the ways of resolving user process failures.
- Identify the causes of user process failures.
- Identify the ways of resolving user error failures.
- Identify the causes of user error failures.
- Identify the recovery process in an instance failure.
- Identify the causes of instance failure.
- Identify the ways of resolving a media failure.
- Identify the causes of media failure.
- Identify a database failure error condition by diagnosing an alert file.
- Identify the features of an alert file.
- Identify a database failure error condition by diagnosing a trace
- Identify the features of a trace file.
- Identify the use of the checksum parameters.
- Verify the integrity of a data file by using the DBVERIFY utility.
- Identify the features of the DBVERIFY utility.
Unit 2: Additional Backup and Recovery Methods
Duration: 1 - 2 Hour(s)- Identify the files to be restored for a database in the noarchivelog mode.
- Identify the implications of recovering a database in the noarchive
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
