-
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.
Reddy,Sam
-
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.
Reddy,Sam
-
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
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
|