Course
Skills
Oracle Database 12c Disaster Recovery and Data Movement
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.
What you'll learn
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.
Table of contents
Configuring Backup and Recovery
26mins
- 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
27mins
- 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
30mins
- 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
27mins
- 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
35mins
- 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
28mins
Exploring Oracle Database 12c Multitenant
30mins
About the author
Timothy Warner is a Microsoft Most Valuable Professional (MVP) in Cloud and Datacenter Management who is based in Nashville, TN. His professional specialties include Microsoft Azure, cross-platform PowerShell, and all things Windows Server-related. You can reach Tim via Twitter (@TechTrainerTim), LinkedIn or his blog, AzureDepot.com.