Oracle Database: Backup and Recovery Workshop Course Overview

This Oracle Database 12c: Backup and Recovery Workshop will teach each you how to evaluate your own recovery requirements. You will develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

  • Develop backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.
  • Gain an understanding of the 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.

Perform Backup and Recovery

Expert instructors will begin by helping you gain a deeper understanding of possibly the most important job of a Database Administrator, backup and recovery. The concepts and architecture that support backup and recovery, along with the steps required to carry it out in various ways and situations, are covered in detail.

Recovery Manager Command Line and Graphical Interfaces

This course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery scenarios.

Participate in Hands-on Practices and Workshops

Participating in extensive hands-on practices and workshops will help you gain experience in a realistic technical environment. Interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.

Key Takeaways

Upon completing this course, you will know how to evaluate your own recovery requirements. You'll have the skills to develop an appropriate strategy for backup and recovery procedures.

Audience :

  • Administrator
  • Database Administrator

 

 

The 1-on-1 Advantage
Methodology
Flexible Dates
  • • Choose Start Date
  • • Reschedule After Booking
  • • Weekend / Evening Option
4-Hour Sessions

You will learn:

Module 1: Backup and Recovery: Overview
  • DBA Responsibilities
  • Separation of DBA Duties
  • Assessing Your Recovery Requirements
  • Categories of Failure
  • Statement Failure
  • User Process Failure
  • Network Failure
  • User Error
  • Instance Failure
  • Media Failure
  • Data Failures
  • Instance Recovery
  • The Checkpoint (CKPT) Process
  • Redo Log Files and the Log Writer (LGWR) Process
  • Database Log Mode
  • Automatic Instance Recovery or Crash Recovery
  • Phases of Instance Recovery
  • Tuning Instance Recovery
  • Using the MTTR Advisor
  • Restoring and Recovering
  • Comparing Complete and Incomplete Recovery
  • The Complete Recovery Process
  • The Point-in-Time Recovery Process
  • Oracle Data Protection Solutions
  • Flashback Technology
  • Objectives
  • Configuring for Recoverability
  • Configuring the Fast Recovery Area
  • Monitoring the Fast Recovery Area
  • Multiplexing Control Files 2-6Redo Log Files
  • Multiplexing the Redo Log
  • Creating Archived Redo Log Files
  • Archiver (ARCn) Process
  • Archived Redo Log Files: Naming and Destinations
  • Configuring ARCHIVELOG Mode
  • Summary
  • Practice Overview
  • Objectives
  • Integrated Oracle Recovery Manager (RMAN)
  • Connecting to RMAN and a Target Database
  • Using SQL in RMAN
  • Types of RMAN Commands
  • Job Commands: Example
  • Configuring Persistent Settings for RMAN
  • Viewing Persistent Settings
  • Managing Persistent Settings
  • Specifying a Retention Policy
  • Recovery Window Retention Policy: Example
  • Summary
  • Practice Overview
  • Objectives
  • Understanding Types of Backups
  • Backup Terminology
  • Understanding Types of Backups
  • RMAN Backup Types
  • Backup Solutions: Overview
  • Balancing Backup and Restore Requirements
  • Comparing Backup Strategies
  • Option 1: Full and Incremental Backups
  • Option 2: Incrementally Updated Disk Backups
  • Option 3: Offloading Backups to Physical Standby Database in Data
  • Guard Environment
  • Objectives
  • Using RMAN Commands to Create Backups
  • Syntax and Clauses in RMAN
  • Creating Backup Sets
  • Creating Image Copies
  • Creating a Whole Database Backup
  • CDB Backup: Whole CDB Backup
  • CDB Backup: Partial CDB Backup
  • PDB Backup: Partial PDB Backup
  • Review: RMAN Backup Types
  • Incrementally Updated Backups
  • Incrementally Updated Backups: Example
  • Fast Incremental Backup
  • Maintaining the Block Change Tracking File
  • Monitoring Block Change Tracking
  • Automatic Disk-to-Disk Backup and Recovery
  • Oracle-Suggested Backup
  • Backing Up the Control File to a Trace File
  • Cataloging Additional Backup Files
  • Reporting on Backups
  • Using Dynamic Views
  • Summary
  • Practice Overview
  • Objectives
  • Saving Backup Space with Unused Block Compression
  • Compressing Backups
  • Using RMAN Backup Compression
  • Using a Media Manager
  • Configuring Backup and Restore for Very Large Files
  • Backing Up and Restoring Very Large Files
  • Creating RMAN Multisection Backups
  • Creating Proxy Copies
  • Creating Duplexed Backup Sets by Using BACKUP COPIES
  • Creating Backups of Backup Sets
  • Archival Backups: Concepts
  • Creating Archival Backups with RMAN
  • Managing Archival Database Backups
  • Backing Up Read-Only Tablespaces: Considerations
  • Data Warehouse Backup and Recovery: Best Practices
  • Summary 4-17Backing Up Recovery Files
  • Summary
  • Practice Overview
  • Is There a Problem?
  • Diagnosing Performance Bottlenecks
  • Diagnosing Performance Bottlenecks: Read Phase
  • Is There a “Write” Problem?
  • Diagnosing Performance Bottlenecks: Write or Copy Phase
  • Using Dynamic Views to Diagnose RMAN Performance
  • Monitoring RMAN Job Progress
  • Identifying Backup and Restore Bottlenecks
  • Asynchronous I/O Bottlenecks
  • Synchronous I/O Bottlenecks
  • Tuning RMAN Backup Performance
  • Parallelization of Backup Sets
  • RMAN Multiplexing
  • RMAN Repository Data Storage: Comparison of Options
  • Storing Information in the Recovery Catalog
  • Reasons to Use a Recovery Catalog
  • Creating the Recovery Catalog: Three Steps
  • 1.  Configuring the Recovery Catalog Database
  • 2.  Creating the Recovery Catalog Owner
  • 3.  Creating the Recovery Catalog
  • Summary
  • Practice Overview
  • Managing Target Database Records in the Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Unregistering a Target Database from the Recovery Catalog
  • Recovery Catalog Resynchronization: Concepts
  • Manually Resynchronizing the Recovery Catalog
  • Using RMAN Stored Scripts
  • Executing RMAN Stored Scripts
  • Maintaining RMAN Stored Scripts
  • Objectives
  • Creating and Using Virtual Private Catalogs
  • Creating a Virtual Private Catalog
  • Managing Virtual Private Catalogs
  • Upgrading Virtual Private Catalogs
  • Summary
  • Practice Overview
  • Objectives
  • File Loss
  • Data Repair Techniques
  • Restoring and Recovering
  • Using RMAN RESTORE and RECOVER Commands
  • Instance Failure
  • Instance Recovery
  • Phases of Instance Recovery
  • Media Failure
  • Comparing Complete and Incomplete Recovery
  • Complete Recovery Process
  • Point-in-Time Recovery Process
  • Recovery with the RESETLOGS Option
  • Restore and Recovery Performance: Best Practices
  • Summary
  • Objectives
  • Reducing Problem Diagnosis Time
  • Automatic Diagnostic Workflow
  • Automatic Diagnostic Repository
  • ADR Command-Line Tool (ADRCI)
  • V$DIAG_INFO View
  • Data Recovery Advisor
  • Data Failure: Examples
  • Data Recovery Advisor RMAN Command-Line Interface
  • Listing Data Failures
  • Advising on Repair
  • Executing Repairs
  • Classifying (and Closing) Failures
  • Data Recovery Advisor Views
  • Objectives
  • Ensuring Backups Are Available
  • Restoring in NOARCHIVELOG Mode
  • Recovery with Incremental Backups in NOARCHIVELOG Mode
  • Performing Complete Recovery
  • Review: Recovering Image Copies
  • Recovering Image Copies: Example
  • Performing a Fast Switch to Image Copies
  • Using SET NEWNAME for Switching Files
  • Using Restore Points
  • PDB Tempfile Recovery
  • PDB SYSTEM or UNDO Tablespace Recovery
  • PDB Non-SYSTEM Tablespace Recovery
  • Summary
  • Practice Overview
  • Objectives
  • Point-in-Time Recovery
  • PITR Terminology
  • Performing Point-in-Time Recovery
  • When to Use TSPITR
  • Table space Point-in-Time Recovery: Architecture
  • Preparing for TSPITR
  • Determining the Correct Target Time
  • Determining the Table spaces for the Recovery Set
  • Identifying Objects That Will Be Lost
  • Performing RMAN TSPITR
  • Performing Fully Automated TSPITR
  • Improving TSPITR Performance
  • Performing RMAN TSPITR with an RMAN-Managed Auxiliary Instance
  • Performing RMAN TSPITR by Using Your Own Auxiliary Instance
  • Troubleshooting RMAN TSPITR
  • PITR of PDBs
  • Recovering Tables from Backups
  • Table Recovery: Graphical Overview
  • Prerequisites and Limitations
  • Specifying the Recovery Point in Time
  • Process Steps of Table Recovery
  • Summary
  • Practice Overview
  • What Is Block Corruption?
  • Block Corruption Symptoms: ORA-01578
  • How to Handle Corruption
  • Setting Parameters to Detect Corruption
  • Block Media Recovery
  • Prerequisites for Block Media Recovery
  • Recovering Individual Blocks
  • Best Practice: Proactive Checks
  • Checking for Block Corruption
  • Recovery from Loss of Server Parameter File
  • Restoring the Server Parameter File from the Control File Autobackup
  • Loss of a Control File
  • Recovering from the Loss of All Control File Copies: Overview
  • Restoring the Control File from Autobackup
  • Restoring the SPFILE and the Control File
  • Recovering NOLOGGING Database Objects
  • Loss of a Redo Log File
  • Log Group Status: Review
  • Recovering from the Loss of a Redo Log Group
  • Clearing a Log File
  • Re-creating a Password Authentication File
  • Practice Overview
  • Flashback Technologies Error Detection and Correction
  • Review: Transactions and Undo
  • Flashback Technology
  • Summary
  • Using Flashback Technology to Query Data
  • Flashback Query
  • Flashback Version Query
  • Flashback Table: Overview
  • Flashback Table
  • Flashback Table: Considerations
  • Flashback Transaction Query
  • Flashback Transaction Query: Considerations
  • Flashback Transaction Backout
  • Flashing Back a Transaction
  • Best Practices: Undo-Based Flashback Query, Flashback Table
  • Flashback Drop and the Recycle Bin
  • Recycle Bin
  • Bypassing the Recycle Bin
  • Using Flashback Data Archives
  • Creating a Temporal History and Enabling Archiving
  • How the Flashback Data Archive Works
  • Collecting User Context in Temporal History
  • Transparent Schema Evolution
  • Full Schema Evolution
  • Temporal Validity and History
  • Using the PERIOD FOR Clause
  • Filtering on Valid-Time Columns: Example
  • Filtering on Valid-Time Columns: Example
  • Using DBMS_FLASHBACK_ARCHIVE
  • Preparing Your Database for Flashback
  • Guaranteeing Undo Retention
  • Flashback Database: Continuous Data Protection
  • Flashback Database
  • Flashback Database Architecture
  • Configuring Flashback Database
  • Flashback Database: Examples
  • CDB and PDB Flashback
  • Flashback Database Considerations
  • Monitoring Flashback Database Information
  • Guaranteed Restore Points
  • Flashback Database and Guaranteed Restore Points
  • PDB Flashback and Clean Restore Point
  • Best Practices: Flashback Database
  • Objectives
  • PDB Snapshot Carousel
  • Creating PDB Snapshots
  • Creating PDBs by Using PDB Snapshots
  • Dropping PDB Snapshots
  • Flashing Back PDBs by Using PDB Snapshots
  • Summary
  • Objectives
  • Using a Duplicate Database
  • Choosing Database Duplication Techniques
  • Duplicating an Active Database with “Push”
  • Comparing the “Push” and “Pull” Methods of Duplication
  • Duplicating a Database with a Target Connection
  • Duplicating a Database with a Recovery Catalog
  • Duplicating a Database Without a Recovery Catalog or Target Connection
  • Summary
  • Objectives
  • Creating a Backup-Based Duplicate Database
  • Creating an Initialization Parameter File for the Auxiliary Instance
  • Specifying New Names for Your Destination
  • Using the SET NEWNAME Clauses
  • Substitution Variables for SET NEWNAME
  • Specifying Parameters for File Naming
  • Starting the Instance in NOMOUNT Mode
  • Ensuring That Backups and Archived Redo Log Files Are Available
  • Allocating Auxiliary Channels
  • Understanding the RMAN Duplication Operation
  • Specifying Options for the DUPLICATE Command
  • Using Additional DUPLICATE Command Options
  • Duplicating Selected PDBs in a CDB
  • Cloning an Active PDB into an Existing CDB
  • Example: Duplicating PDB1 from CDB1 to CDB2 as PDB1
  • Example: Duplicating PDB1 from CDB1 to CDB2 as PDB2
  • Practice Overview
