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

Source: Internet
Author: User

    • 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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.