> > > ORBR12C

Oracle Database 12c: Backup and Recovery Workshop (ORBR12C)

Course Description Schedule Course Outline
 

Course Overview

All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this training textbook is to assist you in doing just that, and this is one of the most essential modules in the entire Sideris Oracle 12c database administrator curriculum.

Among the tools and facilities that you will learn to use are the Oracle Recovery Manager (RMAN), the Enterprise Manager 12c Cloud Control, the Data Recovery Advisor, Oracle Flashback technologies, Redo Log File Size Advisor and the MTTR Advisor. Since it can be tempting to short-cut appropriate backup procedures if these perform poorly, special attention is given to backup performance and optimization.

Who should attend

The primary target audiences:

  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers

Course Objectives

  • Automatically managed backup strategies and database recovery operations using RMAN, the Enterprise Manager Cloud Control, and other database facilities.
  • Database instance recovery, tuning checkpoints, the Redo Log File Size Advisor and the MTTR Advisor.
  • User-managed recovery scenarios, including recovery from temporary, read-only and index tablespaces.
  • Complete and incomplete media recovery, including database point-in-time, tablespace and table point-in-time recovery.
  • Configure a centralized recovery catalog. Deploy standardized and consistent backup and recovery procedures throughout the enterprise by means of dynamic stored scripts and variable substitution.
  • Optimizing backups for faster performance and parallelization of operations, employing compression algorithms and other strategies for optimum efficiency.
  • Achieve data preservation through archival backups.
  • Duplicate and clone databases for regulatory compliance, Real Application Testing database replay, test configuration and other purposes.
  • Tablespace transportation, database transportation, cross-platform transportation and endian format conversion.
  • Detect and handle failures and corruption, including the use of RMAN block recovery and the Data Recovery Advisor.
  • Newly released or enhanced features such as backup file compression, encryption, parallelization and others.
  • Recovering from logical failure using appropriate Oracle Flashback technologies, such as Flashback Table, Flashback Drop and Flashback Database.

Course Content

  • Getting Started: About Database Failure & Recovery
  • Getting Started: Configure The Database For Recovery
  • Getting Started: Automatic Instance Recovery
  • BACKUP: CONFIGURE RMAN
  • Backup: Perform RMAN Backups
  • Backup: RMAN Management With EM
  • The RMAN Recovery Catalog
  • Recovery: User-Managed Recover
  • Recovery: RMAN Recovery
  • Advanced: Enhanced RMAN Capabilities
  • Advanced: Database Duplication & Cloning
  • Advanced: Data Transportation
  • Advanced: Handling Corruption With Data Recovery Advisor
  • Flashback: About Oracle Flashback Technology
  • Flashback: Recovery Using Oracle Flashback Technology
Classroom Training
Modality: C

Duration 4 days

Price (excl. tax)
  • Germany: 2,000.- €
  • Switzerland: Fr. 2,320.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Dates and Booking
 
Click on town name to book Schedule
This is a FLEX course, which is delivered both virtually and in the classroom.
Germany

Currently no local training dates available.  For enquiries please write to info@flane.de.

FLEX Training

Please see below our alternative, English language, FLEX course options.

28/01/2019 - 31/01/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Budapest
08/04/2019 - 11/04/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Zagreb
28/05/2019 - 31/05/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
27/08/2019 - 30/08/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.
Time zone: Asia/Istanbul
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
17/12/2019 - 20/12/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
Switzerland
07/01/2019 - 10/01/2019 Zurich
01/04/2019 - 04/04/2019 Zurich
01/07/2019 - 04/07/2019 Zurich
30/09/2019 - 03/10/2019 Zurich

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Europe
Croatia
08/04/2019 - 11/04/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Zagreb
Hungary
28/01/2019 - 31/01/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Budapest
Italy
25/02/2019 - 28/02/2019 Milan
27/05/2019 - 30/05/2019 Rome
02/09/2019 - 05/09/2019 Milan
18/11/2019 - 21/11/2019 Rome
Romania
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
Turkey
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.
Time zone: Asia/Istanbul
United Kingdom
28/05/2019 - 31/05/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
27/08/2019 - 30/08/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
17/12/2019 - 20/12/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!