Showing posts with label restore not done. Show all posts
Showing posts with label restore not done. Show all posts

Saturday, May 17, 2014

Archive log restore not done to non-default location



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

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 17-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=58 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=25 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=20 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=55 device type=DISK

archived log for thread 1 with sequence 1 is already on disk as file +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_1.301.847792345
restore not done; all files read only, offline, or already restored
Finished restore at 17-MAY-14


Solution
Restore archivelog force fully to non-default location
RMAN> run
2> {
3> set archivelog destination to '/SHARED/backup1/';
4> restore archivelog sequence 1 force;
5> }

executing command: SET ARCHIVELOG DESTINATION
using target database control file instead of recovery catalog

Starting restore at 18-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=51 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=61 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=54 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=48 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=30 device type=DISK

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=1
channel ORA_DISK_1: reading from backup piece +DATA/cvrman/backupset/2014_05_17/annnf0_full_archivelog_bkp_0.299.847792567
channel ORA_DISK_1: piece handle=+DATA/cvrman/backupset/2014_05_17/annnf0_full_archivelog_bkp_0.299.847792567 tag=FULL_ARCHIVELOG_BKP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 18-MAY-14