Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle Database 12c Backup and Recovery

This course will discuss and demonstrate how to perform backup and recovery techniques in Oracle Database 12c.

GK# 7621

Course Overview

TOP

This course will discuss and demonstrate how to perform backup and recovery techniques in Oracle Database 12c. This includes using RMAN to perform the different types of backups and restores as well as how to troubleshoot and tune RMAN operations. It will also cover how to duplicate and transport databases and how to use Oracle Secure Backup.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Oracle Database 12c - Backup and Recovery: Configuring for Recoverability
  • Oracle Database 12c - Backup and Recovery: Performing and Managing Backups
  • Oracle Database 12c - Backup and Recovery: Failure and Recovery Concepts
  • Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup
  • Oracle Database 12c - Backup and Recovery: Using Flashback Technologies
  • Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR
  • Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN

Outline

TOP
Viewing outline for:

On-Demand Outline

Oracle Database 12c - Backup and Recovery: Configuring for Recoverability

  • Identify the features of Oracle Database 12c
  • Identify recovery requirements
  • Identify the different types of failures that can occur
  • Describe backup and recovery solutions
  • Describe the benefits of using Oracle Secure Backup and Oracle Data Guard
  • Describe the different architecture types for the recovery solutions
  • Identify the structures in the Oracle server architecture
  • Identify the process used in an Oracle server architecture
  • Identify the components of a Grid infrastructure for a stand-alone server
  • Explore the Oracle Database environment in Linux
  • Identify the different DBA tools that are used to manage a database
  • Use RMAN to back up a database in NOARCHIVELOG mode
  • Identify how to perform a restore of a database in NOARCHIVELOG mode
  • Configure RMAN persistent settings
  • Configure the retention policy using RMAN
  • Describe the fast recovery area
  • Configure the fast recovery area
  • Size and manage the fast recovery area
  • Multiplex control files for recoverability
  • Multiplex redo log files for recoverability
  • Configuring ARCHIVELOG mode and the archived redo log files for recoverability
  • Describe the use of the RMAN recovery catalog
  • Create the RMAN recovery catalog
  • Register a database in the RMAN recovery catalog
  • Register the recovery catalog to be used by Cloud Control
  • Identify how the recovery catalog is resynchornized
  • Use RMAN stored scripts
  • Back up the RMAN recovery catalog
  • Create and use virtual private RMAN catalogs
  • Configure RMAN for recovery and create the Recovery Catalog

Oracle Database 12c - Backup and Recovery: Performing and Managing Backups

  • Identify backup and restore requirements
  • Describe backup strategies
  • Identify the best practices to backup and recover a data warehouse
  • Create backup sets and images
  • Create a whole database backup
  • Schedule backups in a given scenario
  • Identify the different RMAN backup types
  • Perform incremental backups
  • Configure block change tracking
  • Use an Oracle-suggested backup strategy
  • View information on backups
  • Manage backups in a given scenario
  • Create an incremental backup strategy using different levels of backups
  • Describe backup compression
  • Use media manager
  • Back up very large database files using multisection backups
  • Create proxy, duplexed, and backup sets
  • Create archival backups
  • Back up database files, including control files, ASM disk groups, and recovery files
  • Identify the RMAN-encrypted backup modes
  • Use transparent-mode encryption
  • Use password-mode and dual-mode backup encryption
  • Restore an encrypted backup
  • Perform different types of backups using RMAN

