Mô tả

Learn how to master using RMAN to perform backup and recovery activities on Oracle databases. The course does not only cover the on-site single-instance databases, it also covers RAC, multitenant, and Oracle Database Cloud service as well.

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them. 

  • Describe Oracle technologies involved in backup and recovery activities

  • Use RMAN to perform all Oracle database backup strategies and types: whole/partial, full/incremental, complete/incomplete, and online/offline

  • Implement advanced backup options: compression, encryption, multisection, duplexing backups, and archival backups

  • Perform all common recovery scenarios:

    - Loss of database critical files

    - Loss of application data

    - Loss of database non-critical files

  • Manage RMAN Recovery Catalog

  • Cross-platform data transportation

  • Duplicate a database using RMAN

  • Use Oracle Database Backup Cloud Service

  • Use RMAN in Oracle RAC and multitenant databases

  • Understand the best practices on developing backup and recovery plans

     

Content and Overview
Information presented in this course provides Oracle Database Administrators the knowledge and experience to perform  backup and recovery activities on Oracle databases.

Through this extensive course, you’ll learn all of the using RMAN to manage backup and recovery activities on Oracle databases. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing the Oracle RMAN architecture, this course will take you all the away from performing basic database backup up to implementing advanced backup options on the produced backups.

You will understand and practically produce all the possible RMAN backup strategies and types, including  whole/partial, full/incremental, complete/incomplete, and online/offline backup. You will also implement advanced backup options, such as  compression, encryption, multisection, duplexing backups, and archival backups.

You will also simulate all known common recovery scenarios from losing database critical files, losing application data, and losing database non-critical files. You will cover the further RMAN capabilities, like RMAN Recovery Catalog, cross-platform data transportation, and cloning databases.

Beside all those technical practical skills, you will also understand the best practices on developing backup and recovery plans

This course covers the latest available backup and recovery technology provided by Oracle, that is Oracle Database Backup Cloud Service.

This is an opportunity for the students to gain practical experience on protecting the databases from future incidents.

Upon completing this course, you will be able to develop a practical backup and recovery for Oracle databases in production systems.

Join the author in this learning journey to experience this amazing technology!

Bạn sẽ học được gì

Perform complete/incomplete, full/incremental and whole/partial backups using RMAN

Perform all common recovery scenarios

Use RMAN with Oracle Database Backup Cloud Service

Report and Monitor RMAN Backups and Jobs

Use RMAN backup advanced options

Perform all supported cross-platform transportation techniques

Perform all supported database duplication techniques

Manage RMAN Recovery Catalog

Produce encrypted backups

Use RMAN in a multitenant environment

Use RMAN in a RAC environment

Handle corrupted blocks

Use Data Recovery Advisor

Yêu cầu

  • Familiarity with Oracle database administration
  • Familiarity with Linux operating system basics
  • PC with Windows 7,8, or 10 64-bit, Memory 16 GB, Fee HDD 280 GB, connection to the internet

Nội dung khoá học

18 sections

Introduction

1 lectures
Introduction
06:04

Preparing the Course Practice Environment

4 lectures
Practice 1 - Preparing the Course Practice Environment (Part 1 of 4)
16:01
Practice 1 - Preparing the Course Practice Environment (Part 2 of 4)
21:24
Practice 1 - Preparing the Course Practice Environment (Part 3 of 4)
18:10
Practice 1 - Preparing the Course Practice Environment (Part 4 of 4)
28:08

Introducing Backup and Recovery in RMAN

4 lectures
Introduction to Oracle Backup and Recovery Solutions
19:55
Configuring Oracle Database for Backup and Recovery
23:31
Introduction to Recovery Manager (RMAN)
25:04
Practice 2 - Introducing RMAN
10:35

Performing Backups in RMAN

9 lectures
Performing RMAN Backups - Part I
22:33
Practice 3 - Performing RMAN Backups - Part I
18:45
Performing RMAN Full Backups - Part II
24:02
Practice 4 - Performing RMAN Backups - Part II
11:40
Performing Incremental Backups
22:31
Practice 5 - Performing Incremental Backups (Part 1 of 2)
15:02
Practice 5 - Performing Incremental Backups (Part 2 of 2)
13:32
Configuring RMAN Persistent Settings
29:35
Practice 6 - Configuring RMAN Persistent Settings
10:01

Retrieve Information about RMAN Backups and Jobs

5 lectures
Reporting and Monitoring RMAN Backups and Jobs ( Part 1 of 2 )
15:32
Reporting and Monitoring RMAN Backups and Jobs ( Part 2 of 2 )
11:47
Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 1 of 3 )
11:13
Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 2 of 3 )
09:14
Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 3 of 3 )
09:32

Improving Backups

4 lectures
Improving Backups ( Part 1 of 3 )
13:02
Improving Backups ( Part 2 of 3 )
14:57
Improving Backups ( Part 3 of 3 )
11:56
Practice 8 - Improving Backups
15:23

Managing RMAN Recovery Catalog

3 lectures
Using RMAN Recovery Catalog ( Part 1 of 2 )
12:27
Using RMAN Recovery Catalog ( Part 2 of 2 )
16:23
Practice 9 - Using RMAN Recovery Catalog
12:13

Securing RMAN Backups

2 lectures
Using RMAN-Encrypted Backups
20:26
Practice 10 - Using RMAN-Encrypted Backups
11:20

Common Backup Practices

2 lectures
Common Backup Practices ( Part 1 of 2 )
18:18
Common Backup Practices ( Part 2 of 2 )
15:38

Performing Recovery Scenarios in RMAN

14 lectures
Introducing RESTORE and RECOVER Commands
17:05
Performing Recovery Part I - Performing Full Recovery
19:14
Practice 11 - Performing Recovery Part I
26:01
Performing Recovery Part II - Switching Data Files and Performing PITR
16:36
Practice 12 - Performing Recovery Part II
20:04
Performing Recovery Part III - Performing PITR on Tablespaces and Tables
24:26
Practice 13 - Performing Recovery Part III
15:22
Performing Recovery Part IV - Recovering Control File and SPFILE
15:40
Practice 14 - Performing Recovery Part IV
20:51
Performing Recovery Part V - Recovering From Losing Redo Log Files
12:18
Practice 15 - Performing Recovery Part V ( Part 1 of 2 )
11:37
Practice 15 - Performing Recovery Part V ( Part 2 of 2 )
15:12
Performing Recovery Part VI - Miscellaneous Recovery Scenarios
19:15
Practice 16 - Performing Recovery Part VI
23:56

Using Data Recovery Advisor

4 lectures
Using Data Recovery Advisor
19:43
Practice 17 - Using Data Recovery Advisor
05:22
Handling Corrupted Blocks
26:22
Practice 18 Handling Corrupted Blocks
08:00

Performing Cross-Platform Data Transportation

8 lectures
Introduction to Cross-Platform Data Transportation
07:41
Cross-Platform Data Transport Using Image Copies ( Part 1 of 2 )
12:02
Cross-Platform Data Transport Using Image Copies ( Part 2 of 2 )
18:15
Practice 19 - Cross-Platform Data Transport Using Image Copies ( Part 1 of 2 )
18:02
Practice 19 - Cross-Platform Data Transport Using Image Copies ( Part 2 of 2 )
20:25
Cross-Platform Data Transport Using Backup Sets ( Part 1 of 2 )
19:42
Cross-Platform Data Transport Using Backup Sets ( Part 2 of 2 )
12:18
Practice 20 - Cross-Platform Data Transport Using Backup Sets
18:48

Duplicating a Database Using RMAN

3 lectures
Duplicating a Database using RMAN - Part I
25:25
Duplicating a Database using RMAN - Part II
21:02
Practice 21 Duplicating a Database using RMAN
17:16

RMAN Troubleshooting and Performance Tuning

3 lectures
RMAN Troubleshooting
12:10
RMAN Performance Tuning ( Part 1 of 2)
12:19
RMAN Performance Tuning ( Part 2 of 2)
17:40

Using RMAN in Oracle Multitenant Databases

3 lectures
Using RMAN in Oracle Multitenant Databases
13:56
Practice 22 - Using RMAN in Oracle Multitenant Databases ( Part 1 of 2 )
17:49
Practice 22 - Using RMAN in Oracle Multitenant Databases ( Part 2 of 2 )
14:22

Using RMAN in Oracle RAC

2 lectures
Using RMAN in Oracle RAC
06:22
Using RMAN in Oracle RAC - Demonstration
10:22

Using Oracle Database Backup Cloud Service

2 lectures
Using Oracle Database Backup Cloud Service
09:23
Practice 23 Using Oracle Database Backup Cloud Service
26:43

Course PDF files

1 lectures
Download Course PDF Files
00:02

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.