Oracle Database 11g Administration II (1Z0-053): 1 Using Oracle ASM
Description
This course discusses how Automatic Storage Management (ASM) can help manage disk space for all Oracle file types, including online and archived logs, RMAN backup sets, flashback logs, and even initialization parameter files (spfiles). This course examines what ASM is, how to configure an ASM instance, how to manage an ASM instance, and how to use ASM from within an Oracle database.
Objectives
- Describe Automatic Storage Management (ASM)
- Set up initialization parameter files for ASM and database instances
- Start up and shut down ASM instances
- Administer ASM diskgroups
Oracle Database 11g Administration II (1Z0-053): 2 Performing User-Managed Backups
Description
This course provides an overview of Oracle 11g backup and recovery.
Objectives
- Configure backup settings
- Configure multiple archive log file destinations to increase availability
- Identify the need of backup mode
- Perform user-managed backups and server-managed backups
- Back up and recover a control file
Oracle Database 11g Administration II (1Z0-053): 3 Performing User-Managed Database Recoveries
Description
This course shows you how to restore databases with user-based backups. It covers backups taken in NOARCHIVELOG mode and ARCHIVELOG mode.
Objectives
- Perform user-managed complete database recovery
- Perform user-managed incomplete database recovery
- Backup and recover a control file
- Recover from a lost TEMP file
- Recover from a lost redo log group
- Recover from the loss of a password file
Oracle Database 11g Administration II (1Z0-053): 4 Configuring and Backing Up Using RMAN
Description
This course provides an introduction to RMAN: its features and configuration and how to use it to back up your Oracle database.
Objectives
- Allocate channels to use in backing up
- Configure backup optimization
- Define, apply and use a retention policy
- Configure the Flash Recovery Area
- Use Flash Recovery Area
- Create image file backups
- Create a whole database backup
- Enable fast incremental backup
- Create duplex backup and back up backup sets
- Create an archival backup for long-term retention
- Create a multi-section compressed and encrypted backup
Oracle Database 11g Administration II (1Z0-053): 5 Using the RMAN Recovery Catalog
Description
This course provides an overview of RMAN recovery catalogs, which can make your life as a DBA easier by providing a centralized repository for RMAN-related data.
Objectives
- Identify situations that require an 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
Oracle Database 11g Administration II (1Z0-053): 6 Recovering Databases with RMAN
Description
This course provides an overview of the use of Oracle Recovery Manager RMAN for database backup and recovery.
Objectives
- Perform complete recovery from a critical or non-critical data file loss using RMAN
- Perform incomplete recovery using RMAN
- Recover using incrementally updated backups
- Switch to image copies for fast recovery
- Recover using a backup control file
Oracle Database 11g Administration II (1Z0-053): 7 Reporting, Monitoring, and Tuning with RMAN
Description
This course provides information on the reporting, monitoring, and tuning features available in RMAN.
Objectives
- Monitor RMAN sessions and jobs
- Tune RMAN
- Configure RMAN for Asynchronous I/O
- Report on and maintain backups
Oracle Database 11g Administration II (1Z0-053): 8 Performing Advanced Recovery
Description
This course covers advanced recovery topics, including RMAN incarnations, RMAN database duplication, tablespace point-in-time recovery, and disaster recovery for Oracle databases.
Objectives
- Restore a database onto a new host
- Perform disaster recovery
- Create a duplicate database
- Use a duplicate database
- Identify the situations that require TSPITR
- Perform automated TSPITR
Oracle Database 11g Administration II (1Z0-053): 9 Understanding Flashback Technology
Description
This course gives an overview of the functionality provided by Flashback technology in Oracle 11g, including the recovery of dropped objects, querying data as it existed at a point in time in the past, and returning the entire database to a point in time or SCN.
Objectives
- Restore dropped tables from the Recycle Bin
- Use Flashback Query and Flashback Transaction Query
- Perform Flashback Table operations
- Configure, monitor, and perform Flashback Database operations
- Set up and use a Flashback Data Archive
Oracle Database 11g Administration II (1Z0-053):10 Diagnosing the Database and Managing Performance
Description
This course introduces tools you can use to diagnose problems in a database, and then detect and resolve performance issues.
Objectives
- Set up Automatic Diagnostic Repository
- Use Support Workbench
- Perform block media recovery
- Use the SQL Tuning Advisor
- Use the SQL Access Advisor to tune a workload
- Recognize Database Replay
Oracle Database 11g Administration II (1Z0-053):11 Managing Database Resources
Description
This course describes how to effectively manage memory, space, and resources in Oracle 11g.
Objectives
- Implement Automatic Memory Management
- Configure SGA parameters
- Configure automatic PGA memory management
- Manage resumable space allocation
- Use segment shrink functionality to reclaim table and index space
- Create and use Database Resource Manager Components
Oracle Database 11g Administration II (1Z0-053):12 Using the Scheduler to Automate Tasks
Description
This course provides an overview of Oracle Scheduler and how to use it to manage jobs in the Oracle database.
Objectives
- 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
- Create Windows and Job Classes
- Use advanced Scheduler concepts to prioritize jobs
Oracle Database 11g Administration II (1Z0-053):13 Implementing Globalization Support
Description
This course explains how Oracle\'s globalization support lets you manage data in multiple native languages within the same database instance and simplifies global application development.
Objectives
- Customize language-dependent behavior for the database and individual sessions
- Work with database and NLS character sets
Oracle Database 11g Administration II (1Z0-053):14 Practice Exam 1
Description
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.
Objectives
- Complete the practice exam questions
Oracle Database 11g Administration II (1Z0-053):15 Practice Exam 2
Description
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.
Objectives
- Complete the practice exam questions
Oracle Database 11g Administration II (1Z0-053):16 Practice Exam 3
Description
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.
Objectives
- Complete the practice exam questions
Oracle Database 11g Administration II (1Z0-053):17 Practice Exam 4
Description
This course presents questions that will help you prepare for the Oracle Database 11g Administration II (1Z0-053) exam.
Objectives
- Complete the practice exam questions