 |
|
Oracle Backup & Recovery
 Click here to contact us
Course Overview
Oracle Backup & Recovery introduces students to the critical task of designing, planning and implementing database backup and recovery strategies. Database administrators will use various techniques, strategies and Oracle tools, such as recovery manager (RMAN), to perform backups and restore and recover operations. They will evaluate hypothetical backup and recovery failure scenarios and make recommendations for corrective actions based on business requirements. This course includes case studies and a workshop.
Course Goals
- To design effective backup and recovery strategies
- To review the Oracle architecture components that relate to backup and recovery
- To understand RMAN architecture components
- To learn how to implement physical backups with and without RMAN and implement logical backups
- To diagnose and troubleshoot common database problems and failures
- To formulate effective Oracle backup methods and appropriate operations to resolve database failures
- To explore new features of the Oracle Database
Prerequisites
- SQL & SQL*Plus
- PL/SQL (optional)
- Database administration
Who Should Attend?
- Network administrators
- Database administrators
- System administrators
- Application developers
Course Materials
- Oracle Backup & Recovery Course Notes
- Oracle Backup & Recovery Reference Publication
- Sample Script Disks
Duration
Tuition
Course Outline
- Introductions
- The 10 keys of a bulletproof backup strategy
- Designing effective backup and recovery strategies
- Archivelog vs. noarchivelog
- Disaster recovery
- Types of failures
- User
- Process
- Instance
- Statement
- Media
- Configure database archiving
- Prepare parameter file
- Put database into archivelog mode
- Test archiving
- Backup the Oracle Database
- Physical Oracle backups
- Steps to perform cold backup
- Steps to perform hot backup
- Logical Oracle backup
- Complete Oracle Database recovery
- Complete recovery concepts
- Types of complete recovery
- Database
- Datafile
- Tablespace
- Steps to perform complete database recoveries
- Incomplete Oracle Database recovery
- Incomplete recovery concepts
- Types of incomplete recovery
- Cancel-based
- Time-based
- Change-based
- Steps to perform incomplete database recoveries
- Introduction to RMAN
- Discuss RMAN architecture
- Comparison of RMAN backup methods
- Create a recovery catalog
- Maintenance of the recovery catalog
- Resync recovery catalog
- RMAN commands: backup and copy
- Create RMAN scripts
- Store and execute RMAN scripts
- Tools for troubleshooting problems
- Error log and Trace files
- Detection of corrupt blocks
- Repair corrupt blocks
- DBVERIFY utility
- DBMS_Repair
- LogMiner utility
- V$Views
- Flashback query
- Standby databases
- Benefits of a standby database
- Create standby database
- Case studies
- Missing/lost datafile
- Failure during hot backup
- Loss of a controlfile
- Loss of a rollback segment
- Loss of an online redo log
- Recovering from user errors
- New Oracle 10g backup and recovery features
- Flash recovery area
- Oracle flashback database
- Incrementally updated backups: rolling forward image copies
- Disk topology and automatic performance tuning
- Automatic datafile creation
- Recovery through resetlogs
- Restore failover
- BACKUP command creates backup sets or image copies
- Fast incremental backups
- Channel failover
- Improved RMAN reporting through V$ views
- Cross-platform tablespace conversion
- Enhanced reporting: RESTORE PREVIEW
|
|
|
|
