Mississauga College of Technology

Tel: 905.232.8628 Fax: 905.232.1672

Address: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5

E-mail: info@mississaugacollege.com

Backup and Recovery Workshop   <OBKR123>

Scope

The workshop, primarily and effectively focus on implementing backup and recovery techniques on Oracle Database.

Objective

The objective of this workshop is to provide hands-on experience in taking back-up with different scenarios, and restoring backup

Topics

  • Recap of Oracle Architecture
  • Backup and recovery concept and techniques
  • Creating and Configuring recovery catalog
  • Creating and configuring virtual private catalog
  • Using Enterprise Manager, creating normal and compressed backup
  • Using RMAN, backing up archived Redo logs, copying whole Database
  • Using RMAN, creating incremental backup and Tracking block change
  • Understanding RMAN dynamic views and monitoring RMAN Backups
  • Managing Backups through EM
  • Recovering from non-critical files
  • Recovering and Restoring complete database
  • Recovering database until time and sequence
  • Recovering after losing all control files
  • Recovering complete database while in database running in archive mode
  • Recovering image copies
  • Restoring database in no-archive mode
  • Recovering database using server commands such as Recover and Restore
  • Recovering using Flashback
  • Backing up flash back recovery area

Achievements

The students shall gain more confidence while taking back-up, and recovering database independently and confidently using different scenarios.

Pre-requisites

SQL, DBA workshop I

Audience

Programmers, Developer, Systems Analysts, Data Warehouse Builders, Technical Writers, Technical Manager, Project Manager, DBA

Duration: 25 hours

Fee: $750.00

Copyright © 2012 Mississauga College of Technolog All Rights Reserved
Call Today: 905-232-8628
blogger
linkedin
twitter
facebook
EmailEmail: info@mississaugacollege.com
AddressAddress: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5
Developed by Jimvisual