Skip to content

Innovative Technology Solutions

Oracle Database 19c: Backup and Recovery/1z0-083 Training

Through a blend of hands-on labs and interactive lectures you will also learn how to perform backup and recovery operations using RMAN and also various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures

6546 Ratings
4.6/5

6467 Learners

Oracle Database 19c: Backup and Recovery/1z0-083 Course Overview

Enroll for the 5-day Oracle Database 19c: Backup and Recovery from Koenig Solutions accredited by Oracle. This course is designed to give an Oracle database administrator practical experience in planning and implementing a backup and recovery strategy using Recovery Manager and Flashback Database.

Oracle 1z0-083

Learning Objectives

Key Features

Benefits

Oracle Database 19c provides customers with industry-leading performance, reliability and security for both transactional and analytic workloads, that can easily scale to meet the most demanding requirements whether deployed on-premises or in the Cloud.

Training Options

Self-Paced eLearning

19,999
  • Lifetime access to recorded self-paced eLearning course created by industry experts
  • 3.simulation test for Practice
  • 24x7 learner assistance and support

Corporate Training

Customized
  • Live Instructor Led / Campus delivery model
  • Flexible pricing options according to your requirements
  • Pre & Post evaluation test for comparison
  • 24x7 support & assistance

Course Curriculum

Target Audience

  • Administrator
  • Database Administrator

Pre-requisites

  • Oracle Database: Administration Workshop
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

Course Content

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions
  • Plan and Implement a Backup and Recovery Strategy
  • Define a Disaster Recovery Plan
  • Test a Backup and Recovery Plan
  • Advantages and Disadvantages of Different Backup Methods
  • Backup Methods Comparison
  • Data Recovery Strategy
  • Backup Strategy
  • Validate the Recovery Strategy
  • Architectural Components of Backup and Restore
  • Physical Database Structures
  • Logical Database Structures
  • Dynamic Performance Views
  • Redo Logs,Checkpoints and Archives
  • Use the Flash Recovery Area (FRA)
  • The Archivelog Modes of a Database
  • Configure and Use Flashback Database
  • Monitor Flashback Database
  • Flash Recovery Area Space Usage
  • Flashback Query
  • Retrieve Row History with Flashback Versions Query
  • Audit or Recover From Transactions with Flashback Transactions Query
  • Flashback Table
  • Recover Dropped Tables with Flashback Drop
  • The Recycle Bin
  • Recover Tables to a Point in Time With Flashback Table
  • Flashback Database
  • Flashback Restore Points
  • Flashback Transaction Backout
  • Flashback Data Archive
  • RMAN Features and Components
  • The sysbackup Privilege
  • RMAN Commands
  • Connect to RMAN
  • Specify the Location of RMAN Output
  • Start Up and Shut Down a Target Database Using RMAN
  • Issue SQL Commands in RMAN
  • Create a Recovery Catalog
  • Register a Database
  • Unregister a Database
  • Control File Information
  • Virtual Private Catalogs
  • Backup a Recovery Catalog
  • Use a Flashback Recovery Area with RMAN
  • Configure Persistent RMAN Settings
  • Set Retention Policies
  • Configure Control File Autobackups
  • Integrate RMAN with a Media Manager
  • Channel Allocation
  • Types of RMAN Backup
  • Recovery Manager Commands
  • Performing Backups
  • Closed and Open Backups
  • Incremental Backups
  • Fast Incremental Backups using Block Change Tracking
  • Backup File Image Copies
  • Oracle Suggested Backup
  • Validate Backups
  • Listing Backups
  • Create Multisection Backups
  • Create Duplexed Backup Sets
  • Create Compressed Backups
  • Backup the Control File to a Trace File
  • Backup Recovery Files
  • Backup up ASM Metadata
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Generate Backup Reports and Lists
  • Cross Check Backups and Copies
  • Delete Backups
  • Update the Repository after Backup Deletion
  • Drop Database and Archival Backups
  • Import and Export the Recovery Catalog
  • Use Data Dictionary Tables
  • Create an Encrypted RMAN Backup
  • Transparent Encryption
  • Password Encryption
  • Use Different Encryption Modes
  • The Automatic Diagnostic Repository
  • The Data Recovery Advisor
  • Understanding RMAN Messages and the Error Stack
  • Diagnose Data File Loss
  • Recovery with RESETLOGS
  • Dealing with Block Corruption
  • Restore and Recover
  • Instance Failure and Crash Recovery
  • Media Failure
  • An Overview of Complete Recovery
  • An Overview of Point in Time Recovery
  • Recovery with RESETLOGS
  • Perform Recovery in Noarchivelog Mode
  • Perform Complete Recovery in Archivelog Mode
  • Use the Flash Recovery Area for Fast Recovery
  • Automatic Tempfile Recovery
  • Identify the Database Files to Restore and Recover
  • Preview Backups used in Restore Operations
  • Apply Incremental Backups to Restore Datafile Image Copies
  • The Switch Command
  • The Data Recovery Advisor
  • Perform Incomplete Recovery (PITR)
  • Restore and Recover a tablespace
  • Restore and Recover Datafiles
  • Recover a Datafile Not Backed Up
  • Table Recovery from Backups
  • Recover Individual Data Blocks
  • The Data Recovery Advisor
  • Restore the Server Parameter File
  • Restore the Control File
  • Re-create the Password File
  • Handling Redo Log File Loss
  • Restore and Recover the Database on a New Host
  • Restore RMAN Encrypted Backups
  • Disaster recovery
  • Tablespace-Point-in-Time Overview
  • Tablespace-Point-in-Time Example
  • Transport Tablespaces
  • Transport Databases
  • Database Duplication
  • Duplication Options
  • Create Files for the Duplicate Database
  • Prepare the Auxiliary Instance for Duplication
  • Create a Duplicate Database
  • Clone a Running Database
  • An Overview of Using Cloud Control to Clone a Running Database
  • Targetless Duplication of a Database
  • Duplication Enhancements from 18c
  • Tune Recovery Manager Overview
  • Restore and Recovery Performance Best Practices
  • Multiplexing in RMAN
  • Diagnosing Performance Bottlenecks

Oracle Database 1Z0-083 Exam Format

1z0-083

Multiple Choice Questions (MCQ)

68 Questions

120 Minutes

Reviews

Rohit
Rohit
2020-04-13
Verified review
Training was good , thanks for the session.
Abhishek Hegde
Abhishek Hegde
2020-04-10
Verified review
Decently conducted training on Azure related to AZ-900 course. Relatable examples taken by the instructor for basics. Needed even more in depth and maybe more concepts and time with pros and cons. Overall good one.
Madhur Mall
Madhur Mall
2020-04-10
Verified review
Session was good covering basics with simple and relate-able examples.
Chetan Gullia
Chetan Gullia
2020-04-10
Verified review
Amazing experience while having Azure Cloud Training :).
Dharmendra Kumar
Dharmendra Kumar
2020-04-10
Verified review
Bhavesh Pali is a excellent trainer. Azure cloud training was awesome and well explained by Bhavesh. Thanks Again to ITS group.
Swapnil Phirke
Swapnil Phirke
2020-04-10
Verified review
Very good Training and specially trainer Mr Bhavesh has good enough knowledge to answer all queries, content is also good. Training duration need to increase as trainer has more things to share but not possible to lack of time
Kapil Ahuja
Kapil Ahuja
2020-04-10
Verified review
All modules were well covered with examples , The conceptual understanding provided by using whiteboard also helped us to grasp the concepts faster.
Nirbhay Singh
Nirbhay Singh
2020-04-10
Verified review
Thanks Bhavesh for Azure Fundamentals - AZ900

Why Innovative Technology Solutions

Our Virtual Instructor Led Training model brings classroom learning experience online. With our world-class LMS instructor-led training, self-paced E-learning and personalized mentoring you will get an immersive first-class learning experience.

Self-Paced E-learning

A self-paced e-learning with recorded video sessions that you can access anytime without going beyond your comfort zone.

Live Virtual Classroom

An interactive classroom style virtual instructor led training to engage and learn more alongside your peers with a live trainer.

Learner's Community

A Social forum where you can ask your questions, one of our expert will reply you within 24 hours on that community.

Online Access of Labs

Online access of practise labs that you can access anytime, anywhere your machine.

Industry Based Projects

Real-time Industry based projects will be shared by the trainers throughout the program

24/7 Assistance

Get engaged with integrated support assistance on your desktop and mobile learning

FAQs

Trainer will be Oracle certified having more than 15 years of experience in training and working in the IT field.

No, Exam Voucher fee is not included in the course fee.

Our Online classroom (Instructor-Led) training for Microsoft Azure Administrator will be conducted via live streaming app like zoom, Web-ex, or blue jeans by an Microsoft certified trainer having experience of more than 15 years in IT domain & training.