LIVE Instructor-Led Courses
Dismiss

Oracle Backup & Recovery Essentials training course

Gain a comprehensive understanding of the backup and recovery of Oracle Database

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

08/04/24 - 2 days
£1200 +VAT
20/05/24 - 2 days
£1200 +VAT
01/07/24 - 2 days
£1200 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

Review the Oracle database architecture
Understand backup and recovery requirements
Perform different types of backups
Perform recovery of the different database file types

 

•    Oracle Architecture Review                                                                    
            Oracle Components
            The Oracle Instance
            The Oracle Database
            Oracle Processes
            The Listener

•    Backup Management                                                                                                       
            Understanding ARCHIVELOG Mode
            Understanding Recovery Manager (RMAN)
            Persistent Configuration Parameters
            Performing Backups
•    Restore and Recovery Concepts
Complete Recovery (Overview)
Instance Failure and Instance/Crash Recovery
Restoring and Recovering
Point-in-Time Recovery (Overview)
Recovery with the RESETLOGS Option
Media Failure
•    Performing Recovery
RMAN Recovery in NOARCHIVELOG Mode
Performing Point-in-Time (PITR) or Incomplete Recovery
Recovery with Image Files
Performing Complete Recovery
Restoring ASM Disk Groups
Redo Log File Loss and Recovery
Restoring RMAN Encrypted Backups
Recovery of Server Parameter File, Control File
Restoring the Database to a New Host
Disaster Recovery
Index, Read-Only Tablespace and Tempfile Recovery
Password Authentication File Re-creation
•    Using Flashback Technologies
Using Flashback Technology to Query Data
Flashback Drop and the Recycle Bin
Flashback Transaction (Query and Backout)
Flashback Technology: Overview and Setup
Flashback Table
Flashback Data Archive
•    Using Flashback Database
Configuring Flashback Database
Flashback Database Architecture
Best Practices for Flashback Database
Performing Flashback Database
•    Performing Point-in-Time Recovery
Performing RMAN TS Point-in-time Recovery
When to use TSPITR
Recovering Tables from Backups
TSPITR Architecture

 

JBI training course London UK

This course is for administrators and support staff

5 star

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022



“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



This short Oracle Database Recovery Manager training course / Workshop will provide a comprehensive understanding of the backup and recovery topic.  The workshop has an emphasis on the practical requirements for implementing a backup strategy using Recovery Manager (RMAN).  The course is suitable for versions of Oracle database up to and including 12.1.0.2.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course