Overview
Course Description
Thank you for reading this post, don't forget to subscribe!In this course, you’ll learn about backup and recovery techniques, which includes hands-on exercises to reinforce the material covered. This course is designed to help you prepare you for the Oracle Certified Associate and Oracle Certified Professional exams.
Audience Profile
- Database administrators
- Support engineers
- Technical consultants
- Systems administrators
- Network managers
Prerequisites
- Knowledge of SQL
- Oracle 12c SQL & SQLPLUS Express Introduction
- Oracle 12c PL/SQL Introduction
Learning Objectives
- Backup and recover the database
- Monitor, troubleshoot, and maintain the database
- Configure and use recovery manager
Course Outline
Course Outline
Module 1: Backup and Recovery Concepts
Lessons
• Describe the basics of database backup, restore, and recovery
• List the types of failure that may occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log file
• Configure ARCHIVELOG mode
• Flashback Database / Table / Query
Module 2: Database Backups
Lessons
• Create consistent database backups and incremental backups
• Automate database backups
• Monitor the flash recovery area
• Back your database up without shutting it down
Lab: Configuring the database for backup
Module 3: Database Recovery
Lessons
• Recover from loss of a control file, redo log file, data files, temp files and undo tablespaces
Lab: Basic Database Media Recovery
Lab: Archivelog Setup
Module 4: Recovery Manager Configuration
Lessons
• Parameters affecting RMAN
• Use of a flashback recovery area
• The CONFIGURE command
• Persistent settings
• NOCATALOG / CATALOG mode
• Channel allocation
• Controlfile autobackup
• Retention policies
Lab: Recovery Manager Configuration
Module 5: Recovery Manager Operations
Lessons
• Using the BACKUP command
• Creating backup sets / image copies
• Parallelization
• Compressed backups
• Whole database copying
• Incremental backups
• Block change tracking
• RMAN backup monitoring
• REPORT and LIST commands
Lab: Recovery Manager Backups
Module 6: Non-Critical Loss Recovery
Lessons
• Password and network files
• Read-Only tablespaces
• Temporary tablespaces
• Index tablespaces
• Redo log members / control files
Module 7: Database Recovery
Lessons
• Recovering the control file
• Reasons for incomplete recovery
• Recovery after RESETLOGS
• Incomplete recovery using RMAN
• Incomplete recovery using SQL
Lab: Database Recovery Using RMAN
Module 8: Flashback Database
Lessons
• When to use
• Configuration and use
• Monitoring flashback database
• Flash recovery area maintenance
• Flash recovery area monitoring
Lab: Flashback Database
Module 9: User Error Recovery
Lessons
• The new recycle bin
• Querying dropped tables
• Flashback versions query
• Flashback transaction query
Lab: Flashback for User Errors
Module 10: Block Corruption Management
Lessons
• DBVERIFY and ANALYZE
• DBMS_REPAIR
• Block media recovery
• DBMS_BLOCK_CHECKING parameter
• Using RMAN for block corruption recovery
Lab: Dealing with Block Corruption