Read more
Month/20 Hours Price90,000
80,000
Oracle Database 12c: Backup and Recovery Workshop
This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You’ll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
COURSE DETAILS:
Module1:Introduction
Curriculum ContextAssess your Recovery Requirements
Categories of failures
Oracle Backup and Recovery Solutions
Oracle Maximum Availability Architecture
Oracle Secure Backup
Benefits of using Oracle Data Guard
Basic Workshop Architecture
Module2:Getting Started
Core Concepts of the Oracle Database, Critical for Backup and RecoveryOracle DBA Tools for Backup and Recovery
Connecting to Oracle Recovery Manager (RMAN)
Quick Start: A Problem-Solution Approach
Module3:Configuring for Recoverablility
RMAN commandsConfiguring and managing persistent settings
Using the Fast Recovery Area (FRA)
Control File
Redo Log File
Archiving Logs
Module4:Using the RMAN Recovery Catalog
Creating and Configuring the Recovery CatalogManaging Target Database Records in the Recovery Catalog
Using RMAN Stored Scripts
Maintaining and Protecting the Recovery Catalog
Virtual Private Catalogs
Module5:Backup Strategies and Terminology
Backup Solutions Overview and TerminologyBalancing Backup and Restore Requirements
Backing Up Read-Only Tablespaces
Best Practices for Data Warehouse Backups
Additional Backup Terminology
Module6:Performing Backups
RMAN Backup TypesIncrementally Updated Backups
Fast Incremental Backup
Block Change Tracking
Oracle-Suggested Backup
Reporting on Backups
Managing Backups
Module7:Improving Your Backups
Compressing BackupsUsing a Media Manager
Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
Creating and Managing Archival Backups
Backing Up Recovery Files
Backing Up the Control File to a Trace File
Cataloging Additional Backup Files
Backing Up ASM Disk Group Metadata
Module8Using RMAN-Encrypted Backups
Creating RMAN-Encrypted BackupsUsing Transparent-Mode Encryption
Using Password-Mode Encryption
Using Dual-Mode Encryption
Module9:Diagnosing Database Failures
Reducing Problem Diagnosis TimeAutomatic Diagnostic Repository
Interpreting RMAN Message Output and Error Stacks
Data Recovery Advisor
Diagnosing Data File Loss (file system and ASM)
Handling Block Corruption
Module10:Restore and Recovery Concepts
Restoring and RecoveringInstance Failure and Instance/Crash Recovery
Media Failure
Complete Recovery (Overview)
Point-in-Time Recovery (Overview)
Recovery Through RESETLOGS
Module11Performing Recovery, Part 1
RMAN Recovery in NOARCHIVELOG ModePerforming Complete Recovery (of critical and noncritical data files)
Restoring ASM Disk Groups
Recovery with Image Files
Performing Point-in-Time (PITR) or Incomplete Recovery
Table Recovery from Backups
Module12Performing Recovery, Part 2
Recovery of Server Parameter File, Control FileRedo Log File Loss and Recovery
Password Authentication File Re-creation
Index, Read-Only Tablespace, and Tempfile Recovery
Restoring the Database to a New Host
Disaster Recovery
Restoring RMAN Encrypted Backups
Module13:RMAN and Oracle Secure Backup
Oracle Secure Backup OverviewOracle Database Disk and Tape Backup Solution
Backing Up the Fast Recovery Area to Tape
Defining Retention for RMAN Backups
RMAN and Oracle Secure Backup Basic Process Flow
Integration with Cloud Control
RMAN Database Backup to Tape
Module14:Performing Tape Backups and Restores
Scheduling Backups with EMOracle-Suggested Backup
RMAN and OSB Process Flow
RMAN and Oracle Secure Backup Jobs
Managing Database Tape Backups
Performing Database Recovery
RMAN Automatic Failover to Previous Backup
Module15:Using Flashback Technologies
Flashback Technology: Overview and SetupUsing Flashback Technology to Query Data
Flashback Table
Flashback Transaction (Query and Backout)
Flashback Drop and the Recycle Bin
Flashback Data Archive
Module16:Using Flashback Database
Flashback Database ArchitectureConfiguring Flashback Database
Performing Flashback Database
Best Practices for Flashback Database
Module17:Managing Backup Space or Transporting Data
Transporting TablespacesTransporting Databases
Module17:Duplicating a Database
- Using a Duplicate Database
- Choosing Database Duplication Techniques
- Creating a Backup-up Based Duplicate Database
- Understanding the RMAN Duplication Operation
- Using Cloud Control to Clone a Database
Module18:RMAN Performance and Tuning
Tuning PrinciplesRMAN Multiplexing
Diagnosing Performance Bottlenecks
Restore and Recovery Performance Best Practices
Module19:Backup and Recovery Workshop
Workshop StructureWorkshop Approach to Solving Failure Scenarios
Business Requirements for Database Availability and Procedures
Training Track: Oracle Database 12c: Backup and Recovery Workshop
INTERNATIONAL STUDENT FEE 500
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Hire an Intern
Flexible Class Option
Week End Classes For Professionals SAT | SUN
Corporate Group Training Availables Options
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Oracle Fusion Cloud – Composers and Scripting Training
Incentive Compensation Training – Oracle Sales Cloud
Oracle Financial Cloud ERP General Ledger Implementation
0 Reviews