What is archived redo log failover?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is archived redo log failover?
Rating:
In releases prior to Oracle9i, Recovery Manager (RMAN) only looked in the first archive destination for archived redo logs when backing them up. However, in Oracle9i, RMAN can perform archived redo log failover. In other words, RMAN can perform the following tasks:
RMAN always backs up only one copy out of the identical copies of each distinct archived redo log.
For example, if the archived redo logs corresponding to the log sequence numbers 25, 26, 27, and 28 are archived to two archive destinations (Disk1 and Disk2), the control file will contain the archived redo log records as follows:
| 25 | Disk1/Arch25.log |
| 25 | Disk2/Arch25.log |
| 26 | Disk1/Arch26.log |
| 26 | Disk2/Arch26.log |
| 27 | Disk1/Arch27.log |
| 27 | Disk2/Arch27.log |
| 28 | Disk1/Arch28.log |
| 28 | Disk2/Arch28.log |
If, during the backup operation, Arch26.log and Arch28.log archived redo logs are missing from Disk1, RMAN can use the failover feature to back up the archived redo logs from Disk2 as follows:
| 25 | Disk1/Arch25.log | Disk1/Arch25.log |
| 26 | Disk1/Arch26.log (missing) | Disk2/Arch26.log |
| 27 | Disk1/Arch27.log | Disk1/Arch27.log |
| 28 | Disk1/Arch28.log (missing) | Disk2/Arch28.log |
Rating:
Was this information helpful?
Other articles
- What is an incomplete recovery?
- What is a differential incremental backup?
- What is data dictionary cache?
- What is SQL*Loader?
- How is a tablespace taken offline and online?