LOG_FILE_NAME_CONVERT

Hi All,


My Primary database has three redo logfiles with 2 members in each located at different drives, while setting up LOG_FILE_NAME_CONVERT parametre for standby database
init.ora which path I have to specify...Path of first member of logfile to convert or second member of log file
or can I specify path of any member ? because both member are at differnt drives..

Thanks

Sameer

http://otn.oracle.com/docs/products/...ch192.htm#5595

Just mention the primary path and stby path as string1 and string2.

yes, but what do I have to specify if in primary database one log member is on one slice and other member is on another slice...

F.ex

group# member
------------------------------------------------------
1 /data/oradata/ora4/redo01.log
1 /opt/oracle/data2/ora4/logfile/redo01m.log

2 /data/oradata/ora4/redo02.log
2 /opt/oracle/data2/ora4/logfile/redo02m.log

3 /data/oradata/ora4/redo03.log
3 /opt/oracle/data2/ora4/logfile/redo03m.log

Is it okay if I specify path of one of the member in init.ora of standby database...

log_file_name_convert = ("/data/oradata/ora4","/data/oradata/ora5")

what about members in "/opt/oracle/data2/ora4/".. How my standby database will know that other members path is also changed...

Thanks

Sameer

Does it matter if I specify path of one of the member????

what about second members path in standby database???

Please answer

Thanks

Sameer

If you set up ypur database on OFA (Optimal Flexible Architecture) you can take advantage of this parmeter otherwise, Not.

in init of stand by you can specify only one log path convert
others you need to convert using
alter database rename datafile 1 to 2

Thanks a lot for the replies...

I ALTERed rest of members

Thanks

Sameer