Oracle Database 10g: Administration Workshop I Part 4 Training CBT/CD-Rom

Price: $150.00

Online Training Course ID: CBT 88-67113

Training Course Description / Outline:

Oracle Database 10g: Administration Workshop I Part 4 Computer Based Training CBT Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques.

<="style1 style12">CBT Exam 1Z0-042

Learn To

• Identify benefits of undo data.
• Identify features of undo segments.
• Identify undo management tasks that a DBA should perform to use Undo efficiently.
• Match database failures with their possible causes.
• Identify features of instance recovery.
• Identify key concepts of tuning instance recovery.

Training Audience

The Oracle Database 10g: Administration Workshop I Part 4 target audience is Data Administrators, Technical consultants Support Engineers, and Sales Consultants.

Total Training Time

6 Hours

Training Objectives

Unit 1: Undo and Lock Management2 hours

• Identify benefits of undo data.
• Identify features of undo segments.
• Identify undo management tasks that a DBA should perform to use Undo efficiently.
• Identify features of undo retention.
• Identify the options that you can configure to size the undo tablespace.
• Identify features of locks.
• Identify features of lock conflicts.

<="Newsbody">Unit 2: Backup and Recovery 2 hours

• Match database failures with their possible causes.
• Identify features of instance recovery.
• Identify key concepts of tuning instance recovery.
• Identify the steps that are required for configuring a database to ARCHIVELOG mode.
• Identify tasks you should perform to configure a database for maximum recoverability.
• Identify features of backups.
• Identify features of Recovery Manager (RMAN).
• Identify options used to configure backup settings.
• Identify options that you can specify when scheduling backups.
• Identify features of control file trace backups.
• Identify options for managing existing backups.
• Identify features of database startup statuses for recovery.
• Identify the steps to recover from the loss of a single control file.
• Identify the steps to recover from loss of redo files.
• Identify steps involved in recovering from the loss of a data file.
• Identify enhancements in Oracle Database 10g for recovering dropped objects without performing recovery on the database.