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
Classroom or Remote
Remote
Receive the latest version of this course by email & subscribe to our Newsletter
CONTACT
+44 (0)20 8446 7555
enquiries@jbinternational.co.uk
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address 1345 High Road, London, N20 9HR
POPULAR
AI & ML 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
Biztalk training course