Course description
This Oracle Database 19c Backup and Recovery with RMAN course is designed to give an Oracle database administrator practical experience in planning and implementing a backup and recovery strategy using Recovery Manager and Flashback Database. The delegate will learn how to perform backup and recovery operations using RMAN and will learn how to use Flashback features to recover from human error.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 12cR2, 18c, 19c.
Who will the Course Benefit?The Oracle Database 19c Backup and Recovery with RMAN course is designed for database administrators, data warehouse administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle databases.
Course ObjectivesThe Oracle Database 19c Backup and Recovery with RMAN course is designed to provide the skills needed to enable a delegate to plan and implement a backup and recovery strategy in the workplace for Oracle Databases using RMAN and Flashback Database technologies.
Upcoming start dates
Suitability - Who should attend?
A working knowledge of Oracle SQL and Oracle Database Administration is required to attend the Oracle Database 19c Backup and Recovery with RMAN course. This can be obtained by attendance on the Oracle SQL course and a suitable database administration course. The ability to describe and use Oracle built-in packages would be advantageous, but is not essential.
This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.
Where Oracle 19c or 18c courses are listed in the Pre-requisite Courses section equivalent Oracle 12c courses would also suffice.
Experience to the level as demonstrated in these courses is recommended:
- Oracle SQL
- Oracle Database 19c Administration
Training Course Content
Oracle Database 19c Backup and Recovery with RMAN Training Course
Course Contents - DAY 1
Course Introduction- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Plan and Implement a Backup and Recovery Strategy
- Define a Disaster Recovery Plan
- Test a Backup and Recovery Plan
- Advantages and Disadvantages of Different Backup Methods
- Backup Methods Comparison
- Data Recovery Strategy
- Backup Strategy
- Validate the Recovery Strategy
- Architectural Components of Backup and Restore
- Physical Database Structures
- Logical Database Structures
- Dynamic Performance Views
- Redo Logs, Checkpoints and Archives
- Use the Flash Recovery Area (FRA)
- The Archivelog Modes of a Database
- Configure and Use Flashback Database
- Monitor Flashback Database
- Flash Recovery Area Space Usage
- Flashback Query
- Retrieve Row History with Flashback Versions Query
- Audit or Recover From Transactions with Flashback Transactions Query
- Flashback Table
- Recover Dropped Tables with Flashback Drop
- The Recycle Bin
- Recover Tables to a Point in Time With Flashback Table
- Flashback Database
- Flashback Restore Points
- Flashback Transaction Backout
- Flashback Data Archive
- RMAN Features and Components
- The sysbackup Privilege
- RMAN Commands
- Connect to RMAN
- Specify the Location of RMAN Output
- Start Up and Shut Down a Target Database Using RMAN
- Issue SQL Commands in RMAN
Course Contents - DAY 2
Session 5: CREATE AND CONFIGURE A RECOVERY CATALOG- Create a Recovery Catalog
- Register a Database
- Unregister a Database
- Control File Information
- Virtual Private Catalogs
- Backup a Recovery Catalog
- Use a Flashback Recovery Area with RMAN
- Configure Persistent RMAN Settings
- Set Retention Policies
- Configure Control File Autobackups
- Integrate RMAN with a Media Manager
- Channel Allocation
- Types of RMAN Backup
- Recovery Manager Commands
- Performing Backups
- Closed and Open Backups
- Incremental Backups
- Fast Incremental Backups using Block Change Tracking
- Backup File Image Copies
- Oracle Suggested Backup
- Validate Backups
- Listing Backups
- Create Multisection Backups
- Create Duplexed Backup Sets
- Create Compressed Backups
- Backup the Control File to a Trace File
- Backup Recovery Files
- Backup up ASM Metadata
- Change the Availability Status of Backups and Copies
- Catalog Backups Made with Operating System Commands
- Generate Backup Reports and Lists
- Cross Check Backups and Copies
- Delete Backups
- Update the Repository after Backup Deletion
- Drop Database and Archival Backups
- Import and Export the Recovery Catalog
- Use Data Dictionary Tables
- Create an Encrypted RMAN Backup
- Transparent Encryption
- Password Encryption
- Use Different Encryption Modes
Course Contents - DAY 3
Session 10: DATABASE FAILURE DIAGNOSTICS- The Automatic Diagnostic Repository
- The Data Recovery Advisor
- Understanding RMAN Messages and the Error Stack
- Diagnose Data File Loss
- Recovery with RESETLOGS
- Dealing with Block Corruption
- Restore and Recover
- Instance Failure and Crash Recovery
- Media Failure
- An Overview of Complete Recovery
- An Overview of Point in Time Recovery
- Recovery with RESETLOGS
- Perform Recovery in Noarchivelog Mode
- Perform Complete Recovery in Archivelog Mode
- Use the Flash Recovery Area for Fast Recovery
- Automatic Tempfile Recovery
- Identify the Database Files to Restore and Recover
- Preview Backups used in Restore Operations
- Apply Incremental Backups to Restore Datafile Image Copies
- The Switch Command
- The Data Recovery Advisor
- Perform Incomplete Recovery (PITR)
- Restore and Recover a tablespace
- Restore and Recover Datafiles
- Recover a Datafile Not Backed Up
- Table Recovery from Backups
- Recover Individual Data Blocks
- The Data Recovery Advisor
- Restore the Server Parameter File
- Restore the Control File
- Re-create the Password File
- Handling Redo Log File Loss
- Restore and Recover the Database on a New Host
- Restore RMAN Encrypted Backups
- Disaster recovery
Course Contents - DAY 4
Session 14: TABLESPACE POINT IN TIME RECOVERY (TSPITR)- Tablespace-Point-in-Time Overview
- Tablespace-Point-in-Time Example
- Transport Tablespaces
- Transport Databases
- Database Duplication
- Duplication Options
- Create Files for the Duplicate Database
- Prepare the Auxiliary Instance for Duplication
- Create a Duplicate Database
- Clone a Running Database
- An Overview of Using Cloud Control to Clone a Running Database
- Targetless Duplication of a Database
- Duplication Enhancements from 18c
- Tune Recovery Manager Overview
- Restore and Recovery Performance Best Practices
- Multiplexing in RMAN
- Diagnosing Performance Bottlenecks
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews
Average rating 5
Continuing Studies
Further Learning
- Oracle Database 19c Install & Upgrade
- Oracle Multitenant Administration
- Oracle Database 19c Data Guard
- Oracle Database 19c RAC and Grid Infrastructure Administration
- Oracle Database 12cR2, 18c and 19c New Features for Administrators
- Oracle Database 19c DBA Performance Tuning & Management
Request info
Why StayAhead. From a single person on a scheduled course to large scale training projects StayAhead Training have the expertise and experience to help. Established since 1992, StayAhead Training is recognised as one of the leading independent IT Training specialists...
Tarn again was very well spoken and thorough, he was happy to answer any questions and made the course enjoyable. Cannot recommend enough.