Thursday, May 22, 2014

Restore archivelog to non-default location

Script to restore the archivelog to non-default location
run
 {
 set archivelog destination to '/SHARED/backup1';
  restore archivelog sequence 4 force;
 }
Output:-

RMAN> run
2> {
3> set archivelog destination to '/SHARED/backup1';
4>  restore archivelog sequence 4 force;
5> }

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 23-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5

channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/SHARED/backup1
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4
channel ORA_DISK_1: reading from backup piece +DATA/cvrman/backupset/2014_05_22/annnf0_new_arch_bkp_0.330.848234723
channel ORA_DISK_1: piece handle=+DATA/cvrman/backupset/2014_05_22/annnf0_new_arch_bkp_0.330.848234723 tag=NEW_ARCH_BKP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 23-MAY-14

No comments: