When creating database backups, you can either create Physical or Logical copies of your database. Different types of backups are useful for recovery from different failure scenarios. In this video, learn about the differences between Oracle physical and logical backups and which types of backups RMAN and Data Pump create.
- Two more important concepts we should discuss…when it comes to Oracle backup and recovery…are physical and logical backups…which are two distinct backup categories.…A database backup, as you probably know,…is essentially a copy of your database data…stored outside your database which can later…be used to reconstruct your database data…in case the database itself is damaged or lost.…Physical Oracle backups is the name…used to describe the backup method that,…upon completion, create copies of the…actual Oracle database files,…logs and disk-level data structures which Oracle…uses to store data.…
For example, using the operating system…COPY command to copy the contents…of your Oracle data directory such as copying…your data files, redo logs, control files and so on,…somewhere else for safekeeping is considered…a physical backup method.…Additionally Oracle RMAN, which is…Oracle's primary backup technology…is a tool which you can use…to create physical Oracle backups.…Physical backups are the core foundation…for any successful Oracle backup strategy.…
- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points
Skill Level Intermediate
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
1. Backup and Recovery Core Concepts
2. Failure Categories and Backup Types
3. Preparing the Course VM
4. User-Managed Backups
5. Recovery Manager (RMAN)
6. Oracle Data Pump
7. Oracle Flashback
What's next?2m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.