HOW TO GENERATE ARCHIVE LOG FROM ASM TO LOCAL DISK
SQL> CREATE or replace DIRECTORY archdir AS '+ARCH/mscdxb/arch/';SQL> Directory created.SQL> CREATE or replace DIRECTORY tempdir AS '/u01/starch/';Directory created.
spool archmove.sql
set linesize 250 set pagesize 250 select 'EXECUTE DBMS_FILE_TRANSFER.COPY_FILE(''ARCHDIR'','''|| SUBSTR(NAME,INSTR(NAME,'/',-1) + 1) ||''',''TEMPDIR'','''|| SUBSTR(NAME,INSTR(NAME,'/',-1) + 1)||''');' FROM V$ARCHIVED_LOG where name is not null; spool off; exit;