Oracle 12c Database Backup and Recovery
Oracle 12c Database Backup and Recovery Course Details:
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.
No classes are currenty scheduled for this course.
Call (919) 283-1674 to get a class scheduled online or in your area!
1. Backup and Recovery Concepts
- 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
2. Database Backups
- Create consistent database backups and incremental backups
- Automate database backups
- Monitor the flash recovery area
- Back your database up without shutting it down
3. Database Recovery
- Recover from loss of a control file, a redo log file, data files, temp files and undo tablespaces
4. Recovery Manager Configuration
- Parameters affecting RMAN
- Use of a flashback recovery area
- The CONFIGURE command
- Persistent settings
- NOCATALOG / CATALOG mode
- Channel allocation
- Controlfile autobackup
- Retention policies
5. Recovery Manager Operations
- 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
6. Non-Critical Loss Recovery
- Password and network files
- Read-Only tablespaces
- Temporary tablespaces
- Index tablespaces
- Redo log members / control files
7. Database Recovery
- Recovering the control file
- Reasons for incomplete recovery
- Recovery after RESETLOGS
- Incomplete recovery using RMAN
- Incomplete recovery using SQL
8. Flashback Database
- When to use
- Configuration and use
- Monitoring flashback database
- Flash recovery area maintenance
- Flash recovery area monitoring
9. User Error Recovery
- The new recycle bin
- Querying dropped tables
- Flashback versions query
- Flashback transaction query
10. Block Corruption Management
- DBVERIFY and ANALYZE
- DBMS_REPAIR
- Block media recovery
- DBMS_BLOCK_CHECKING parameter
- Using RMAN for block corruption recovery
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- Backup and recover the database
- Monitor, troubleshoot, and maintain the database
- Configure and use recovery manager
Lab 1: Configuring the database for backup
Lab 2: Basic Database Media Recovery
Lab 3: Archivelog Setup
Lab 4: Recovery Manager Configuration
Lab 5: Recovery Manager Backups
Lab 6: Database Recovery using RMAN
Lab 7: Flashback Database
Lab 8: Flashback for User Errors
Lab 9: Dealing with Block Corruption
- Knowledge of SQL
- Database administrators
- Support engineers
- Technical consultants
- Systems administrators
- Network managers