Archive in multiple destination [message #215871] |
Wed, 24 January 2007 02:29 |
Maheshprajap
Messages: 7 Registered: September 2005 Location: Nepal
|
Junior Member |
|
|
Oracle 9i database is to archive to multiple destinations. there is the error reporting "ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed" when log_archive_start= true . What may be the possible cause for this error.
|
|
|
|
|
Re: Archive in multiple destination [message #215879 is a reply to message #215876] |
Wed, 24 January 2007 02:39 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
i don't think it is because of "LOG_ARCHIVE_START" parameter.
becuase if you specify "LOG_ARCHIVE_START"="true". archive start automatic with INSTANCE startup.
if you turn to FALSE archiving not START with instance startup.
and your error is gone.
but root cluase is something else.
also post your init.ora file.
regards
Taj
[Updated on: Wed, 24 January 2007 02:40] Report message to a moderator
|
|
|
|
|
Re: Archive in multiple destination [message #216019 is a reply to message #215880] |
Wed, 24 January 2007 12:12 |
satheeshb
Messages: 5 Registered: July 2006
|
Junior Member |
|
|
Hi,
As per Note:96278.1,
Solution Description
--------------------
Check the following after ensuring that the location is a valid directory
and that Oracle has write permissions there.
1. Remove the spaces on either side of the '=' sign. You cannot have
as space on either side on the '=' sign. Note: The word location
can be in either upper or lower case.
log_archive_dest_1 = 'location=/u01/oracle/arc'
2. Make sure that there is no trailing /.
3. Make sure that LOG_ARCHIVE_DEST is not set in the init.ora. These 2
parameters are not compatible with each other.
4. If still not working set the LOG_ARCHIVE_DEST_n parameter to a null
value - LOG_ARCHIVE_DEST_n=''
Regards,
Satheesh Babu.S
Bangalore
|
|
|