This course provides a hands-on exposition of the Oracle Recovery Manager (RMAN) utility for backup and recovery of Oracle databases and additional capabilities. The course provides in-depth coverage of RMAN, for all releases: the current release is used for exercises and demonstrations, and the content back-ported as necessary for previous releases. This course is designed for database administrators, though IT Management will also find the content valuable for planning and infrastructure design purposes. As with all SkillBuilders courses, this class is highly customizable to your specific training requirements. Technical RequirementsNothing is required for labs (workshops). SkillBuilders will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class. Detailed specs can be found here. Also, we strongly recommend using two monitors for this class. Student Comments – “The instructor’s willingness to work with us and our many questions surrounding how RMAN works with our new backup product – Actifio. He was phenomenal!” “John [Watson], the instructor, is excellent!” Click on the REVIEWS tab above to see many more student comments. |
Course Features
- Lectures 0
- Quizzes 0
- Duration 5 Half Days (~20 hours)
- Skill level All levels
- Language English
- Students 67
- Assessments Yes
Introduction to Recovery Manager
- What is RMAN?
- Basic Features
- Use of Data Pump As Part Of A Backup Strategy
RMAN Architecture
- RMAN Components
- Component Releases
- The Control File
- Controlfile record keep time
- Control File Size
- NOCATALOG and CATALOG Mode
- Recovery Catalog Creation And Maintenance
RMAN Setup
- RMAN Installation
- Necessary privileges
- Password File
- Oracle Net
- Catalog Tablespace
- Create Catalog
- Register Database
- RMAN Startup Options
- The Fast Recovery Area
Executing RMAN Commands
- RMAN Command Basics
- Job Blocks
- Command Syntax
- Using SQL Statements from the RMAN Utility
- Commonly Used Commands
RMAN Channels
- Channel Concepts
- Manual Allocation
- Automatic Allocation
- Parallelism
Backup with RMAN
- Backup Concepts
- Backup Set Concepts
- Backupset Pieces
- Using RMAN to Backup ASM Files
- Control File and Spfile Backup
- Deleting Archive Logs After Backup
- Full Database, Tablespace, And Datafile Backup
- Compressed Backup
- Incremental and Cumulative Incremental Backup
- Enabling Change Tracking
- Using BACKUP for Image Copies
- Incrementally Updated Copies
- Backup Archive Logs
- Retention Policies: Recovery Window And Redundancy
- Overriding Retention Policy
- Using the Duration Parameter
Restore & Recovery with RMAN
- What Are We Protected Against?
- Recovery-Related Commands
- RESTORE Command
- RESTORE PREVIEW
- RECOVER Command
- Recover Deleted Files
- Recover Lost Tablespace
- Restore to New Location
- Incomplete (aka Point In Time) Recovery
- Control File Recovery
Database duplication and auxiliary databases
- For Standby
- To create another primary
- Duplication from backup or from the active database
- Point In Time Tablespace Recovery
- Table Recovery
Database flashback and the FRA
- The Fast Recovery Area
- Flashback technologies
- Database flashback architecture
- Configuring database flashback
- Using database flashback
- Database flashback and resetlogs
Scripting and Reporting
- Scripting
- Reporting
- Reporting: LIST
- Reporting: REPORT
- Reporting: Views
- Reporting: SHOW
Getting Started With Tapes
- Media Management Concepts
- Installing the MML
- Backup to Tape
- Environment Variables
- Default Tape Channels
- Configurable Tape Settings
- Setting Default SBT Channels
- Backup with Default Channels
- Tape Restore
RMAN Maintenance
- Expired Backups
- Cross-Checking Backups
- Listing Expired Backups
- Status of All Backups
- Deleting Expired Backups
- Obsolete Backups
- Deleting Obsolete Backups
RMAN Case Studies
- Configure the database for recoverability in all circumstances
- Diagnose problems
- Use the Recovery Advisor
- # 1 – Lost Control File
- # 2 – Lost online or archive redolog file(s)
- # 3 – Tuning
- # 4 – Dropped Tablespace
- # 5 – Damaged critical datafile
- # 6 – Damaged non-critical datafile
- # 7 – Dropped schema
- # 8 – Damaged Temporary Tablespace
- # 9 – Combinations of all the above