• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle 10G Training Courses

Oracle Database 10g DBA - Part II

View course dates

Course Duration: 5 Days

Course Code: O10GDBAII

Course Description:

This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle10g databases.  This course is also suitable for delegates who need to be able to monitor and improve the database performance. 
 
This course introduces delegates to the main concepts of Oracle backup and recovery.  They will learn how to plan and implement a backup and recovery strategy using operating system backups, the import and export utilities and Recovery Manager.  Delegates will learn how to monitor and improve database performance.  They will also learn how to control database resources using Resource Manager, automate tasks with the Scheduler and use Automatic Storage Management (ASM).   This course covers the main topics of the Oracle exam #1Z1-043 Oracle Database 10g: Administration II.

Prerequisites:

A working knowledge of Oracle SQL*Plus and Oracle Database Administration. This can be gained by attendance on the Oracle SQL*Plus, and the Oracle Database 10g DBA - Part I courses.

Prerequisite courses:

SQL*Plus

Oracle Database 10g DBA - Part I

Relevant Certifications:

Oracle Database 10g Administrator

This course includes the following modules:

Topics Covered

• Plan a Backup Strategy
• Plan a Disaster Recovery Strategy
• Alter a Database to Archivelog and NoArchivelog Modes
• Online and Offline Backups
• Complete and Incomplete Database Recovery
• Recover a Database from Non-Critical Losses
• Perform Logical Backups with Export and Import Utilities
• Use RMAN to Perform Backups And Restore
• Use Flashback Technology to Recover a Database
• Use Flashback to Recover From User Errors
• Database Corruption
• Load Data into a Database
• Diagnostic Sources
• Use Automatic Database Management
• Monitor and Manage Storage
• Use Automatic Storage Management
• Monitor and Manage Memory
• Control Database Resources Using Resource Manager
• Automate Management Tasks with the Scheduler
• Secure the Oracle Listener
• Use Globalization Support

 

Location	Duration	RRP	Jul	Aug	Sep	Oct	Nov	Dec
Click on course date to make a booking, check availability, or find out about available discounts.
Birmingham	5 days	£1595		4 - 8		13 - 17		15 - 19
Bristol	5 days	£1595			29 - 3		24 - 28
Edinburgh	5 days	£1595				27 - 31
Leeds	5 days	£1595		11 - 15		20 - 24
London	5 days	£1595	28 - 1		8 - 12	13 - 17	10 - 14	15 - 19
Manchester	5 days	£1595		18 - 22			10 - 14

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course