Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

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

    $

Oracle 12c Database Backup and Recovery

GK# 7493 Vendor# OR210

Course Overview

TOP

In this course, you'll learn about backup and recovery techniques, which includes hands-on exercises to reinforce the material covered. This course is designed to help you prepare you for the Oracle Certified Associate and Oracle Certified Professional exams.

What You'll Learn

TOP
  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • Configure and use recovery manager

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

1. Backup and Recovery Concepts

  • Describe the basics of database backup, restore, and recovery
  • List the types of failure that may occur in an Oracle database
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log files, and archived log file
  • Configure ARCHIVELOG mode
  • Flashback Database / Table / Query

2. Database Backups

  • Create consistent database backups and incremental backups
  • Automate database backups
  • Monitor the flash recovery area
  • Back your database up without shutting it down

3. Database Recovery

  • Recover from loss of a control file, a redo log file, data files, temp files and undo tablespaces

4. Recovery Manager Configuration

  • Parameters affecting RMAN
  • Use of a flashback recovery area
  • The CONFIGURE command
  • Persistent settings
  • NOCATALOG / CATALOG mode
  • Channel allocation
  • Controlfile autobackup
  • Retention policies

5. Recovery Manager Operations

  • Using the BACKUP command
  • Creating backup sets / image copies
  • Parallelization
  • Compressed backups
  • Whole database copying
  • Incremental backups
  • Block change tracking
  • RMAN backup monitoring
  • REPORT and LIST commands

6. Non-Critical Loss Recovery

  • Password and network files
  • Read-Only tablespaces
  • Temporary tablespaces
  • Index tablespaces
  • Redo log members / control files

7. Database Recovery

  • Recovering the control file
  • Reasons for incomplete recovery
  • Recovery after RESETLOGS
  • Incomplete recovery using RMAN
  • Incomplete recovery using SQL

8. Flashback Database

  • When to use
  • Configuration and use
  • Monitoring flashback database
  • Flash recovery area maintenance
  • Flash recovery area monitoring

9. User Error Recovery

  • The new recycle bin
  • Querying dropped tables
  • Flashback versions query
  • Flashback transaction query

10. Block Corruption Management

  • DBVERIFY and ANALYZE
  • DBMS_REPAIR
  • Block media recovery
  • DBMS_BLOCK_CHECKING parameter
  • Using RMAN for block corruption recovery

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

Lab 1: Configuring the database for backup

Lab 2: Basic Database Media Recovery

Lab 3: Archivelog Setup

Lab 4: Recovery Manager Configuration

Lab 5: Recovery Manager Backups

Lab 6: Database Recovery using RMAN

Lab 7: Flashback Database

Lab 8: Flashback for User Errors

Lab 9: Dealing with Block Corruption

Prerequisites

TOP

Who Should Attend

TOP
  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Request this course in a different delivery format.
Enroll