-
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
roukie-dba
-
Are you getting any errors, or just would like to have some information on the configurations ?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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]
-
Thanx
Sam
Life is a journey, not a destination!
-
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!
roukie-dba
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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???
roukie-dba
-
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???
roukie-dba
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|