Restore archivelogs to a different location

In some scenarios we may need to restore the archivelogs to a different location from its primary location using RMAN from its backups.

Below are the methods to do it.

1.  The below scripts restores the archive logs to a temporary location which is given in the run script.

RMAN> run

2> {

3> set archivelog destination to 'D:\backup';

4> restore archivelog from logseq=250 until logseq=264;

5> }

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 30-JAN-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log restore to user-specified destination

archive log destination=D:\backup

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=250

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=251

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=252

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=253

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=254

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=255

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=256

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=257

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=258

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=259

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=260

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=261

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=262

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=263

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=264

channel ORA_DISK_1: reading from backup piece D:\BACKUP\ARCH_BKP\BKP_ARCH_12N22PES_1_1

channel ORA_DISK_1: restored backup piece 1

piece handle=D:\BACKUP\ARCH_BKP\BKP_ARCH_12N22PES_1_1 tag=TAG20120130T153139

channel ORA_DISK_1: restore complete, elapsed time: 00:00:56

Finished restore at 30-JAN-12

2. Copy the archives to a different location and restore it to the same default location 

RMAN> copy archivelog 'D:\orcl10g_arch\ARC00250_0747232149.001' to 'D:\backup\arch_bkp';

Regards,

Navaneeth