Oracle 10g/11g Database Administration II Part 1

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

Your Price: $695

Video Title	Minutes
00: Course Introduction	8
01: Introduction to Oracle	14
02: Database Management Products	20
03: Database Creation Assistant	21
04: Oracle Architecture/ASM	23
05: ASM Disks/DiskGroups	16
06: Managing ASM Part 1	15
07: Managing ASM Part 2	13
08: Database Recovery	18
09: Flash Recovery Area	13
10: Recovery Catalog	17
11: Recovery Catalog Scripts and Databases	18
12: Administering the Recovery Catalog	19
13: RMAN Backups	22
14: RMAN Recovery	19
15: RMAN Critical Recovery	15
16: RMAN Incomplete Recovery	16
17: User Managed Recovery	23
18: Tuning RMAN	15
19: Additional RMAN Features	20
20: Recyclebin	10
21: Flashback Query	15
22: Flashback Data Archives	12
23: Flashback Database	14
24: Course Summary	6
Total:	6 hours 42 minutes

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

Your Price: $695

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Oracle Installation Guide
• Exercise Guide

Related Links

• Course Survey
• Oracle's Website
• Oracle Certification Requirements
• Exam Pricing and Locations

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

List Price: $995 Your Price: $695

Description

This Oracle online training course explains advanced Oracle database topics. Oracle 10g/11g Database Administration II Part 1 provides an in-depth look into Oracle’s backup and recovery architecture as well as advanced DBA issues, and discusses facets of advanced database administration tasks. This Oracle online training is designed for the Oracle database administrator with some experience.

In order to take this course you need to have taken Oracle 10g/11g Database Administration I Part1 and Part 2, Oracle 10g/11g: Introduction to SQL, Oracle 10/11g: Advanced SQL, Oracle 11g PL/SQL Programming Part 1 and Part 2 or equivalent experience.

Once you have completed the Oracle 10g/11g Database Administration II Part 1 the next course in this  series is Oracle 10g/11g Database Administration II Part 2.  Part 2 provides an in-depth look into Oracle’s advanced memory architecture, database advisors, and job scheduler. Click here to learn more about Oracle 10g/11g Database Administration II Part 2.

Objectives

As a result of taking this Oracle online course, you will be able to:

• Backup and Recover the Oracle Database
• Create a Recovery Catalog
• Use Oracle's Flashback features
• Perform Oracle managed recoveries
• Perform User managed recoveries
• Identify and correct block corruption
• Configure and ASM Instance

Related Training

• Course: Oracle 10g/11g Database Administration II Part 2
• Course: Oracle 10g/11g Database Administration I Part 1
• Course: Oracle 10g/11g Database Administration I Part 2

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

List Price: $995 Your Price: $695

Oracle 10g/11g Database Administration II Part 1 Outline

Module 00: Oracle 10g/11g Database Administration II Part 1 Online Training - Course Introduction

Module 01: Introduction to Oracle

• Oracle products
• Oracle Enterprise Solutions
• PeopleSoft
• Oracle Applications
• JD Edwards
• Siebel

Module 02: Oracle Database Management Products

• Oracle Universal Installer
• Oracle Enterprise Manager
• Oracle Grid Solution
• Oracle Database: Enterprise and Standard Editions

Module 03: Database Creation Assistant

• Database Utilities
• Database Configuration Assistant(DBCA)
• Networking Assistant(NETCA)
• Lab: Database Creation

Module 04: Oracle Architecture/ASM

• Oracle Instance
• SGA
• Background processes
• ASM instance architecture

Module 05: ASM Disks/DiskGroups

• ASM disks
• ASM diskgroups
• External
• Normal
• High

Module 06: Managing ASM Part 1

• Administer the ASM instance
• Add disks
• Rebalance disks
• Disk re sync
• •asmcmd

Module 07: Managing ASM Part 2

• ASM and SQL Plus
• ASM CMD
• ASM and Enterprise Manager

Module 08: Database Recovery

• Archivelog mode
• NoArchivelog mode
• Configure multiple archivelog destinations
• Lab: Archivelog mode

Module 09: Flash Recovery Area

• Configure flash recovery area
• Configure flashback database
• Lab: Archivelog and flashback mode

Module 10: Recovery Catalog

• Definition of recovery catalog
• Recovery catalog meta data
• Create the recovery catalog

Modules 11: Recovery Catalog Scripts and Databases

• Create recovery catalog scripts
• Register target databases
• Synchronizing the recovery catalog

Module 12: Administering the Recovery Catalog

• Backup the recovery catalog
• Configure recovery catalog settings
• Create a virtual private catalog

Module 13: RMAN Backups

• Backup sets
• Image copies
• Non-compressed backups
• Compressed backups
• Incremental backups
• Lab: Database backup

Module 14: RMAN Recovery

• Non-critical recovery
• RMAN restore/recover command

Module 15: RMAN Critical Recovery

• Recover a critical data file
• Incremental recovery
• Image copy recovery
• Recovery to an alternate location

Module 16: RMAN Incomplete Recovery

• Time based recovery
• Duplicate database
• Restoring a controlfile
• Recovery in NoArchivelog mode

Module 17: User Managed Recovery

• Complete database recovery
• Incomplete database recovery
• Backup the controlfile
• Backup database in archivelog/noarchivelog

Module 18: Tuning RMAN

• Multiple channels
• Long running backups
• Async I/O
• SYNC I/O

Module 19: Additional RMAN Features

• Cloning a database
• Tablespace Point in Time Recovery(TSPITR)

Module 20: Recyclebin

• Define the recyclebin
• Retrieve objects from the recyclebin
• Define protected objects in the recyclebin
• Lab: Creating a table drop and recover the table

Module 21: Flashback Query

• Undo_retention
• Flashback query
• Flashback versions query
• Flashback transactions query

Module 22: Flashback Data Archives

• Define flashback data archives
• Manage flashback data archives
• Flashback data archives administration

Module 23: Flashback Database

• Configure flashback database
• Monitor flashback database
• Perform flashback database

Module 24: Oracle 10g/11g Database Administration II Part 1 Online Training - Course Summary

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

List Price: $995 Your Price: $695

Prerequisites

You need to have equivalent experience or have taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2
• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

List Price: $995 Your Price: $695

System Requirements

Hardware:

• Windows XP or above
• 32-bit or 64-bit Processor
• 2 GB RAM minimum, 4 GB RAM preferred
• 10 GB free disk space

or

• Linux: Red Hat Linux, Oracle Linux, SUSE, or Ubuntu
• 32-bit or 64-bit Processor
• 2 GB RAM minimum, 4 GB RAM preferred
• 10 GB free disk space

Software:

Detailed set up will be provided with the course.

• Oracle Database Enterprise Edition
• Oracle 11g Release 2 for the appropriate operating system
• Oracle 11g Release 2 Grid infrastructure for appropriate operating system (Grid infrastructure software is not available for a Windows based system)

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

List Price: $995 Your Price: $695

Certification

Oracle 10g/11g Database Administration II Part 1 is part of a two-course online training series that helps you to prepare for Oracle's exam 1Z0-053. This course maps to Oracle's course, Oracle Database 11g: Administration II. When you pass exam 1Z0-053, you have completed a portion of the requirements towards the Oracle Database 11g Administrator Certified Associate certification.

For more information about the certification requirements, pricing, and locations select the link in the related training section.

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 1 Today!

List Price: $995 Your Price: $695

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.