Share Description
In this course, you will :
- Teach you how to backup and recover Oracle Database 12c under Microsoft Windows and Oracle Linux. In addition, you will be prepared to pass the Oracle Certified Administrator (OCA) certification exam in Oracle Database 12c.
- Discover how to keep your Oracle-stored data safe, secure, and recoverable in the event of a media failure.
- This course will help you get closer to your goal of becoming an Oracle Certified Database Administrator because it is closely linked to the exam objectives.
Syllabus :
1. Configuring Backup and Recovery
- Overview: This Course
- Overview: This Module
- Oracle DBA Backup and Recovery Tasks
- Sources of Data Loss
- Methods of Data Protection
- Oracle Database 12c Backup and Recovery Tools
- Preliminary Data Protection Tasks
- Demo: Configuring the Oracle Backup and Recovery Environment
2. Implementing Oracle Flashback
- What Is Oracle Flashback?
- The Oracle Flashback Feature Set
- The Purposes of Undo Data
- Automatic Undo Management
- How to Configure Oracle Flashback
- Demo 1: Configuring Flashback
- Flashback Database
- Flashback Table
- Demo 2: Using Flashback Database
- Flashback Drop
- Demo 3: Using Flashback Table and Flashback Drop
- Flashback Data Archive
- Demo 4: Implementing Flashback Data Archive
3. Performing Database Backups
- About Database Consistency
- About RMAN
- RMAN Interface in EM Cloud Control 12c
- Creating Cold and Hot Backups
- Creating Incremental Backups
- Demo 1: Introducing RMAN
- Demo 2: Introducing EM Cloud Control 12c
- Automating Database Backups
- Managing Your Backup Library
- Demo 3: Working With RMAN
4. Automating Database Backups
- What Is a Recovery Catalog?
- Creating a Recovery Catalog
- Demo 1: Creating a Recovery Catalog
- Options for Scheduling Oracle Backups
- Demo 2: Scheduling Database Backups
- Demo 3: Scripting Database Backups
- Demo 4: Storing Scripts in the Recovery Catalog
- Demo 5: Storing Scripts in the Recovery Catalog
5. Performing Database Recovery
- Book Suggestions
- What Is Media Failure?
- Phases of Instance Startup
- Complete vs. Incomplete Recovery
- The Data Recovery Advisor
- Recovering From the Loss of a Control File
- Demo 1: Restoring the Control File
- Recovering From the Loss of a Redo Log File
- Demo 2: Repairing Problems With the Redo Log File
- Restoring the Entire Database
- Demo 3: Restoring the Database or Individual Datafiles
- Demo 4: Using the Data Recovery Advisor
6. Moving Data
- Options for Moving Data
- Introducing SQL*Loader
- How to Use SQL*Loader
- Demo 1: Performing a Data Import With SQL*Loader
- Introducing Data Pump
- Data Pump Caveat
- Demo 2: Using Data Pump Export
- Demo 3: Using Data Pump Import
7. Exploring Oracle Database 12c Multitenant
- Why Oracle Multitenant Is a Big Deal
- Oracle Database 12c Multitenant Architecture
- Stupid PDB Tricks
- Demo 1: Managing Pluggable Databases
- Demo 2: Unplugging a PDB
- Demo 3: Plugging in a PDB
- Demo 4: Backing Up PDBs
