Home » RDBMS Server » Server Administration » ARCHIVELOG -- cannot turn on
ARCHIVELOG -- cannot turn on [message #59313] Tue, 11 November 2003 09:34 Go to next message
Mark K
Messages: 18
Registered: October 2003
Junior Member
I set these values in the init.ora:

log_archive_start=TRUE
log_archive_dest_1=$ORACLE_BASE/admin/crista/arch
log_archive_dest_state_1=ENABLE

Then shutdown the database
startup mount <SID>
or
startup

I get this error:
ORA-00439: feature not enabled: Managed Standby

This occurs whether I turn ARCHIVELOG on before or after changing the init.ora.

What step am I missing?

Thanks.

-- Mark K.
Narrowed down to LOG_ARCHIVE_DEST_1 [message #59314 is a reply to message #59313] Tue, 11 November 2003 09:48 Go to previous messageGo to next message
Mark K
Messages: 18
Registered: October 2003
Junior Member
It is this parameter that is causing the error:

log_archive_dest_1

I'm going to go investigate further.

-- Mark K.
I think I resolved it -- looking for confirmation [message #59315 is a reply to message #59314] Tue, 11 November 2003 10:20 Go to previous messageGo to next message
Mark K
Messages: 18
Registered: October 2003
Junior Member
If I omit the _1, the init file works.

It's at this point I remembered that at this particular customer site, they are using Standard Edition Oracle (as opposed to Enterprise Edition), and without looking into it, I figure that multiple archive destinations are probably unsupported in Standard Edition.

-- Mark K.
Re: I think I resolved it -- looking for confirmation [message #59316 is a reply to message #59315] Tue, 11 November 2003 11:27 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Right, Log_Archive_Dest_n is valid only in Enterprise edition.

-Thiru
Re: I think I resolved it -- looking for confirmation [message #60972 is a reply to message #59315] Wed, 17 March 2004 11:22 Go to previous message
www.sidibe.net
Messages: 9
Registered: March 2004
Junior Member
You have to use this form :
log_archive_dest_1='LOCATION=my_archive_dir'

best use
Previous Topic: oracle 8 and 9 on the one server
Next Topic: synronize support db
Goto Forum:
  


Current Time: Fri Sep 20 12:47:16 CDT 2024