ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
set until time "to_date('24-Jun-11 10:22:00','DD-MON-YY HH24:MI:SS')";
DUPLICATE TARGET DATABASE TO "test"
You either use the db_file_name_convert and log_file_name_convert in the pfile, or you can use set filename/tempfile for n to '/oracle/oradata/sidname...'; and before you open the database you need to rename the online logs with an alter database rename file 'from file' tofile';
I dynamically generate the clone script during the backup process, which makes it easier to do the cloning on any database whether I am cloning from and to a database on the same server or cloning from one server to another, even if the two servers can't talk to each other.