| specifying alternate archivelog destination [message #271232] |
Sun, 30 September 2007 23:55  |
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 #271242 is a reply to message #271240] |
Mon, 01 October 2007 00:26  |
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 #271269 is a reply to message #271249] |
Mon, 01 October 2007 01:57 |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
