"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
Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...
All 20 points are in our latest Newsletter - Delivered directly to your inbox
CONTACT
+44 (0)20 8446 7555
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
