| Goal |
|---|
| Solution |
|---|
| References |
|---|
_This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review._
Applies to:
Oracle Database – Enterprise Edition – Version 10.1.0.2 and later
Information in this document applies to any platform.
Goal
How to resolve RMAN-06054: media recovery requesting unknown archived log
Solution
The RMAN-06054 occurs during recovery or backup-based duplicate when RMAN is unable to find a backup of the sequence reported by the error.
Follow these steps to diagnose and resolve the issue…
- Using the sequence# (and thread#) returned by the query, execute:
- If no backup information is returned, then the error is legitimate and you must determine whether:
a. Another backup must be taken from the source. If a new backup of archivelog files is executed, you must ensure the controlfile mounted by the recovery has information on this new backup. This is done using the 'catalog' command.
b. The 'until' specified needs adjustment to include available backups. To determine if that archivelog file is needed based on the 'until' specified, execute:
Looking at the first_time/next_time, determine if this sequence is indeed needed for the until specified by the recover (or duplicate) command. If it is, and backup_count=0, you need to take backup of the archivelog files. If you do not need to recover to the point this archivelog file covers, then adjust the 'until' with your command so RMAN does not look a backup of this sequence thus avoiding the error.
The simpliest adjustment to the 'until' would be to identify the last archivelog file in your backup:
a) in RMAN:
b) in SQL:
Once the highest sequence available in backup is identified, you could use:
For example, if highest sequence is 788, you would use:
This will cause RMAN to apply ALL of sequence 788 an stop at sequence 789 thus ensuring you have all the necessary archivelog files to complete the recovery.
References
NOTE:243760.1 – RMAN: RAC Backup, Restore and Recovery using RMAN