The Oracle Archived Redo Logs play a special role in database recovery. In this video, learn about the purpose of the Archived Redo Logs for Oracle Database recovery.
- [Instructor] Another important concept to understand…when it comes to Oracle database backup and recovery…is the role that archived redo logs,…or archived logs in short,…play in restoring your Oracle database backup.…As you know, the Oracle redo logs contain a log…of all transactions which have been applied…to your Oracle database.…Every single insert, delete, or update statement…is recorded in the redo logs.…
Essentially, they are a log of all database changes.…Oracle uses the redo logs for internal consistency.…When Oracle finishes writing to a redo log,…it performs what is known as a redo log switch…and starts writing to the next redo log.…At this point,…assuming database archive mode has been enabled,…the redo log to which Oracle completed writing…will become an archived redo log,…which is essentially a backup of the Oracle redo log file…just stored somewhere safe.…
And later, this redo log backup,…or archived redo log,…can be used in the database recovery process.…If you are not familiar with the concepts…
- 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
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.