Oracle Database 11g: Backup, Recovery and Tuning

In this course, the concepts and architecture on which the backup and recovery is based, along with the steps related to this process in various situations, are covered in detail. This includes how to define and test backups and restore in various scenarios.
Students will also learn how to manipulate the memory structures efficiently and perform performance evaluations, including the use of some advisors. All types of flashback technologies, job scheduling and system resource control are also covered.
In the second part of the course students will learn how to use the automated tuning functionality of the Oracle 11g database such as SQL Tuning Advisor, SQL Access Advisor, automatic Workload repository and automatic Database diagnostics Monitor as well Practicing these tuning methods. The second part of the course is based on the tuning tasks expected from a DBA: reactive tuning and maintaining the performance of SQL statements as well as the tuning of Oracle's system components.

This course will give participants the capabilities to:
• Achieve backups and data restorations using RMAN and Enterprise Manager utilities
• Configure the Oracle database for optimal restoration in any situation
• Identify resource-consuming sessions and SQL code chunks with performance issues
• Configure the database instance so that the resources are properly allocated
• Program jobs in the database
• Use statistics and metric database to identify a performance problem
• Interpret tuning diagnostics
• Identify and eliminate performance problems
• Identify SQL statements with problems

Course Schedule:

1. Database architecture and ASM (Automatic Storage Management)
Database architecture
General architecture of ASM
Creating an ASM instance
Managing users of ASM using EM
Concepts of ASM
ASMCMD Utility
Performance of ASM

2. Restore Configuration
Typical tasks in scenario backup/recovery
Working with Recovery Manager (RMAN)
Using the Flash Recovery Area
Flash Recovery Area Management

3. Using a Recovery catalog for RMAN
RMAN Repository: Options
Keeping information about Backup in Recovery catalog
Registering a database in Recovery catalog
Resync Recovery Catalog
Using the RMAN stored scripts
Backup/Recovery for recovery Catalog

4. Configuring Backup Specs
Using RMAN to create backups
Configuring persistent RMAN Settings
Configuring RMAN
Auto-Backup for control files
RMAN Persistent Settings Management
Configuring Backup Devices
Configuring and allocating channels for use in backups
Configuring Backup Optimization

5. Creating backups
Oracle-Suggested backups
Creating Backup Sets & Image Reviews
Create a full backup
Backup types in RMAN
Monitoring of changes in blocks
Backups for archiving
Encrypt backup

6. Perform backup/restore operations by users
Restoration and recovery
Critical and non-critical losses
Restore after loss of a temporary file (TEMPFILE)
Recreating Indecsilor
Restoration after loss of Tablespace INDECSI
Authentication Methods for DBA
Restoring a read-only tablespace

7. Using the RMAN utility to restore
Using RMAN commands: Restore and recover
Restoring your database using Enterprise Manager
Restoring your database using incremental backups
Making a FastSwitch to a copy image
Restoring the database to another server
Disaster restoration

8. Using RMAN to duplicate the database
Create a duplicate database
Creating pfile for the new instant
Allocation of channels required
Understanding the duplication operation
Using Enterprise Manager to clone a database
Cloning a database started

9. Realization of restorations of tablespace in time
How to use the restoration of tablespace in time
Using Enterprise Manager to achieve restorations in time

10. Monitoring and optimizing the RMAN utility
Parallelization Backups
Monitoring RMAN Sessions
Interpretation of RMAN Results
Optimizing RMAN
Multiplezarea RMAN

11. Using Flashback Technology
Description of Flashback Technology
Transactions and UNDO
Securing UNDO Retention
Preparing the database for Flashbak restorations
Drop Flashback and Recycle Bin

12. Using Flashback Database
Flashback Table
Starting Row-Movement in a table
Architecture Flashback Database
Configuring Flashback Database
Flashback Database using Enterprise Manager
Considerations of Use

Part Two: Oracle Database 11g: Tuning

13. Introduction to Oracle Database tuning
Reasons for tuning
Who, when and what is optimized in the database

14. Monitoring using basic tools
Enterprise Manager
V $ views, stats and metrics
"Wait" events

15. Using Automatic Workload Repository
Automatic Workload repository: Concept
Automatic Workload Repository Data
Enterprise Manager and AWR
Generating AWR reports in SQL * Plus

16. Identify SQL statements with problems
Features of a SQL statement with problem
The role of the optimizer
Generating a plan explain
Monitoring execution

17. SQL Execution Plan Management
Automatic maintenance tasks
SQL Profiles
SQL Access Advisor
SQL Outlines
SQL Plan baselines

18. Change Management
Types of Changes
SQL Performance Analyzer
DB Replay

19. Use of metrics and alerts

20. AWR-based utilities
Automatic maintenance tasks
Active Session History

21. Baselines

22. PGA and temporary space tuning

23. Automatic Memory Management
SGA Dynamic: Use
Using Automatic Memory Management

24. Statspack
Snapshots Statspack
Reporting with Statspack
Statspack and AWR

Program: Monday – Friday: 09.00-17.00.