Oracle Database 12c - Backup and Recovery: Performing and Managing Backups

  • Identify backup and restore requirements
  • Describe backup strategies
  • Identify the best practices to backup and recover a data warehouse
  • Create backup sets and images
  • Create a whole database backup
  • Schedule backups in a given scenario
  • Identify the different RMAN backup types
  • Perform incremental backups
  • Configure block change tracking
  • Use an Oracle-suggested backup strategy
  • View information on backups
  • Manage backups in a given scenario
  • Create an incremental backup strategy using different levels of backups
  • Describe backup compression
  • Use media manager
  • Back up very large database files using multisection backups
  • Create proxy, duplexed, and backup sets
  • Create archival backups
  • Back up database files, including control files, ASM disk groups, and recovery files
  • Identify the RMAN-encrypted backup modes
  • Use transparent-mode encryption
  • Use password-mode and dual-mode backup encryption
  • Restore an encrypted backup
  • Perform different types of backups using RMAN

Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup

  • Identify the commands that can be used to verify backups are available
  • Restore in NOARCHIVELOG mode
  • Perform complete recovery
  • Recover from the loss of a data file in ARCHIVELOG mode
  • Restore ASM disk groups
  • Recover image copies of a database
  • Perform point-in-time recovery
  • Perform incomplete recovery
  • Recover from the loss of an spfile
  • Recover from a control file failure
  • Recovering from the loss of a control file and from all control files
  • Recover from the loss of a redo log file
  • Recover from the loss of a redo log group
  • Recreate the password authentication file
  • Recover index and read-only tablespaces
  • Describe the procedure to restore a database to a new host
  • Describe disaster recovery
  • Restore an encrypted backup
  • Perform recovery of a database in a given scenario
  • Describe RMAN and OSB integration
  • Install Oracle Secure Backup
  • Configure OSB for RMAN
  • Perform and manage tape backups
  • Configure OSB and perform a backup to tape
  • Install, configure, and use Oracle Secure Backup

Oracle Database 12c - Backup and Recovery: Using Flashback Technologies

  • Describe the Flashback technologies available in an Oracle database
  • Configure undo retention
  • Use Flashback Query and Flashback Version Query
  • Describe the Flashback Table feature
  • Use Flashback Table to reverse a rogue transaction
  • Describe the Flashback Transaction Query feature
  • Use the Flashback Transaction Query feature
  • Describe Flashback Drop and how the recycle bin works
  • Flash back a dropped table
  • Create temporal history and enable archiving
  • Describe how Flashback Data Archive works
  • Describe transparent and full schema evolution with Flashback Data Archive
  • Use the period for clause to use temporal validity and history in a table
  • Filter on valid-time columns
  • Describe the Flashback Database
  • Configure the Flashback Database feature
  • Flash back a database
  • Describe the considerations for using Flashback Database
  • Monitor Flashback Database information
  • Create a restore point to use with Flashback Database
  • Describe the best practices for using Flashback Database
  • Use the different Flashback Technologies in a given scenario

Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR

  • Describe how data can be transported
  • Determine the endian format of a platform and the use of the RMAN convert command
  • Describe the steps to transport data with backup sets and data files
  • Describe the procedure used to transport a database
  • Perform database transportation
  • Perform database transportation using backup sets
  • Perform tablespace transportation
  • Transport data, databases, and tablespaces in a given scenario
  • Identify when Tablespace Point-in-Time Recovery can be used
  • Identify the Tablespace Point-in-Time Recovery architecture
  • Prepare for Point-in-Time Recovery
  • Perform fully automated Tablespace Point-in-Time Recovery
  • Perform TSPITR using an RMAN-Managed Auxiliary instance and your own auxiliary instance
  • Troubleshoot RMAN Tablespace Point-in-Time Recovery
  • Describe table recovery
  • Identify the steps to perform table recovery
  • Recover a table from a backup using RMAN
  • Perform TSPITR and table recovery in a given scenario

Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN

  • Identify the difference techniques that can be used to duplicate a database
  • Identify the difference between the push and pull methods for duplicating a database
  • Identify the techniques for duplicating a database from backup
  • Identify how to create a parameter file for the auxiliary instance
  • Identify how to use the SET NEWNAME clause
  • Identify how to start the auxiliary database and allocate auxiliary channels
  • Identify the steps performed by RMAN when the duplicate command is executed
  • Identify the different options that can be used with the duplicate command
  • Perform the steps to duplicate a database
  • Duplicate a database
  • Interpret RMAN messages and error stacks
  • Understand how RMAN commands are processed
  • Identify if there is a problem with RMAN performance
  • Diagnose performance bottleneck read operations
  • Diagnose performance bottleneck write operations
  • Use dynamic views to determine if there is a performance issue
  • Diagnose asynchronous and synchronous I/O bottlenecks
  • Identify the steps to tune backup performance
  • Configure parallelization of backup sets
  • Set the large_pool_size parameter
  • Configure RMAN multiplexing
  • Identify the best practices for restore and recovery performance
  • Troubleshoot and tune RMAN

Who Should Attend

TOP

This course is designed for Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures.

Course Delivery

This course is available in the following formats:

On-Demand

Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.



Request this course in a different delivery format.
Enroll