Oracle 12c Backup Recovery and Tuning

Oracle 12c Backup Recovery and Tuning Course Details:

In this class, you'll learn backup and recovery techniques through hands-on exercises designed to reinforce the material covered. This course is designed to help you prepare you for the Oracle Certified Associate and Oracle Certified Professional exams.

No classes are currenty scheduled for this course.

Call (919) 283-1653 to get a class scheduled online or in your area!

1. Backup and Recovery Concepts

Describe the Basics of Database Backup, Restore, and Recovery
List the Types of Failure that May Occur in an Oracle Database
Describe Ways to Tune Instance Recovery
Identify the Importance of Checkpoints, Redo Log Files, and Archived Log File
Configure ARCHIVELOG Mode
Flashback Database / Table / Query

2. Database Backups

Create Consistent Database Backups, Incremental Backups, and Automate Database Backups
Monitor the Flash Recovery Area
Back Up Your Database without Shutting it Down

3. Database Recovery

Recover from Loss of a Control File, a Redo Log File, Data Files, and Temp Files
Undo Tablespaces

4. Recovery Manager Configuration

Parameters Affecting RMAN
Use of a Flashback Recovery Area
The CONFIGURE Command
Persistent Settings
NOCATALOG / CATALOG Mode
Channel Allocation
Controlfile Autobackup
Retention Policies

5. Recovery Manager Operations

Using the BACKUP Command
Creating Backup Sets / Image Copies
Parallelization
Compressed Backups
Whole Database Copying
Incremental Backups
Block Change Tracking
RMAN Backup Monitoring
REPORT and LIST Commands

6. Non-Critical Loss Recovery

Password and Network Files
Read-Only Tablespaces
Temporary Tablespaces
Index Tablespaces
Redo Log Members / Control Files

7. Database Recovery

Recovering the Control File
Reasons for Incomplete Recovery
Recovery after RESETLOGS
Incomplete Recovery Using RMAN
Incomplete Recovery Using SQL

8. Flashback Database

When to Use
Configuration and Use
Monitoring Flashback Database
Using EM for Flashback Database
Flash Recovery Area Maintenance
Flash Recovery Area Monitoring

9. User Error Recovery

The New Recycle Bin
Flashback a Dropped Table Using EM
Querying Dropped Tables
Flashback Versions Query
Flashback Transaction Query

10. Block Corruption Management

DBVERIFY and ANALYZE
DBMS_REPAIR
Block Media Recovery
DBMS_BLOCK_CHECKING Parameter
Using RMAN for Block Corruption

11. Tune Database Operations

SQL Parsing And Execution
Shared SQL Statements / Bind Variables
The SQL Area / High Load SQL
Automatic Segment Space Management
Statement Transformation
Using SQL Syntax

12. Tuning the Logical Structure

Tablespace Considerations
Table Considerations
Free Space Management
Chaining And Migrated Data
Choosing The Right Index
Index Usage Monitoring
Materialized Views

13. SQL Tuning Tools

Execution Plans
Cost-Based Optimization
Table Column And Index Statistics
DBMS_STATS
Stats Pack
Execution Plans / EXPLAIN PLAN
Row Access Methods / Index Types
Autotrace
SQL_TRACE and TKPROF
Using Hints
Stored Outlines and Plan Stability
Query Rewrites / Materialized Views
Initialization Parameters

14. Application Memory Use

Memory Tuning Goals
Tuning The Buffer Cache
Memory Subcaches
Partitioned Tables And Indexes

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.

Backup and recover the database
Monitor, troubleshoot, and maintain the database
How to configure and use recovery manager

Lab 1: Configuring the database for backup

Lab 2: Basic Database Media Recovery

Lab 3: Archivelog Setup

Lab 4: Recovery Manager Configuration

Lab 5: Recovery Manager Backups

Lab 6: Database Recovery using RMAN

Lab 7: Flashback Database

Lab 8: Flashback for User Errors

Lab 9: Dealing With Block Corruption

Knowledge of SQL

Database administrators
Support engineers
Technical consultants
Systems administrators
Network managers
Technical support personnel

Oracle 12c Backup Recovery and Tuning