Advanced
Oracle Database 12c Disaster Recovery and Data Movement
By Tim Warner
This course will give you the skills you need to perform backup and recovery for Oracle Database 12c under Microsoft Windows and Oracle Linux. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam in Oracle Database 12c.
Course info
Rating
Level
Intermediate
Updated
Aug 12, 2014
Duration
3h 26m
Table of contents
Configuring Backup and Recovery
Overview: This Course
2m
Overview: This Module
2m
Oracle DBA Backup and Recovery Tasks
3m
Sources of Data Loss
3m
Methods of Data Protection
4m
Oracle Database 12c Backup and Recovery Tools
1m
Preliminary Data Protection Tasks
2m
Demo: Configuring the Oracle Backup and Recovery Environment
6m
Summary
2m
Implementing Oracle Flashback
Overview
1m
What Is Oracle Flashback?
3m
The Oracle Flashback Feature Set
2m
The Purposes of Undo Data
2m
Automatic Undo Management
3m
How to Configure Oracle Flashback
1m
Demo 1: Configuring Flashback
4m
Flashback Database
1m
Flashback Table
1m
Demo 2: Using Flashback Database
3m
Flashback Drop
1m
Demo 3: Using Flashback Table and Flashback Drop
2m
Flashback Data Archive
1m
Demo 4: Implementing Flashback Data Archive
1m
Summary
1m
Performing Database Backups
Overview
2m
About Database Consistency
3m
About RMAN
5m
RMAN Interface in EM Cloud Control 12c
2m
Creating Cold and Hot Backups
3m
Creating Incremental Backups
2m
Demo 1: Introducing RMAN
5m
Demo 2: Introducing EM Cloud Control 12c
2m
Automating Database Backups
1m
Managing Your Backup Library
1m
Demo 3: Working With RMAN
4m
Summary
1m
Automating Database Backups
Overview
1m
What Is a Recovery Catalog?
3m
Creating a Recovery Catalog
1m
Demo 1: Creating a Recovery Catalog
6m
Options for Scheduling Oracle Backups
2m
Demo 2: Scheduling Database Backups
5m
Demo 3: Scripting Database Backups
4m
Demo 4: Storing Scripts in the Recovery Catalog
2m
Demo 5: Storing Scripts in the Recovery Catalog
2m
Summary
2m
Performing Database Recovery
Overview
2m
Book Suggestions
2m
What Is Media Failure?
3m
Phases of Instance Startup
4m
Complete vs. Incomplete Recovery
3m
The Data Recovery Advisor
1m
Recovering From the Loss of a Control File
2m
Demo 1: Restoring the Control File
5m
Recovering From the Loss of a Redo Log File
2m
Demo 2: Repairing Problems With the Redo Log File
4m
Restoring the Entire Database
1m
Demo 3: Restoring the Database or Individual Datafiles
3m
Demo 4: Using the Data Recovery Advisor
3m
Summary
1m
Moving Data
Overview
2m
Options for Moving Data
3m
Introducing SQL*Loader
3m
How to Use SQL*Loader
1m
Demo 1: Performing a Data Import With SQL*Loader
7m
Introducing Data Pump
3m
Data Pump Caveat
2m
Demo 2: Using Data Pump Export
4m
Demo 3: Using Data Pump Import
2m
Summary
1m
Exploring Oracle Database 12c Multitenant
Description
Course info
Rating
Level
Intermediate
Updated
Aug 12, 2014
Duration
3h 26m
Description
This Oracle Database 12c Disaster Recovery and Data Movement course accomplishes two goals.
- Number one, you'll learn how to ensure that your Oracle-stored data is always safe, secure, and able to be recovered in the event of a media failure.
- Number two, you'll move closer to your goal of becoming an Oracle Certified Database Administrator because this course is closely tracked to the exam objectives.
About the author
About the author
Timothy Warner is a Microsoft Most Valuable Professional (MVP) in Cloud and Datacenter Management who is based in Nashville, TN.
More from the author
More courses by Tim Warner