From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Role of archived redo logs in backups

Role of archived redo logs in backups - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Role of archived redo logs in backups

“

- [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…

Contents