Oracle RMAN - Configure advanced RMAN backups and scripts

Name: Oracle RMAN - Configure advanced RMAN backups and scripts
Rating: 4.3 (289 reviews)

Master RMAN advanced backups concepts and practice real time

Created byArun Kumar

Last updated 12/2017

English

What you'll learn

Plan effective rman backups
Describe Oracle Database backup methods
Configure and connect RMAN

Course content

6 sections • 27 lectures • 3h 41m total length

Before you start0:18
What is RMAN?2:37
Master the fundamentals of Oracle RMAN for backup and recovery, including configuring RMAN, using backup channels, and performing full, incremental, and archive backups for databases of various sizes.
Why Recovery Manager?9:35
Power of RMAN6:53
Explore RMAN's backup options for datafiles, tablespaces, or entire databases, plus data block and point-in-time recovery, with scripting and catalogs to deploy across multiple servers and enable cloning.
RMAN functionality4:24
Rman backs up data files using parallel channels that read blocks and write to backup files on disk or tape, automatically locating data files and requiring no extra license.
Connecting to RMAN utility2:36
Connect to the RMAN utility by default using environment variables, with no installation required, and back up with minimal performance impact.

RMAN configuration parameters overview5:55
Learn how RMAN configuration parameters govern startup, backup, and recovery behavior; connect to the target database via slash or user/password, guided by environment variables, and view settings with show all.
RMAN configuration parameters part 113:44
RMAN configuration parameters part 214:13
Configure RMAN parameters to enable control file backups, set formats, device types, channels, and parallelism, manage backup copies, retention, encryption, compression, archive deletion, and snapshot control file naming.

Introduction to RMAN Channels and Parallelism0:28
Explore RMAN channels and parallelism to optimize backups and scripts, building on RMAN configuration parameters and deepening your understanding of parallel execution.
Types of channels in RMAN3:20
Explore how RMAN uses automatic and manual channels, plus the auxiliary channel, in backups and cloning, and define channels in an RMAN script block.
Configure default device type with parallelism 113:26
Configure the default device type as disk with parallelism 1 to use RMAN channels by default, and understand archivelog, archive destination, and backup sets and pieces.
Configure default device type with parallelism 210:37
Configure the RMAN channel with parallelism 2 to use two channels for backups and observe how backup pieces are allocated; cross-check backups and note channel count depends on CPU cores.
Configure default channel12:13
Configure a default channel to automatically route backups to a specified disk location, using a device type disk and a custom format for backup pieces.

Introduction to RMAN Backup Types0:36
Explore the different RMAN backup types, learn what constitutes a backup and which files to back up, and identify the key RMAN components essential for recovery.
What to backup?8:58
Types of backup7:35
Learn the two backup types: consistent backups capture the database as it was at the backup time, and inconsistent backups require applying archive logs to recover changes with RMAN.
Types of RMAN backup20:30

Before taking any backup2:33
Taking RMAN DB Full backup part 115:57
Taking RMAN DB Full backup part 213:38
Taking RMAN INCREMENTAL backup6:43
Checking RMAN backups18:42
Taking RMAN compressed backups5:14
Learn to take compressed backups with RMAN to save disk space. Use the backup as compressed backup set command, enable default compression, and verify backup sizes.
Taking RMAN archivelog backup14:17
Deleting the archivelog backup6:30

Requirements

Knowledge on Basic RMAN backup concepts
Basic operating system knowledge and relational database concepts

Description

Oracle RMAN or recovery manager is one of best tools which helps a DBA both in terms of database backups and database recovery. This course is primarly for students who would like to master different types of Oracle database backups, configure db full backup, configure incremental backups, schedule backups to run via crontab and more.

The advanced backup and recovery course is designed to make students master Oracle database backup and recovery strategies. As a DBA, the primary job is to have proper database backups. If you do not have database backups in place, it will not be possible to recovery database.

With this course, you would be able to master advanced RMAN backups, perform high level database recoveries, schedule database backups, monitor database backups and protect your database against any type of data loss.

Who this course is for:

Any DBA who performs database backup
Administrators who work on extensive database backups
Administrators who want to master RMAN backups

Oracle RMAN - Configure advanced RMAN backups and scripts

What you'll learn

Explore related topics

Course content

Introduction To RMAN6 lectures • 26min

RMAN Configuration Parameters3 lectures • 34min

RMAN Channels and Parallelism5 lectures • 40min

RMAN Backup Types4 lectures • 38min

Taking RMAN Backups8 lectures • 1hr 24min

Summary1 lecture • 1min

Requirements

Description

Who this course is for: