OraFAQ Forum: Data Guard » Defining the LOG_ARCHIVE_DEST

Home » Server Options » Data Guard » Defining the LOG_ARCHIVE_DEST_n Parameter

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

Defining the LOG_ARCHIVE_DEST_n Parameter [message #133178]

Wed, 17 August 2005 23:52

rebeccaz
Messages: 18
Registered: August 2005

Junior Member

Hi,

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.

Regards,
Rebecca Razz

Report message to a moderator

Re: Defining the LOG_ARCHIVE_DEST_n Parameter [message #133520 is a reply to message #133178]

Fri, 19 August 2005 07:47

Frank Naude
Messages: 4596
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.

Frank

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 22 10:01:27 CDT 2025