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