convert log file parameter for clonning

[big]

Hi,
On R12.2.9 on AIX DB 19c
I want to clone Prod to DEV.
Production database has 6 log file but DEV has 3.

How should I set log_file_convert parameter in DEV initdev.ora file?

Thank you.

[ErmanArslansOracleBlog]

you mean log_file_name_convert..
Why don't you use it properly, convert all of them during your duplicate operation, and then drop those extra redolog files once they are created on the newly cloned instance?

[big]

Yes log_file_name_convert.
Appolgize.
But to bring all first I have to set log_file_name_convert.
How?
Thanks  and regards.

[ErmanArslansOracleBlog]

That information is already publicly available big.

Also check the MOS note: "Usage and Limitation of db_file_name_convert and log_file_name_convert (Doc ID 1367014.1)"

[big]

ok. Thank you.

By the way, I think if I do as follow:

LOG_FILE_NAME_CONVERT=('/u01/prod','/u01/dev',''/u02/prod','/u02/dev',''/u03/prod','/u03/dev',''/u04/prod','/u04/dev',''/u05/prod','/u05/dev',''/u06/prod','/u06/dev'

And all FS available on target

I will have automatically the log files in new places on DEV not having to move or remove any of them.

Best regards.

[ErmanArslansOracleBlog]

See the definition and ensure what you re doing;

LOG_FILE_NAME_CONVERT = 'string1' , 'string2' , 'string3' , 'string4' , ...

Where:

string1 is the pattern of the primary database filename

string2 is the pattern of the standby/clone database filename

string3 is the pattern of the primary database filename

string4 is the pattern of the standby/clone database filename