Course 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.
In This Course You Will Learn:
- 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
Prerequisites
You need to have equivalent experience or have taken the following GogoTraining courses:
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
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.