How to copy a datafile from ASM to a file system not using RMAN (Doc ID 428893.1)

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Apr-2013***

Goal

This>Note 390274.1        How>Note 390416.1        How to move a datafile from ASM to the file system

Solution

1. Log> 'SOURCE_DIR', source_file_name => 'system.272.617284341',
destination_directory_object => 'ORACLE_DEST',
destination_file_name => 'system.dbf');
END;
/

PL/SQL procedure successfully completed.

(In this example system.272.617284341 is the file I wish to transfer and the destination file is system.dbf)

The file has now been copied to the /restore directory.