Custom Oracle10g: Administration II –
TRAINING INSTITUTE
Backup/Recovery and Networking (5 Days)
Custom Training Institute Oracle10g: Administration II –
9085 Coyote Springs Road Module 2: Configuring Recovery
Backup/ Recovery and Networking Manager (RMAN)
Prescott Valley, AZ 86315 (CTI 215)
(928) 772-3811 Configuring Database Parameters that
This course covers intermediate to advanced Affect RMAN Operations
FAX (928) 441-6444
topics in Oracle10g database administration, Changing RMAN Default Settings with
and is designed to prepare students for their CONFIGURE
Oracle Certified Professional (OCP) exam. Managing RMAN's Persistent Settings
Students will learn how to configure the Starting the RMAN Utility and
Oracle 10g database for multilingual support; Allocating Channels
how to recover databases using RMAN, SQL
and Flashback techniques; how to monitor Module 3: Recovering from User Errors
and improve database performance; and how Recovering Dropped Tables using
to use supporting database technologies such
Flashback Technology
as the Resource Manager, the Scheduler, and
Performing Flashback Table Operations
Automatic Storage Management.
Managing the Recycle Bin
Flashback Versions Query
Prerequisites: Successful completion of Flashback Transaction Query
"Oracle 10g: Administration I" course.
Module 4: Database Corruption
Minimum hardware requirements (per Defining Block Corruption
student): Windows Server 2003 or Windows Causes and Symptoms of Block
XP Pro; minimum 512 MB RAM (1 GB Corruption
preferred); minimum of 2 GB of free space on Using the ANALYZE Command
hard drive (before installation). Machines Using DBVERIFY
need static IP addresses. Detecting Database Corruptions using
DBMS_REPAIR
Software requirements: Oracle10g for 32-bit Implementing
Windows. DB_BLOCK_CHECKING
Parameter to Detect Corruptions
Microsoft PowerPoint and Internet Repairing Corruptions using RMAN
connection installed at instructor’s
workstation for presentation purposes. Module 5: Automatic Database
Management
Database Advisors
Module 1: Using Globalization Support
Objectives SQL Tuning Advisor
Language-Dependent Behavior Automatic Undo Retention Tuning
Native Language Support (NLS)
Module 6: Using Recovery Manager
Configuration
RMAN BACKUP
Linguistic Sorting
Tracking Changed Blocks
Datetime Datatypes
Managing Backups and Image Copies:
Case-Insensitive and Accent-Insensitive
LIST and REPORT
Sorts
Globalization Support and Configuration Module 7: Recovering from Non-Critical
Information Losses
Recovery of Temporary Tablespaces
Recovery Redo Log Members
Recovery of Index Tablespaces
Recovery of Read-Only Tablespaces
Recreating Password File
Rev: 7/24/08 www.CustomTraining.com
Module 8: Monitoring and Managing Module 12: Flashback Database
Storage Determining Flashback Technology to
Tuning Redo Writing and Archiving Use for Each Recovery Situation
Operations Configuring and Using Flashback
Issuing Statements Suspendable upon Database
Oracle Database Encountering Space Condition Errors Monitoring Flashback Database
10g: Administration Proactively Managing Tablespace Usage Using Enterprise Manager Recovery
Using the Segment Shrink Functionality Wizard to Flashback Database
II – Backup/ Estimating Size of New Table and Indexes Managing and Maintaining Flash
Recovery and Improving Performance of Queries using Recovery Area
Networking (CTI 215) - Different Storage Options
Rebuilding Indexes Online Module 13: Managing Resources
continued Configuring the Resource Manager
Module 9: Automatic Storage Management Assigning Users to Resource Manager
(ASM) Groups
Setting Up Initialization Parameter Files Creating Resource Plans within Groups
for ASM Specifying Directives for Allocating
Executing SQL Commands with ASM File Resources to Consumer Groups
Names
Starting Up and Shutting Down ASM Module 14: Automating Tasks with the
Instances Scheduler
Administering ASM Disk Groups Simplifying Management Tasks by
Migrating Database to ASM using RMAN Using the Scheduler
Creating a Job, Program, Schedule and
Module 10: Monitoring and Managing Window
Memory Reusing Scheduler Components for
Implementing Automatic Shared Memory Similar Tasks
Management Viewing Information about Job
Manually Configuring SGA Parameters for Executions and Job Instances
Various Memory Components
Automatic PGA Memory Management
Module 11: Performing Critical Database
Recoveries
Recovery of the Control File
Reasons for Incomplete Recovery
Performing Incomplete Recovery using
Enterprise Manager
Performing Incomplete Recovery using
RMAN
Performing Incomplete Recovery using
SQL
Performing Database Recovery Following
a RESETLOGS Operation
Rev: 7/24/08 www.CustomTraining.com