RMAN Backup & Recovery

The primary goal is this course is to prepare the students to install, configure and implement backup and recovery systems using RMAN.

This Oracle RMAN course is an intensive 4-day course is designed to provide Oracle professionals with an in-depth understanding of the backup & recovery features of Oracle, specific Oracle concepts and knowledge required for RMAN and tips and techniques success.

exercises are used to demonstrate each feature of RMAN and the student will gain first-hand experience in the key Oracle backup & recovery concepts.

Audience

The backup and recovery training course assumes a basic knowledge of computer programming techniques, relational database concepts, SQL, and basic Oracle architecture.

This Oracle RMAN training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle backup & recovery. This includes Systems Administrators, Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand how to backup & recover any Oracle database.

RMAN Backup & Recovery Training Course

  • 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
      • Using export/import
    • 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