Restore Archivelog from ASM to filesystem

Rman> Run

2> {

3> set Archivelog destination to '/tmp ';

4> restore Archivelog sequence 142 thread 2;

5>}

Executing command:set ARCHIVELOG DESTINATION

Starting restore at 2015-03-12 00:22:25

Using channel Ora_disk_1

Archived log for thread 2 with sequence 142 are already on disk as file +fra/rac/archivelog/2015_03_11/thread_2_seq_142.717 .874033939

Restore does not do; All files read only, offline, or already restored

Finished restore at 2015-03-12 00:22:25

Note that this is because the original archive log still exists, causing Restore Archivelog to the / tmp the failure.

if log_archive_dest_1 or log_archive_dest is not set, the archive log is placed by default in the Flashback area. Restore is not available if the archive log for restore exists in the flashback area .

after manual removal, Re Store to the / tmp the

rman> Delete Archivelog sequence 142 thread 2;

Rman> Run

2> {

3> set Archivelog destination to '/tmp ';

4> restore Archivelog sequence 142 thread 2;

5>}

[Email protected] ~]$ ll-ltar/tmp

Total 48904

drwx------2 root root 4096 Sep 15:54 Keyring-piyxka

。。。

-RW-R-----1 Oracle asmadmin 49039872 Mar 00:24 2_142_870389881.dbf

This article is from "Master Wang" blog, please be sure to keep this source http://johnnywong.blog.51cto.com/1997751/1619409

Restore Archivelog from ASM to filesystem