Home » Server Options » Data Guard » Defining the LOG_ARCHIVE_DEST_n Parameter
Defining the LOG_ARCHIVE_DEST_n Parameter [message #133178] Wed, 17 August 2005 23:52 Go to next message
Messages: 18
Registered: August 2005
Junior Member

I already have a default location for the archive log files and now when I tried to define a location for the log_archive_dest_2 at the initialization parameters with the following:
'LOCATION = /home_oracle/product/9.2.0/dbs/arch1',
it throwed the error message, "Applying configured parameter(s) failed. ORA-02065: illegal option for ALTER SYSTEM"

Can someone kindly advise. Thank you.

Rebecca Razz
Re: Defining the LOG_ARCHIVE_DEST_n Parameter [message #133520 is a reply to message #133178] Fri, 19 August 2005 07:47 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Remove the spaces and try again:

SQL> ALTER SYSTEM SET log_archive_dest_2 = 'LOCATION = /tmp';
ALTER SYSTEM SET log_archive_dest_2 = 'LOCATION = /tmp'
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_2" not allowed with SPFILE

SQL> ALTER SYSTEM SET log_archive_dest_2 = 'LOCATION=/tmp';

System altered.

Best regards.

Previous Topic: data guard?log shipping?redo shipping?
Next Topic: whether any configuration reqd for urgentoracle with routing to the second nic of the primary server
Goto Forum:

Current Time: Tue Dec 07 08:28:40 CST 2021