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
Printable View
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
Can someone MODERATORS please help with this???
Thanks
Are you getting any errors, or just would like to have some information on the configurations ?
Sam
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]
Also check this Standby DB doc: http://oradoc.photo.net/ora817/DOC/s...a76995/toc.htm
Sam
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!
Did you tryQuote:
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
log_file_name_convert= (('/u01/oradata/prod', '/u01/oradata/standby'),('/u02/oradata/prod', '/u02/oradata/standby'))
Sam
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???
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'
Folks
The preceding suggestion still did not work, any more ideas???