OraFAQ Forum: Networking and Gateways » Question about tnsnames entry for standby location of logfiles

Home » RDBMS Server » Networking and Gateways » Question about tnsnames entry for standby location of logfiles

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question about tnsnames entry for standby location of logfiles [message #123149]

Fri, 10 June 2005 03:19

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi all,

I am testing to store the archive_logfiles with log_archive_dest_2='SERVICE=stdby'.
To get this I need to set up a tnsnames entry for this Standy-Database.
Could someone guide me to get this entry clear.

Tia

Uwe

Report message to a moderator

Re: Question about tnsnames entry for standby location of logfiles [message #123161 is a reply to message #123149]

Fri, 10 June 2005 04:27

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

the tnsnames entry will tremain same as is for a normal production database.

Report message to a moderator

Re: Question about tnsnames entry for standby location of logfiles [message #123164 is a reply to message #123149]

Fri, 10 June 2005 04:48

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

But it has to be an external name or should the SID be the same as the prod ?

Report message to a moderator

Re: Question about tnsnames entry for standby location of logfiles [message #123229 is a reply to message #123164]

Fri, 10 June 2005 11:06

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

That depends on your choice.
You can have the SID same as production database, that shdn't be creating any issues... Actually a shot in dark....

Report message to a moderator

Previous Topic:	INSTALLING ORACLE 8i Client
Next Topic:	SQL over 2 domains

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 17 22:16:21 CDT 2025