Certification Exam Prep Seminar: Oracle Database Administration II

This video seminar – Certification Exam Prep Seminar: Oracle Database 10g/11g Administration II - will help you be more confident to take either of the following Oracle Database certification exams:

• Oracle Database 11g: Administration II exam (1Z0-053)
• Oracle Database 10g: Administration II exam (1Z0-043)

Oracle Database 10g and/or 11g Administrator Oracle Certified Professional (OCP) certification with this comprehensive Exam Preparation Seminar. Led by one of our Oracle Database expert instructors, this fast-paced seminar will help increase your confidence by providing you with exclusive tips and strategies for preparing and taking the exam.

This Exam Preparation Seminar is intended to help those with a solid foundation in Oracle Database administration. It provides a thorough review of the exam objectives and helps each student understand the topics and breadth required to become certified on Oracle Database administration.

The seminar may be accessed for repeated review as needed during subscription term. Completion of this seminar does not guarantee exam performance. Exam Prep Seminars do not include: an Oracle University eKit, expert video, labs, student environment, simulations, student Q&A. Please note that this seminar is for exam review purposes only and does not meet the Hands-on Course training requirement (if applicable to your certification track).

Audience

• Database Administrators
• Database Designers
• Project Manager
• Sales Consultants
• Support Engineer
• Technical Consultant

Course Topics Database Architecture and ASM

• Describe Automatic Storage Management (ASM)
• Start up and shut down ASM instances
• Administer ASM disk groups
• Use RMAN to migrate your database to ASM
• Execute SQL commands with ASM file names

Performing User-Managed Backup and Recovery

• Perform user-managed and server managed backups
• Identify the need of backup mode
• Perform user-managed complete database recovery
• Perform user-managed incomplete database recovery
• Recover from a lost TEMP file and Recover from a lost redo log group
• Recover from the loss of password file
• Recovering a Read-Only Tablespace and Recovering from a Lost Index Tablespace
• Back up and recover a control file

Configuring for Recoverability

• Configure multiple archive log file destinations to increase availability
• Define, apply and use a retention policy
• Configure the Flash Recovery Area
• Use Flash Recovery Area
• Describe the RMAN repository and recovery catalog

Using the RMAN Recovery Catalog

• Identify situations that require RMAN recovery catalog
• Create and configure a recovery catalog
• Synchronize the recovery catalog
• Create and Use RMAN stored scripts
• Back up the recovery catalog
• Create and use a virtual private catalog

Configuring Backup Specifications

• Configure backup settings
• Describe the Media Management Library interface
• Allocate channels to use in backing up
• Configure backup optimization

Using RMAN to Create Backups

• Use the RMAN BACKUP command to create backup sets
• Create image file backups
• Create a whole database backup
• Enable fast incremental backup and block change tracking
• Create duplex backup and back up backup sets
• Create a multisection,compressed and encrypted backup
• Create an archival backup for long-term retention
• Report on and maintain backups

Using RMAN to Perform Recovery

• Perform complete recovery from a critical or noncritical data file loss using RMAN
• Perform incomplete recovery using RMAN
• Recover using incrementally updated backups
• Switch to image copies for fast recovery
• Restore a database onto a new host
• Recover using a backup control file
• Perform Disaster recovery

Using RMAN to Duplicate a Database

• Using a duplicate database
• Creating a duplicate database

Performing Tablespace Point-in-Time Recovery

• Identify the situations that require TSPITR
• Perform automated TSPITR

Monitoring and Tuning RMAN

• Monitoring RMAN sessions and jobs
• Tuning RMAN
• Configure RMAN for Asynchronus I/O

Using Flashback Technology and Additional Flashback Operations

• Restore dropped tables from the recycle bin
• Perform Flashback Query
• Use Flashback Transaction
• Perform Flashback Table operations
• Configure, Monitor Flashback Database and Perform Flashback Database operations
• Set up and use a Flashback Data Archive

Diagnosing the Database

• Set up Automatic Diagnostic Repository
• Detect database corruption
• Perform Block Media Recovery

Managing Memory

• Implement Automatic Memory Management
• Manually configure SGA parameters
• Configure automatic PGA memory management

Managing Database Performance

• Use the SQL Tuning Advisor
• Use the SQL Access Advisor to tune a workload
• Understand Database Replay

Space Management

• Describe the concepts of transportable tablespaces and databases
• Reclaim wasted space from tables and indexes by using the segment shrink functionality
• Manage resumable space allocation

Managing Resources

• Understand the database resource manager
• Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

• Create a job, program, and schedule
• Use a time-based or event-based schedule for executing Scheduler jobs
• Create lightweight jobs
• Use job chains to perform a series of related tasks

Administering the Scheduler

• Create Windows and Job Classes
• Use advanced Scheduler concepts to prioritize jobs

Automatic Performance Management

• Diagnose database performance issues
• Use asynchronous COMMIT effectively

Managing Schema Objects

• Determine appropriate table types for your requirements: heap, partition, IOT, or cluster
• Perform DBA tasks on schema objects

Database Security

• Implement Transparent Data Encryption (TDE)
• Describe Data Pump (DP) encryption
• Identify components of Recovery Manager (RMAN)–encrypted backups
• Define basic concepts of a Virtual Private Database (VPD)
• Apply a column-level VPD policy

Using Globalization Support

• Determine a correct database character set that meets your business requirements
• Obtain globalization support configuration information
• Customize language-dependent behavior for the database and individual sessions
• Specify different linguistic sorts for queries
• Retrieve data that matches a search string ignoring case or accent differences

Course Objectives

• Review key technologies and certification concepts tested in the
• Prepare for your Oracle certification exam
• Get information that will help you complete your preparation and study
• Receive tips and information that will help you on the test
• Understand the depth and breadth of the
• Learn from one of Oracle University's top instructors