Restore archivelogs to a different location

RMAN>run
>{
>set archivelog destination to '/stage';
>restore archivelog from logseq 100278 until logseq 100298;
>}








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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26664718/viewspace-2149820/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26664718/viewspace-2149820/