Oracle 18c Database Administration 2 - Advanced Administration & Backup and Recovery

Catalog Home Databases, Business Intelligence & Data Science Oracle Administration
Your Training Location:  

Oracle 18c Database Administration 2 - Advanced Administration & Backup and Recovery

Let us know if you would like a date for this course added to our schedule

This course provides follow on education for moderately experienced administration of the Oracle database. The course includes coverage of conceptual topics needed for more in-depth understanding of increasingly complex administrative tasks, extensive coverage of Oracle network interaction, specialized database structures, advanced administrative tools, and comprehensive backup and recovery strategies and methodologies.

Backup and recovery concepts are reviewed followed by in-depth coverage of user managed and RMAN backup and recovery techniques. Using Oracle Recovery Manger (RMAN) to perform backups (cold and hot) and database recoveries (complete and point in time ‘PITR’) are a primary focuses of the class.

The Oracle instance, background processes, the SGA and memory structures are explored. Various models of data concurrency and consistency and alternative isolation levels are explained along with their uses.

Oracle provides many, many network-centric features for configuring the database to make optimal use of a network and to provide custom quality of service. The high-end options, configuration, optimization and ruggedization of the Oracle network interaction is given broad coverage.

Specialized database objects that serve as alternatives to traditional relational tables are reviewed as are their appropriate uses.

The many optional styles of indexes provided by Oracle are covered, with emphasis on the correct situations in which they can be deployed to best advantage.

  • Skill with GUI interfaces
  • Data processing background
  • An understanding of SQL is required to succeed in this class

4 Days/Lecture & Lab

This course is designed for: • Oracle developers and moderately experienced DBAs

  • Oracle developers and DBAs wishing to ‘back fill’ gaps in their expertise
  • Administrators responsible for performing or managing Oracle backup and recovery
  • Technical managers needing Oracle expertise for project administration

  • Oracle Architecture
  • Concurrency and Consistency
  • Oracle Net Services
  • Alternative Data Types
  • Table Alternatives
  • Advanced Indexing
  • Database Resource Management
  • The Oracle Scheduler
  • Database Startup and Shutdown
  • Database Backup and Recovery Concepts
  • User Managed Backup and Recovery
  • Segment and Block Storage Management
  • Block Corruption Recovery
  • Recovering from Non-Critical Losses
  • RMAN Overview
  • Configuring RMAN
  • RMAN Backup Management
  • RMAN Recovery Techniques
  • Flashback Techniques
  • Flashback Database

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media