Oracle Database 10g DBA Backup

Have Queries? Ask us +91 72592 22234

Course Overview


Oracle Database 10g DBA Backup

Course Content


BACKUP AND RECOVERY CONSIDERATIONS

  • Plan and Implement a Backup and Recovery Strategy
  • Define a Disaster Recovery Plan
  • Test a Backup and Recovery Plan
  • Advantages and Disadvantages of Different Backup Methods
  • Data Recovery Strategy
  • Backup Strategy
  • Validate the Recovery Strategy

ORACLE RECOVERY STRUCTURES AND PROCESSES

  • Architectural Components of Backup and Restore
  • Redo logs, Checkpoints and Archives
  • Multiplexing Control files and Redo Logs
  • Types of Failure in an Oracle Database
  • Flash Recovery Area

USING ARCHIVELOG AND NOARCHIVELOG MODES

  • The Archive Modes of a Database
  • Configure a Database in Archivelog Mode
  • Configure a Database in Noarchivelog Mode
  • Configure Multiple Redo Log Archive Processes
  • Configure Multiple Archival Destinations

FLASHBACK

  • Configure and Use Flashback Database
  • Monitor Flashback Database
  • Flash Recovery Area Space Usage
  • Flashback Query
  • Retrieve Row History with Flashback Versions Query
  • Audit or Recover From Transactions with Flashback Transactions Query
  • Flashback Table
  • Recover Dropped Tables with Flashback Drop
  • The Recycle Bin
  • Recover Tables to a Point In Time With Flashback Table
  • Flashback Database
  • Flashback Restore Points
  • Flashback Transaction Backout
  • Oracle Total Recall

RECOVERY MANAGER OVERVIEW

  • RMAN Features and Components
  • Connect to RMAN
  • Start Up and Shut Down a Target Database Using RMAN

CREATE AND CONFIGURE A RECOVERY CATALOG

  • Create a Recovery Catalog
  • Register a Database
  • Unregister a Database
  • Control File Information
  • RESYNC CATALOG Command
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup a Recovery Catalog
  • Use a Flashback Recovery Area
  • Configure Persistent RMAN Settings
  • Set Retention Policies
  • Configure Control File Autobackups

BACKUP WITH RMAN

  • Channel Allocation
  • Types of RMAN Backup
  • Backup Commands
  • Backup Sets Parallelization
  • Compressed Backups
  • Performing Backups
  • Full Closed and Open Backups
  • Incremental and Cumulative Backups
  • The Copy Command
  • Block Change Tracking
  • Backup Validate
  • Troubleshooting

CREATE A DUPLICATE DATABASE WITH RMAN

  • Database Duplication
  • Duplication Options
  • Create Files for the Duplicate Database
  • Prepare the Auxiliary Instance for Duplication
  • Create a Duplicate Database
  • Create a Duplicate Database with Enterprise Manager
  • Clone a Running Database
  • Use EM to Clone a Running Database
  • Targetless Duplication of a Database

MAINTAIN A RECOVERY CATALOG

  • Reset Command
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Generate Reports and Lists
  • Cross Check Backups and Copies
  • Delete Backups
  • Update the Repository after Backup Deletion
  • Drop Database and Archival Backups
  • Use Data Dictionary Tables

RESTORE AND RECOVER WITH RMAN

  • Perform Recovery in Noarchivelog Mode
  • Perform Complete Recovery in Archivelog Mode
  • Perform Incomplete Recovery
  • Use the Flash Recovery Area for Fast Recovery
  • Restore and Recover a tablespace
  • Automatic Tempfile Recovery
  • Restore and Recover Datafiles
  • Recover a Datafile Not Backed Up
  • Restore the Server Parameter File
  • Restore the Control File from Auto-Backup
  • Restore and Recover the Database on a New Host

MONITOR, TUNE AND TROUBLESHOOT BACKUP AND RECOVERY

  • Tune recovery Manager Overview
  • Tune RMAN Backup Performance
  • Instance Recovery Performance Tuning
  • Understand RMAN Output Messages
  • Troubleshoot RMAN

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234