Oracle 11g: Administration II eLearning

Course Topics

Oracle Database 11g: Database Architecture and ASM

• Characteristics of elements of the Oracle Database 11g architecture
• Managing database files using Automatic Storage Management (ASM) and disk groups
• Ways to manage disk groups and their attributes and to configure and manage ASM instances
• Managing ASM storage, scalability, and performance using the ALTER command and the ASMCMD utility
• Create an ASM instance and disk group and use the ASMCMD to view disk group data

2. Oracle Database 11g: Configuring for Recovery

• Benefits of Oracle Database 11g’s backup and recovery functionality
• Configuring a database for backup
• Configuring the Flash Recovery Area
• Creating an RMAN recovery catalog and using it to store database backups
• Resynchronizing a recovery catalog, using RMAN stored scripts, and backing up a recovery catalog
• Create and configure a recovery catalog and register a database in the recovery catalog in a given scenario

3. Oracle Database 11g: Configuring for Backups

• Preparing and optimizing a database for a backup
• Creating fast incremental backup and duplex backup sets using RMAN
• Creating archival and multisection backups and compressing and encrypting backups using RMAN
• Backing up to sequential media, such as tape drives, and using reports and views to monitor backups
• Different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario
• Steps involved in a complete and an incomplete recovery and for performing a user-managed backup
• Performing different types of user-managed recoveries
• Back up a database and recover a lost online redo log file in a given scenario

4. Oracle Database 11g: Using RMAN for Recovery

• Performing a complete recovery using RMAN
• Using RMAN to perform an incomplete recovery, restore a database to a new host, and perform a disaster recovery
• Using RMAN to recover a database in a given scenario
• Creating a duplicate database using RMAN and Enterprise Manager
• Performing a tablespace point-in-time recovery (TSPITR)
• Clone a database and complete a tablespace point-in-time recovery (TSPITR) in a given scenario

5. Oracle Database 11g: Supporting RMAN and Using Flashback Technology

• Monitoring RMAN
• Benefits of RMAN backup and restore operations in terms of performing RMAN tuning operations, such as multiplexing
• Performing RMAN tuning operations
• Enabling flashback features and using the recycle bin in Oracle Database 11g
• Using flashback to query data, retrieve versions of rows, view changes made at the transaction level, and reverse a transaction
• Use flashback to reverse a transaction in a given scenario
• Recovering a set of tables or an entire database to a specific point in time, using Flashback Tables and Flashback Database
• Using guaranteed restore points, monitoring Flashback Database, and tracking and archiving data with Flashback Data Archive

6. Oracle Database 11g: Diagnosing the Database and Managing Memory

• Viewing diagnostic data and incidents associated with a database problem via Automatic Diagnostic Repository and Support Workbench
• Creating a service request (SR) for an incident, packaging and uploading the associated diagnostic data to Oracle Support, and monitoring your database’s health
• Handling block corruption and detecting, analyzing, and repairing failures with the help of Data Recovery Advisor
• Functions of different memory structures in Oracle Database 11g
• Enabling and monitoring automatic memory management (AMM) and enabling, configuring, and disabling automatic shared memory management (ASMM)
• Controlling automatic memory management in the PGA and for sizing the SGA and PGA
• Guidelines for efficient memory usage
• Enable automatic memory management and view automatic memory settings in a given scenario

7. Oracle Database 11g: Database Performance and Space Management

• Tuning steps required to establish the Oracle Database 11g environment
• Monitoring and managing session performance using Enterprise Manager, views, Automatic Workload Repository (AWR) statistics, and SQL advisors
• Using the SQL Tuning Advisor and SQL Access Advisors to analyze SQL statements and improve data retrieval
• General steps required to capture a production workload and replay it in a test environment using the Database Replay feature
• Tune a high load SQL statement using the SQL Tuning Advisor
• Generally managing and monitoring space in Oracle Database 11g
• Shrinking segments and reclaiming available space using the Segment Advisor and resumable statements
• Moving large volumes of data between two Oracle Database 11g databases using transportable tablespaces

8. Oracle Database 11g: Managing Resources and Task Automation

• Accessing and creating resource plans and consumer groups using the Database Resource Manager
• Planning and monitoring resource allocation to consumer groups using resource plan directives
• Use the Database Resource Manager to address system resource utilization and control in a given scenario
• Using the Scheduler to create, schedule, and monitor regular and lightweight jobs
• Distinguish between time-based and event-based schedules for executing jobs and job chains using the Scheduler
• Performing advanced Scheduler administration to manage job windows, prioritize jobs, and make the best use of resources

9. Oracle Database 11g: Globalization

• Selecting the database character set that meets your needs and specifying language-dependent behavior
• Performing and customizing linguistic searches and sorts
• Performing multiple character set conversions and scanning an unknown file set to determine its language
• Modify language, date, and time formats for a session and perform a linguistic sort in a given scenario

Supplemental Assets:

Lab Simulations: Task-based multipath scenarios provide realistic practice of technology subjects or applications, where applicable.

Pre and Post Courseware Assessments: Section-based assessments offer a range of practice and testing options within the section, including feedback and tracking.

Test Prep Exams: Practice tests will help you prepare for a certification exam. You can take a test prep exam in Study Mode (where you receive feedback after each question) or in Certification Mode (designed to mimic a certification exam) as many times as you want.

Mentoring: Mentors are available to help students with their studies for certification exam. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.