-
How to create this standby database configuration, 9.2.0.3.0
Hi,
I`m having problem with understanding of this concept:
I want to move archived logs automatically to standby database using 'SERVICE' entry for log_archive_dest parameter.
So, I will have something like this on the primary database side:
log_archive_dest_1='LOCATION=/archive_logs/oradata/PRIME MANDATORY'
log_archive_dest_state_1=ENABLE
LOG_ARCHIVE_DEST_2='SERVICE=stby1 optional'
LOG_ARCHIVE_DEST_STATE_2=ENABLE
What exactly should be specified on the standby database side to make it work? Where do I need to specify FAL_CLIENT and FAL_SERVER parameters?
Do I have to define stby1 net8 name on both primary ad standby systems? What should be used for log_archive_dest_1 parameter on standby side?
I`m reading Oracle Data Guard Concepts and Administration docs right now but it has no clear example of such configuration, unfortunately, and I want to clear it out for me.
Can anybody post here an example of both primary and standby side parameter files for such configuration to show all this at once?
The second question that I have is: we have a bunch of iplanet applications that use JDBC driver to access oracle.
Is it posible to do something on server side that will automatically transfer connection to new primary database after failover? Right now we have to change an IP address of host used in JDBC connection string to make it happen.
Thanks.
-
And one more question -
how exactly FAL_SERVER and FAL_CLIENT work? Wil
Do I understand it correctly that if I specified
LOG_ARCHIVE_DEST_3='SERVICE=netserv OPTIONAL'
and network went down and standby didn`t get some logs then FAL system would be able resolve the gap after the moment when network problem has been fixed?
-
So what? No answers whatsoever?
My goodness... :(
-
For stand by database You can go thru documentation in
Data Guard Concepts and Administration.
have a nice time.
Dilip Patel
OCP 8i
Catch me online at Yahoo: ddpatel256
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
|