Training
Provided by 123-CBT Computer Based Training
Course Overview
This course 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.
- Diagnose errors and detect corruption by using different tools.
- Understand the recovery process for a database running in noarchive mode and recover a failed database.
- Understand the complete recovery process for a database in archivelog mode and perform complete recovery in various situations.
- 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.
- Import objects into a schema.
- 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.
- Manage standby database and identify the characteristics of the offline data files in a standby database.
Content Emphasis
Skills-Based
Audience
Network Administrators, Database Administrators, Technical Support Analysts, System Administrators, Application Developers, and MIS Managers. Prior to taking this course, participants should be familiar with SQL and PL/SQL Using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the Oracle8 Database Administration series, courses 61311, 61312, 61313, 61314, and 61315, and have taken the first part of the Oracle8 Backup and Recovery series, course 61321.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Failures and Troubleshooting
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 errors 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
- 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: Oracle 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 noarchivelog mode.
- Recover a failed database in the noarchivelog mode by using the ServerManager.
- Restore a database in noarchivelog mode by using RMAN.
- Identify the syntax of the RESTORE command.
- Sequence the recovery steps for archivelog mode database failure.
- Identify the recovery structures for an archive mode database.
- Identify the implications of archive mode recovery.
- Restore the archived logs to a new location by using the alter system command.
- Recover from a closed database failure.
- Identify the syntax of the recover data file command.
- Locate the data files needing recovery by using the dynamic performance views.
- Recover from an open database failure.
- Recover tablespace syntax.
- Identify the use of the v$datafile view.
- Recover a database from loss of data file that does not have a backup.
- Recover a failed database that had a file in hot backup mode.
- Identify the use of the v$backup view
- Recover from the loss of an online redo log file.
- Perform a complete recovery on an initially open database by using RMAN.
- Identify the use of the Set Newname command.
- Identify the implications of incomplete recovery.
- Identify the reasons for incomplete recovery.
- Identify the different types of incomplete recovery.
- Sequence the steps to perform an incomplete recovery.
- Perform a time-based recovery operation.
- Identify the syntax of the recover command.
- Perform a cancel-based recovery operation.
- Recover using a backup control file.
- Recover from loss of current redo logs in an open database.
- Recover from loss of current redo logs in a closed database.
- Perform an incomplete recovery on an initially open database by using RMAN.
Unit 3: Additional Backup and Recovery Methods
Duration: 2 Hour(s)
- Identify the uses of the Export and Import utilities.
- Match the levels of full database export with their purposes.
- Identify the three levels of full database export.
- Create an export file by using the command line interface.
- Identify the compatibility issues associated with the Export utility.
- Identify the characteristics of Direct-Path export and invoke Direct-Path export.
- Identify the characteristics of Direct Path Export.
- Invoke direct path export by using the command line interface.
- Identify the uses of the Import utility for recovery.
- Identify the functions of the modes available in the Import utility.
- Identify the modes available in the Import utility.
- Import objects into a schema by using the command line interface.
- Sequence the steps in which a table is imported.
- Identify the NLS considerations for the Export and Import utilities.
- Sequence the steps to start an Oracle database with a missing
- Identify the situations when you can start the database with missing data files.
- Identify the methods to enable parallel recovery activities.
- Identify the internal activities involved in the parallel recovery operations.
- Identify the situations when considerations must be taken for Read-Only tablespace recovery.
- Identify the methods to recover from loss of control file.
- Identify the situations in which a DBA is confronted with recovering or recreating control files.
- Identify the recovery methods for a corrupted data file.
- Identify the methods to recreate a lost recovery catalog.
Unit 4: Oracle Standby Database
Duration: 2 Hour(s)
- Identify the features of a standby database.
- Identify the need of a standby database.
- Identify the guidelines for using a standby database.
- Create a standby database by using Server Manager.
- Identify the steps of synchronizing the standby and primary databases.
- Activate the standby database by using Server Manager.
- Refresh the standby database control file by using Server Manager.
- Identify the implications on the standby database when the physical structure of the primary database is altered.
- Identify the characteristics of the offline data files in the standby database.
Training Avaliability and Delivery
| 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 |
|
Related Keywords:
oracle8
databases enterprise
oracle
information technology
ocdba8
oracle8 backup and recovery
cd web
1z0-015
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More Oracle8 Training from 123-CBT Computer Based Training
Click here for more information or to take this course
|
