Home » RDBMS Server » Server Administration » specifying alternate archivelog destination
specifying alternate archivelog destination [message #271232] Sun, 30 September 2007 23:55 Go to next message
laksha
Messages: 42
Registered: June 2006
Member
Oracle 9.2.0.5
RedHat 9 enterprise linux.

Hi,

Is there a way to specify alternate archive log destination in Oracle 9i.
ie. If specified destination is full write to some other alternate location.

From what I have read using LOG_ARCHIVE_DEST and
LOG_ARCHIVE_DUPLEX_DEST you can specify two locations, but in this case archive logs are writen to both the locations simultaneously.


Re: specifying alternate archivelog destination [message #271240 is a reply to message #271232] Mon, 01 October 2007 00:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Modify initialization parameter.

[Updated on: Mon, 01 October 2007 00:22]

Report message to a moderator

Re: specifying alternate archivelog destination [message #271242 is a reply to message #271240] Mon, 01 October 2007 00:26 Go to previous messageGo to next message
laksha
Messages: 42
Registered: June 2006
Member
I believe "alter system set" is the way to specify the archivelog parameters without restarting the instance.

i want to specify two locations where archivelogs should not be written simultaneously to both location, but written to 2nd destination if the first destination is full.
Re: specifying alternate archivelog destination [message #271249 is a reply to message #271232] Mon, 01 October 2007 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have Entreprise Edition, use LOG_ARCHIVE_LOG_DESTn parameters instead.

Regards
Michel


Re: specifying alternate archivelog destination [message #271269 is a reply to message #271249] Mon, 01 October 2007 01:57 Go to previous messageGo to next message
laksha
Messages: 42
Registered: June 2006
Member
Quote:
If you want to archive only to a single destination, you specify that destination in the LOG_ARCHIVE_DEST initialization parameter. If you want to multiplex the archived logs, you can choose whether to archive to up to ten locations (using the LOG_ARCHIVE_DEST_n parameters)

Quote:

Whenever Oracle archives a redo log, it archives it to every destination specified by either set of parameters



I do not want to archives it to every destination specified.
but want to archive it to first destination, when first destination is full archive to second destination.

Is this possible anyways?
Re: specifying alternate archivelog destination [message #271276 is a reply to message #271269] Mon, 01 October 2007 02:14 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, re-read the documentation.

In addition, when you quote somtehing post from where you quote it.

Regards
Michel
Previous Topic: ORA-06521
Next Topic: How to Migrate Oracle 10g with Cluster service from NT to AD domain
Goto Forum:
  


Current Time: Mon Dec 05 06:42:53 CST 2016

Total time taken to generate the page: 0.22496 seconds