Home » RDBMS Server » Networking and Gateways » Question about tnsnames entry for standby location of logfiles
Question about tnsnames entry for standby location of logfiles [message #123149] Fri, 10 June 2005 03:19 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 01 15:19:14 CST 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.