Home » RDBMS Server » Server Administration » Log_archive_dest_n
Log_archive_dest_n [message #169444] Wed, 26 April 2006 21:12 Go to next message
NSchott
Messages: 6
Registered: April 2006
Location: Sonoma County
Junior Member
In 10g can I have a second destination on a different server than the primary? I currently have the Standard Edition. If so what would be the script to do it. I've read the documentation regarding log_archive_dest_n, however it does not specify edition specific info.

Thanks

Nita

Report message to a moderator

Re: Log_archive_dest_n [message #169491 is a reply to message #169444] Thu, 27 April 2006 03:54 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Yes, you can have a different location and log_archive_dest_n is the right parameter to look into.

Report message to a moderator

Re: Log_archive_dest_n [message #169549 is a reply to message #169444] Thu, 27 April 2006 09:52 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
And here is the complete syntax to do this:

log_archive_dest_2 = 'service = db2'

In above, db2 is the net service name which you need to configure and it must point to an another database running on other box and on that box the RFS process will recieve and write the archive log to the archive destination of that box.

Daljit Singh

Report message to a moderator

Previous Topic: Howto create a duplicate user.
Next Topic: Find out current user and password
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:33:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.