"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
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
"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
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.
CONTACT
+44 (0)20 8446 7555
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