RMAN Restore Archivelog

Jan 24, 2019 11:09AM

Hello,

I need restore archivelog from rman tape backup and catalog.

I have two databases in RAC, primary active database and physical standby database (Dataguard).

I did DUPLICATE RMAN for standby database but i need restore archivelog. Active database is up (ACT), standby database is down (STB).

"From host STB"

connect target sys/xxx@ACT

connect catalog rman/rman@catalog

run {

set archivelog destination to '/home/oracle/rman/restore';

restore archivelog from logseq=111643 until logseq=111644 thread=2;

}

Result:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 01/24/2019 10:25:03

RMAN-06026: some targets not found - aborting restore

RMAN-06102: no channel to restore a backup or copy of archived log for thread 2 with sequence 111644 and starting SCN of 3992176794865

Database Backup and Recovery (MOSC)