using log_file_name_convert

[roukie_dba]

When using the log_file_name_convert parameter in creating a standby database, how can I configure my init.ora parameter file of the standby database on a different host to reference multiple redolog files on different mount points??

Thanks

[roukie_dba]

Can someone MODERATORS please help with this???
Thanks

[sambavan]

Are you getting any errors, or just would like to have some information on the configurations ?


Sam

[Shestakov]

When you create stanby DB you must place all files, including LOG in come directory structure ac primary DB.

if uoy place db files and log files in another dir structure you must set 2 parameters for convers full file names with path for DB and LOG on standby DB box:

db_file_name_convert
log_file_name_convert

for more information read classic books (Oracle Documentation library)

[Edited by Shestakov on 10-17-2001 at 03:27 PM]

[sambavan]

Also check this Standby DB doc: http://oradoc.photo.net/ora817/DOC/s...a76995/toc.htm


Sam

[roukie_dba]

SAM and others thanks!!!

My problem is this:

My primary database has two online logfile groups


/u01/oradata/prod/redo01a.log
/u01/oradata/prod/redo02a.log
/u02/oradata/prod/redo01b.log
/u02/oradata/prod/redo02b.log


In the standby init.ora file, Oracle only allows the use of LOG_FILE_NAME_CONVERT just once and as follows:

log_file_name_convert='/u01/oradata/prod', '/u01/oradata/standby'

Which converts the logs in /u01/oradata/prod in the primary to /u01/oradata/standby of the standby host

Now, my question is, how do I convert the logs in /u02/oradata/prod files???? When I put two LOG_FILE_NAME_CONVERT in the standby init.ora file, I get an error.

Please moderators help!

[sambavan]

Originally posted by roukie_dba

log_file_name_convert='/u01/oradata/prod', '/u01/oradata/standby'

Which converts the logs in /u01/oradata/prod in the primary to /u01/oradata/standby of the standby host

Did you try

log_file_name_convert= (('/u01/oradata/prod', '/u01/oradata/standby'),('/u02/oradata/prod', '/u02/oradata/standby'))


Sam

[roukie_dba]

Sam Thanks again, I have just tried your recommendation and now the instance start command gives the following error:

SQL> startup nomount pfile=initstandbydb.ora
ORA-01678: parameter log_file_name_convert must be two strings, a pattern and a replacement

Doesn't like syntax...I still don't know how to convert for multiplexed logs...any more suggestions???

[Shestakov]

You may use convert string like this one:

log_file_name_convert='/u0*/oradata/prod/redo*.log', '/u0*/oradata/standby/redo*.log'

and use some convert rules for DB files

db_file_name_convert='/u0*/oradata/prod/data_file*.ora', '/u0*/oradata/standby/datafile*.ora'

[roukie_dba]

Folks
The preceding suggestion still did not work, any more ideas???