Oracle 10g DBA OCP Preparation Class
Exam 2

A five-day on-site Oracle Certified Professional OCP Training Course
Test 1Z1-043
© 2007-2013 by Burleson Consulting

This course is taught at your Company site with up to 20 students.  Click here for on-site course prices

* Understand OCA concepts. * Learn Oracle 10g RMAN. * Employ Database Recovery. * Use Oracle Automation Utilities. * Understand Oracle10g DBA Monitoring & Management.

The primary goal is this course is to prepare the students to pass the Oracle10g OCP Database Administration exam 2, test 1Z1-043 This Oracle10g OCP course is an intensive 5-day course is designed to provide Oracle professionals with an in-depth understanding of the DBA concepts and knowledge required for the Oracle10g OCP exam, and tips and techniques for passing the Oracle10g OCP exam. This course covers all of the Oracle10g Database Administration topics on the OCP exam including globalization, RMAN, database recovery with flashback and uaing the Oracle automation utilities such as AMM and ASM. exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle10g OCP exam.  In addition, this course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle DBA concepts. This Oracle 10g OCP DBA exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle 10g database administration.  This includes Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand the architecture of an Oracle database.  The course assumes a basic knowledge of computer programming techniques, relational database concepts, SQL, and basic Oracle architecture. Also Note prerequisite training for Oracle10g OCA exam.

This Oracle OCP training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Consulting instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle tuning training.

Learning Objectives:

The primary objective of this Oracle10g OCP training is to provide each student with the knowledge and testing secrets for passing the Oracle10g OCP practicum test.  The student will gain confidence in their Oracle DBA knowledge and learn the tricks and traps of the Oracle10g OCP DBA exam.

Using a proven training combination of intense instruction, practicum and numerous Oracle10g OCA sample exam questions, the student should have a firm understanding of Oracle10g Database Administration.  The student will successfully install and configure a working Oracle database, create tablespaces and files, manage security and user access and learn basic performance tuning.

Oracle10g Database Administration OCP
Exam 2 Preparation

DAY 1 - Review of OCA concepts

Oracle10g Globalization

Customizing language-dependent behavior for the database and individual sessions
Specifying different linguistic sorts for SQL queries
Using the datatime datatypes
Querying data using case insensitive and accent insensitive searches
Obtain Globalization support configuration information

Oracle Listener Security

Securing the listener
Remove default EXTPROC entry and add a separate listener to handle external procedure calls

DAY 2 - Oracle 10g RMAN

Configuring Recovery Manager

Configure database parameters that affect RMAN operations
Change RMAN default settings with CONFIGURE
Manage RMAN's persistent settings
Start RMAN utility and allocate channels

Using Recovery Manager

Use the RMAN BACKUP command to create backup sets and image copies
Enable block change tracking
Manage the backups and image copies taken with RMAN with the LIST and REPORT commands

DAY 3 - Database Recovery

Recovery Diagnostic Sources

Use the alert log and database trace files for diagnostic purposes
View alerts using Enterprise Manager
Adjust thresholds for tracked metrics
Control the size and location of trace files

Recovering from Non-Critical Losses

Recover temporary tablespaces
Recover a redo log group member
Recover index tablespaces
Recover read-only tablespaces
Recreate the password file

Database Recovery Practicum

Recovering the control file
Reasons for incomplete recovery
Perform an incomplete recovery using EM
Perform an incomplete recovery using RMAN
Perform an incomplete recovery using SQL
Perform database recovery following a RESETLOGS operation


Flashback Database

Determine which flashback technology to use for each recovery situation
Configure and sue Flashback Database
Monitor the Flashback Database
Use the Enterprise Manager Recovery Wizard to flashback database
Manage (or maintain) the Flash Recovery Area

Recovering from User Errors

Recover a dropped table using Flashback technology
Perform Flashback table operation
Manage the recycle bin
Recover from user errors using Flashback versions query
Perform transaction level recovery using Flashback Transaction query

Dealing with Database Corruption

Define block corruption and list its causes and symptoms
Detect database corruptions using the following utilities: ANALYZE
DBVERIFY
Detect database corruptions using the dbms_repair package
Implement the DB_BLOCK_CHECKING parameter to detect corruptions
Repair corruptions using RMAN

DAY 4 - Oracle Automation Utilities

Automatic Database Management

Use the Database Advisors to gather information about your database
Use the SQL Tuning Advisor to improve database performance
Use automatic undo retention tuning

Monitoring and Managing Storage

Tune redo writing and archiving operations
Issue statements that can be suspended upon encountering space condition errors
Reduce space-related error conditions by proactively managing tablespace usage
Reclaim wasted space from tables and indexes using the segment shrink functionality
Estimate the size of new table and indexes
Use different storage options to improve the performance of queries
Rebuild indexes online

Automatic Storage Management (ASM)

Set up initialization parameter files for ASM and database instances
Execute SQL commands with ASM file names
Start up and shut down ASM instances
Administer ASM disk groups
Use RMAN to migrate your database to ASM

DAY 5 - Oracle10g DBA Monitoring & Management

Monitoring and Managing Memory

Implement Automatic Shared Memory Management
Manually configure SGA parameters for various memory components in the SGA
Use Automatic PGA Memory Management

Managing Oracle10g Resources

Configure the Resource Manager
Assign users to Resource Manager groups
Create resource plans within groups
Specify directives for allocating resources to consumer groups

Automating Tasks with dbms_scheduler

Simplify management tasks by using the Scheduler
Migrating from dbms_job
Create a job, program, schedule, and window
Reuse Scheduler components for similar tasks
View information about job executions and job instances