Live Online Training (Duration : 40 Hours) Fee On Request
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
Date On Request
Course Prerequisites

Suggested Prerequisite

  • CDT Using Oracle Enterprise Manager Cloud Control 12c

Required Prerequisite

  • Knowledge of SQL and PL/SQL
  • Knowledge of Oracle Database 12c

 

After completion of this course, you will learn how to : 

  • Introduction
  • Getting Started
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups
  • Diagnosing Database Failures
  • Restore and Recovery Concepts
  • Performing Recovery, Part 1
  • Performing Recovery, Part 2
  • RMAN and Oracle Secure Backup
  • Performing Tape Backups and Restores
  • Using Flashback Technologies
  • Using Flashback Database
  • Managing Backup Space or Transporting Data
  • Duplicating a Database
  • RMAN Performance and Tuning
  • Backup and Recovery Workshop
  • Oracle Database Cloud Service: Overview

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
Yes, we do.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Oracle Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1-on-1 you can select your own schedule, other students can be merged but you select the schedule. Choose 1-on-1 if published schedule do not meet your requirement. If you also want a private session, opt for 1-on-1 Public.
Yes.
No, it is not included.
In both, you choose the schedule. In public, other participants can join, Private other participants want to join.
Yes, course requiring practical include hands-on labs.
You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
Yes, you can pay from the course page and flexi page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You can request a refund if you do not wish to enroll in the course.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
After you submit your payment, you will land on the payment confirmation screen. It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however, it takes 48 hours for the money to be moved.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, if we have an office in your city.
Yes, we do offer corporate training More details
Yes, we do.
Yes, we also offer weekend classes.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes. You can access courseware for most vendors.
Yes, this is our official email address which we use if a recipient is not able to receive emails from our @koenig-solutions.com email address.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
Yes you can.
Yes, we do. For details go to flexi
You can pay through debit/credit card or bank wire transfer.
Dubai, Goa, Delhi, Bangalore.
Yes you can request your customer experience manager for the same.
Yes of course. 100% refund if training not upto your satisfaction.

Prices & Payments

Yes of course.
Yes, We are

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.