CourseInfo | SimpliTrain

Oracle 19c Database Backup and Recovery (TTOR21619)

Learning plan iconE-Learning

Description

Geared for DBAs and other technical support staff, Oracle Database 19c Backup and Recovery is a hands-on course that allows you to develop appropriate backup and recovery procedures to address their business model and requirements. Throughout the course you’ll explore how to implement basic backup and recovery procedures, move data between databases and files, and employ basic monitoring procedures. You’ll also learn how to secure the availability of a database by using appropriate backup and recovery strategies, how to how to perform backup and recovery operations using RMAN, and how to use Flashback features to recover from human error. This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a han

Geared for DBAs and other technical support staff, Oracle Database 19c Backup and Recovery is a hands-on course that allows you to develop appropriate backup and recovery procedures to address their business model and requirements. Throughout the course you’ll explore how to implement basic backup and recovery procedures, move data between databases and files, and employ basic monitoring procedures. You’ll also learn how to secure the availability of a database by using appropriate backup and recovery strategies, how to how to perform backup and recovery operations using RMAN, and how to use Flashback features to recover from human error. This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll learn how to: Implement backup and recovery settings and perform backup operations to the media of your choice. Move data between databases and files Use Oracle Database recovery processes to recover from media and other failures. Diagnose and repair data failures Use flashback technologies and data duplication to complement backup and recovery procedures Secure the availability of their database using backup and recovery strategies

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll learn how to: Implement backup and recovery settings and perform backup operations to the media of your choice. Move data between databases and files Use Oracle Database recovery processes to recover from media and other failures. Diagnose and repair data failures Use flashback technologies and data duplication to complement backup and recovery procedures Secure the availability of their database using backup and recovery strategies

This hands-on course is geared for experienced DBAs already working with Oracle.

Lesson Id Title Description
1 Backup Methods User Managed Backups
Oracle Managed Backups Types of Failures
Types of Recoveries
2 Recovery Configuration Configuring the Database for Archivelog
Configuring the Database for No-Archivelog
Configuring the Flash Recovery Area
3 Configuring RMAN RMAN Default Settings
Command Line
Enterprise Manager
4 RMAN Backups Full RMAN Backup
Compressed Backups
Uncompressed Backups
Partial RMAN Backup
Incremental Backups
Change Tracking File
5 Managing Backups Backup Reports
Backup Maintenance
Backup Catalog
Backup Crosscheck
6 RMAN Complete Recovery RMAN Complete Recovery
Database Recovery
Tablespace Recovery
Datafile Recovery
7 RMAN In-Complete Recovery Time Based Recovery
Sequence Based Recovery
SCN Based Recovery
8 Non-Database File Recovery Spfile Recovery
Controlfile Recovery
Incremental Recovery
Flash Recovery Area for a Fast Recovery
9 User Managed Backup Configuring User Managed Backups
Perform a User Managed Backup
10 User Managed Recovery User Managed Complete Recovery
User Managed Incomplete Recovery
11 Configuring Flashback Flashback Query
Flashback Drop
Flashback Database
12 Performing Flashback Recoveries Flashback Query
Flashback Drop
Flashback Transaction Query
Flashback Versions Query
13 Performing Flashback Database Determining the FRA Size
FRA Retention
Performing a Flashback Database
14 RMAN Duplicate Command Setting up for a Duplicate Database
Creating the Duplicate spfiles
Performing the Duplicate Command.
15 RMAN Recovery Catalog Configuring for the Recovery Catalog
Creating the Recovery Catalog
16 Backups with the Recovery Catalog Registering the Database with the Recovery Catalog
Performing Backups with the Recovery Catalog
17 Recoveries with the Recovery Catalog Identifying Type of Recoveries with the Recovery Catalog
Performing Recoveries with the Recovery Catalog
18 Recovery Catalog Maintenance Registering Additional Databases with the Recovery Catalog
Cataloging Additional Backups with the Recovery Catalog
Recovery Catalog Scripts
19 DataPump Configuring Datapump
DataPump Exports
DataPump Imports
20 Tuning RMAN RMAN Sessions
RMAN Channels
RMAN Job Progress
Self-Paced

Free

Enroll icon
This course includes: :
Full lifetime access