Oracle Backup & Recovery Essentials training course

Highlights

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

Course Details

•   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

Who should attend

This course is for administrators and support staff

Feedback

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

Certification

Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

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.

FAQs

JBI Training offers twelve Oracle database courses. These include Oracle SQL Foundation (three days), Oracle SQL Advanced (four days), Oracle PL/SQL Foundation (three days), Oracle PL/SQL and Packages (five days), Oracle DBA Part 1 (five days), Oracle DBA Part 2 (three days), Oracle Admin Essentials (three days), Oracle Performance Tuning (three days), Oracle AWR Usage (three days), Oracle Backup and Recovery Essentials (two days), Oracle GoldenGate Essentials (three days), and Oracle 12c New Features (five days). All are available in London, online, or as customised onsite programmes.

Oracle SQL Foundation is a three-day course for professionals new to Oracle SQL, covering core querying, filtering, sorting, joins, aggregations, subqueries, and DML statements for inserting, updating, and deleting data. Oracle SQL Advanced is a four-day course for those with existing Oracle SQL experience who want to go deeper — covering advanced query techniques, analytical functions, hierarchical queries, XML and JSON handling in Oracle, performance considerations for SQL queries, and advanced features of the Oracle SQL dialect. Delegates should have solid SQL Foundation-level experience before attending the Advanced course.

PL/SQL (Procedural Language/SQL) is Oracle's proprietary procedural extension to SQL, used to write stored procedures, functions, triggers, and packages that run directly within the Oracle database. JBI offers two PL/SQL courses. Oracle PL/SQL Foundation (three days) covers the PL/SQL block structure, variables and data types, control flow, cursors, exception handling, and creating stored procedures and functions. Oracle PL/SQL and Packages (five days) extends this to cover packages, triggers, dynamic SQL, collections, bulk processing, advanced exception handling, and performance optimisation of PL/SQL code. Both courses are suited to Oracle developers and database programmers.

Oracle GoldenGate is a high-performance data replication and integration platform used to capture, transform, and deliver data changes between databases in real time — supporting use cases including zero-downtime migrations, high availability, disaster recovery, and real-time data integration between Oracle and heterogeneous database environments. JBI's three-day Oracle GoldenGate Essentials course covers the GoldenGate architecture, configuring Extract and Replicat processes, managing trails and checkpoints, monitoring and troubleshooting replication, and applying GoldenGate to common enterprise scenarios. It is suited to Oracle DBAs, data engineers, and integration architects working in environments where real-time data replication is required.

The three-day Oracle Performance Tuning course covers the techniques and tools used to identify and resolve performance problems in Oracle database environments. Topics include understanding the Oracle architecture from a performance perspective, using Explain Plan and SQL trace to analyse query execution, tuning SQL queries for optimal execution plans, using Oracle's Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance analysis, index design and management, memory configuration tuning, and I/O optimisation. It is suited to Oracle DBAs, senior developers, and database architects who are responsible for the performance and scalability of Oracle database systems in production environments.

Oracle DBA Part 1 is a five-day comprehensive foundation for Oracle database administration, covering Oracle architecture, installation and configuration, managing tablespaces and datafiles, user management and security, backup and recovery using RMAN, network configuration, and routine DBA operational tasks. Oracle DBA Part 2 is a three-day advanced programme for DBAs who have completed Part 1 or have equivalent experience, covering more complex administration topics including advanced backup and recovery strategies, Flashback technology, resource management, performance monitoring, and managing Oracle in more complex multi-tier environments. Together the two programmes provide a thorough, practical grounding in professional Oracle database administration.

Yes. All Oracle courses at JBI can be delivered as customised onsite or online programmes for corporate Oracle database teams. Content can be tailored to the team's Oracle version, existing environment, specific performance challenges, or DBA responsibilities. For example, a team managing Oracle in a high-availability environment can receive training focused on GoldenGate, backup and recovery, and performance tuning, while a development team building Oracle-backed applications can receive an integrated SQL and PL/SQL programme. JBI has delivered Oracle database training for teams at organisations including the BBC, NHS, RBS, Sky, EDF, and Cisco.

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

Public Courses

Customised Courses

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

What Oracle training courses does JBI Training offer?

What is the difference between Oracle SQL Foundation and Oracle SQL Advanced?

What is PL/SQL and what do the PL/SQL courses cover?

What is Oracle GoldenGate and what does the GoldenGate Essentials course cover?

What does Oracle Performance Tuning cover and who should attend?

What is covered across the Oracle DBA Part 1 and Part 2 courses?

Can Oracle training be customised for a corporate database team?

Email this page to yourself