LOG_FILE_NAME_CONVERT

[Sameer]

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

[sreddy]

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

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

[Sameer]

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

[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

[sreddy]

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

[Kumud]

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

[Sameer]

Thanks a lot for the replies...

I ALTERed rest of members

Thanks

Sameer