> > > 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

Dates and Booking
 
Click on town name to book Schedule
Slovenia
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Course language: English Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
Poland
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Course language: English Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
Turkey
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Course language: English Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
Czech Republic
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Course language: English Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
Hungary
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Course language: English Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
Romania
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Course language: English Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
Slovakia
30/09/2019 - 03/10/2019 FLEX training This is an English language FLEX course.   Time zone: Asia/Istanbul Enroll
02/12/2019 - 05/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Enroll
Europe
Italy
27/05/2019 - 30/05/2019 Rome Enroll
02/09/2019 - 05/09/2019 Milan Enroll
18/11/2019 - 21/11/2019 Rome Enroll
Switzerland
01/07/2019 - 04/07/2019 Zurich Enroll
30/09/2019 - 03/10/2019 Zurich Enroll
United Kingdom
27/08/2019 - 30/08/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
17/12/2019 - 20/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
This is a FLEX course, which is delivered both virtually and in the classroom.
 

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