OraFAQ Forum: Server Administration » Remote archival through Oracle Net service name

Home » RDBMS Server » Server Administration » Remote archival through Oracle Net service name (Oracle 11g R2, Windows)

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

Remote archival through Oracle Net service name [message #663344]

Tue, 30 May 2017 22:37

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

Member

I want to set an database archive log destination to a network location. How may I achieve this. Pl guide me.

Report message to a moderator

Re: Remote archival through Oracle Net service name [message #663345 is a reply to message #663344]

Tue, 30 May 2017 23:00

BlackSwan
Messages: 26766
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!

Report message to a moderator

Re: Remote archival through Oracle Net service name [message #663346 is a reply to message #663345]

Tue, 30 May 2017 23:16

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

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'

Report message to a moderator

Re: Remote archival through Oracle Net service name [message #663347 is a reply to message #663346]

Tue, 30 May 2017 23:39

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Using service= is attempting to write to a remote database, not to a remote file system.

Report message to a moderator

Re: Remote archival through Oracle Net service name [message #663349 is a reply to message #663344]

Tue, 30 May 2017 23:54

1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad

Member

Thanks.

Report message to a moderator

Re: Remote archival through Oracle Net service name [message #663350 is a reply to message #663349]

Wed, 31 May 2017 00:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 14:00:36 CST 2024