Deep Oracle 12c Database backup and recovery (optimized for Rman performance, Oracle Flashback Technology)

• Course lecturer: Xiao Liu Teacher

• Course Category: Oracle

• Suitable for people: advanced

• Number of lessons: 15 hours

• Update level: Complete

• Type of Service: Class C (General Service class course)

• Using the technology: Oracle

• Projects involved: Oracle 12c database backup and recovery

Need more information to contact Q2748165793

Course Outline

First Lecture: Introduction to Backup and recovery-related operations

Goals for backup and recovery

Backup and Recovery Solutions

Oracle Flashback Technology

Second: Starting the Rman operation and the Rman architecture

Environment of Rman

RMAN Channels

RMAN Repository

Rman Backup and recovery related operations

Third: Configuring the Rman Environment and client usage

Configuring the Rman Backup Environment

Configuring Fast Recovery Area

Configure Backup retention Policies

Configuring the Archive Log removal policy

Client Tools use

IV: Using FLASHBACK database and restore Points

About flashback database and restore Points

Use a regular and secured restore Points

Using Flashback Database

Lecture V: Rman backup concept

Consistent and non-consistent backups

Backup set

Mirrored copy

Automatic backup of control files and parameter files

Incremental backup

Backup Retention Policy

VI: Basic operation of Rman backup

Set Backup Output Options

Backing Up Database files

Backing Up archive log files

Create an incremental backup

Seventh: Advanced Operations for Rman backup

Limit backup set Size

Skip files with backup options

Duplex Backup Set

Manage Backup Set Windows

Encrypt backup Sets

Eighth: Managing Rman Backup

Rman Backup Report

Enumerate backup and recovery-related objects

Backing up reports and database objects

Using a view query to back up data

Nineth: Diagnostic and response data failure one (Rman data modification concept, using Data Recovery Advisor Diagnostics and modifications)

Concepts related to Rman data repair

Using Data Recovery Advisor Diagnostics

Tenth: Diagnostic and response data failure two (verifying data files and backups, performing full database recovery, performing flashback, and database Point-in-time recovery)

Validating data files and backup sets

Database Full Recovery

Time-based Database recovery

11th: Diagnostic and response data failure three (perform physical block recovery, perform rman recovery, perform table space point-in-time recovery, perform table and table partition Recovery)

Performing data Block physical recovery

Performing Rman Recovery: Advanced scripting

Perform point-in-time table space recovery

Recovering tables with Rman backup sets

12th: Optimizing Rman Performance

Purpose of Rman performance optimization

Basic concepts of Rman performance optimization

Using views to diagnose Rman performance issues

Tuning Rman Backup Performance

13th: Handling Rman-related operational issues

Interpreting messages for Rman output

Diagnosing Rman problems with the v$ view

Interrupt Rman Operation method

14th: Using Rman for data migration

Overview of Rman database replication

Preparing the Rman Database copy operation

Rman database replication Related configuration

Copy Database

15th: Perform User-manager backup and restore

Maintaining backup information using the v$ view

Backing up the entire database using User-manager

Backing up tablespace and data files using User-manager

Using User-manager to back up control files

Archive log files using User-manager backup

Deep Oracle 12c Database backup and recovery (optimized for Rman performance, Oracle Flashback Technology)