Home » RDBMS Server » Server Administration » Remote archival through Oracle Net service name (Oracle 11g R2, Windows)
Remote archival through Oracle Net service name [message #663344] Tue, 30 May 2017 22:37 Go to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
Member
I want to set an database archive log destination to a network location. How may I achieve this. Pl guide me.
Re: Remote archival through Oracle Net service name [message #663345 is a reply to message #663344] Tue, 30 May 2017 23:00 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
1982Hashmi wrote on Tue, 30 May 2017 20:37
I want to set an database archive log destination to a network location. How may I achieve this. Pl guide me.
The Oracle database can only write to a file system that "local" to the database server. Period. End of statement!
Re: Remote archival through Oracle Net service name [message #663346 is a reply to message #663345] Tue, 30 May 2017 23:16 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
Member
Pl read this link. It says:

Quote:
If you are archiving to a standby database, use the SERVICE keyword to specify a valid net service name from the tnsnames.ora file. For example, enter:
LOG_ARCHIVE_DEST_4 = 'SERVICE = standby1'
Re: Remote archival through Oracle Net service name [message #663347 is a reply to message #663346] Tue, 30 May 2017 23:39 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
Using service= is attempting to write to a remote database, not to a remote file system.
Re: Remote archival through Oracle Net service name [message #663349 is a reply to message #663344] Tue, 30 May 2017 23:54 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Karachi
Member
Thanks.
Re: Remote archival through Oracle Net service name [message #663350 is a reply to message #663349] Wed, 31 May 2017 00:36 Go to previous message
Michel Cadot
Messages: 65199
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can mount a remote directory on the database server but, of course, you have to be aware of the performances impacts doing so.

Previous Topic: What is the difference between remote_os_roles vs os_roles
Next Topic: Finding Error message list
Goto Forum:
  


Current Time: Mon Nov 20 18:50:33 CST 2017

Total time taken to generate the page: 0.01940 seconds