If one needs to restore archive logs to disk and not apply them, for example in case when cloning a database manually and one is missing the archive logs from the source database and you need to restore the archive logs on the source machine. So using the following command one can restore the archive logs.

connect target /
connect rcvcat rmancatalog/rmancatalog@catdb

run {
restore archivelog from logseq=36747 until logseq=36753 thread=1;
}
from logseq – is the starting log sequence #
until logseq – is the end log sequence #

3 responses to “How to restore archive logs from backup piece?”

  1. Ahmed Avatar
    Ahmed

    Thanks a lot, it really helps.
    using also from restore archivelog from time ‘xxxxx’ until time ‘yyyy’ helps

    Like

  2. […] 10. How to restore archive logs from backup piece? – An Oracle … […]

    Like

  3. […] 2. How to restore archive logs from backup piece? – An Oracle … […]

    Like

Leave a reply to Archivelog From Rman Backup – Restore Archive Logs From Backup | Rman Backup | Ocp … Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.