Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle Database 10g: Administration II Training

Oracle Database 10g: Administration II Training

Course#: WA1381

One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.

Objectives

The objective of this course is to equip database administrators with the skills necessary to backup a production Oracle database and to recover as much information as possible in the event of a major failure. Significant subjects to be considered are:

  • Consider the various archive modes that the database may operate in and the effect on recovery capabilities of each mode.
  • Consider advanced database configuration options that assist recovery of lost data.
  • Build a backup and recovery strategy with user-managed techniques.
  • Build a backup and recovery strategy with server-managed techniques and the RMAN tool.
  • Configure standby databases as part of disaster recovery using Oracle Data Guard.
  • Learn about advanced techniques that not only recover lost data but endeavor to do so efficiently and rapidly, allowing a quick return to normal operations.

Course Prerequisites 

Mandatory prerequisites for this course are the following courses:

  • The course Oracle Database 10g: Introduction to SQL
  • The course Oracle Database 10g: Program With PL/SQL
  • The course Oracle Database 10g: Administration I

Duration

Five days.

Outline of WA1381 Oracle Database 10g: Administration II Training

  1. DATABASE RECOVERY STRUCTURES  

  • THE MECHANISMS FOR RECOVERY
  • SQL STATEMENT EXECUTION
  • EXAMINING THE RECOVERY COMPONENTS

  2. IDENTIFYING THE DATA STRUCTURES

  • DATA STRUCTURES WITHIN THE DATABASE
  • IDENTIFYING THE TABLESPACES
  • IDENTIFYING THE CONTROL FILES
  • IDENTIFYING THE ALERT & TRACE FILES
  • IDENTIFYING THE REDO LOG FILES

  3. ARCHIVING  

  • DEVELOPMENT OF BACKUP & RECOVERY STRATEGIES
  • MANAGING THE ARCHIVE OPTIONS

  4. USER-MANAGED PHYSICAL BACKUPS

  • BACKUP CHARACTERISTICS
  • PERFORMING A FULL BACKUP
  • PERFORMING AN OFFLINE TABLESPACE BACKUP
  • PERFORMING AN ONLINE TABLESPACE BACKUP
  • PERFORMING SUSPEND MODE BACKUPS
  • PERFORMING A CONTROL FILE BACKUP

  5. AN OVERVIEW TO DATABASE RECOVERY  

  • THE RECOVERY
  • IDENTIFYING THE TYPE OF FAILURE

  6. INSTANCE RECOVERY & FAST-START

  7. USER-MANAGED COMPLETE MEDIA RECOVERY  

  • MEDIA FAILURE CONCEPTS
  • COMPLETE CLOSED RECOVERY
  • COMPLETE OPEN RECOVERY
  • HANDLING SPECIAL SITUATIONS

  8. USER-MANAGED INCOMPLETE MEDIA RECOVERY 

  • ABOUT INCOMPLETE RECOVERY
  • POINT-IN-TIME BASED RECOVERY
  • HANDLING SPECIAL SITUATIONS

  9. USER-MANAGED INCOMPLETE MEDIA RECOVERY  

  • ABOUT INCOMPLETE RECOVERY
  • POINT-IN-TIME BASED RECOVERY

  10. HANDLING & ANTICIPATING STUCK RECOVERIES  

  • ABOUT STUCK RECOVERIES
  • HANDLING CORRUPTION OF DATA
  • PERFORMING TRIAL RECOVERY \

  11. USER-MANAGED RECOVERY TROUBLESHOOTING 

  • MOVE DATA FILE LOCATION
  • RECOVERY WITH NO DATA FILE BACKUP
  • HANDLING READ ONLY TABLESPACES
  • HANDLING THE LOSS OF CONTROL FILES

  12. USING THE RECOVERY MANAGER (RMAN)

  • USING THE RECOVERY CATALOG
  • CONFIRMING REGISTRATION & OTHER OPERATIONS
  • USING RUN BLOCKS & SCRIPTS
  • ALLOCATING CHANNELS
  • ACCESSING RMAN VIA OEM

  13. SERVER-MANAGED BACKUPS WITH RMAN

  • PERFORMING FULL BACKUPS
  • PERFORMING INCREMENTAL BACKUPS

  14. EXPLORING ENHANCED RMAN CAPABILITIES

  • RESUME FAILED BACKUP OPERATIONS
  • ESTABLISHING A BACKUP RETENTION POLICY
  • SHOW ALL CONFIGURATION SETTINGS
  • GENERATE CATALOG REPORTS
  • REPORT SCHEMA
  • LIST INCARNATION

  15. SERVER-MANAGED RECOVERY WITH RMAN

  • RECOVERY MANAGER RECOVERY
  • PERFORMING RESTORATION & FILE MEDIA RECOVERY
  • PERFORMING BLOCK MEDIA RECOVERY

  16. STANDBY DATABASES WITH ORACLE DATA GUARD

  • ABOUT THE DATA GUARD ARCHITECTURE
  • DATA GUARD INTERFACES

  17. DATA GUARD CONFIGURATION & OPERATION

  • CONFIGURING LOG TRANSPORT
  • CONFIGURING LOG APPLY
  • DATABASE SWITCHOVER OPERATIONS
  • DATABASE FAILOVER OPERATION
  • MONITORING THE STANDBY DATABASE
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.