Thanks I am going to try this on Monday, I appreciate your response!
Printable View
Thanks I am going to try this on Monday, I appreciate your response!
Hi DanceRat,
I am in same boat .Is log_file_name_convert allowed in run block.
I have 3 log group on target(source).Each has 2 members.
target ->aux
u01/oradata/prod/redo01.log ->/ora1/oradata/aux//redo01.log
/u02/oradata/prod/redo01b.log->/ora2/oradata/aux//redo0b.log
/u01/oradata/prod/redo02.log->/ora1/oradata/aux//redo02.log
/u02/oradata/prod/redo02b.log-/ora2/oradata/aux//redo02b.log
/u01/oradata/prod/redo03.log->/ora1/oradata/aux//redo03.log
/u02/oradata/prod/redo03b.log->/ora2/oradata/aux//redo03b.log
run {
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"
PFILE=/opt/oracle/product/10.2/db_1/dbs/inittest.ora
DB_FILE_NAME_CONVERT='/u01/oradata/prod/', '/ora1/oradata/test/'
log_file_name_convert='/u01/oradata/prod/','/ora1/oradata/test/','/u02/oradata/prod/','/ora2/oradata/test/'
release channel aux_01;
release channel aux_02;
}