Home » Server Options » Data Guard » ORA-00439: feature not enabled: Managed Standby (Oracle 9i, Windows xp)
ORA-00439: feature not enabled: Managed Standby [message #366375] Sat, 13 December 2008 02:35 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi,
i am trying to create a physical standby. I am trying to set the log_archive_n parameters in the primary database, but i am getting the below error. can you help me out in this..

SQL> alter system set log_archive_dest_1='LOCATION=E:\oracle\ora92\database\archive MANDATORY' scope
=BOTH;
alter system set log_archive_dest_1='LOCATION=E:\oracle\ora92\database\archive MANDATORY' scope=BOTH
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00439: feature not enabled: Managed Standby
Re: ORA-00439: feature not enabled: Managed Standby [message #366381 is a reply to message #366375] Sat, 13 December 2008 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't use Standard Edition (SE), do you?

Regards
Michel
Re: ORA-00439: feature not enabled: Managed Standby [message #366388 is a reply to message #366381] Sat, 13 December 2008 04:43 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
SQL> select * from V$version;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production


Above is the output..i am supporting for my frenz db.. he is not sure of that... i found the above o/p.
i think its SE .. am i right.. ?

If this is the SE, then can we create standby database...?
Re: ORA-00439: feature not enabled: Managed Standby [message #369637 is a reply to message #366388] Sat, 13 December 2008 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes this is SE.
You can have standby database but you can't use dataguard and "log_archive_dest_%" parameters. You have to manually move the archived logs to the target site.

Regards
Michel
Re: ORA-00439: feature not enabled: Managed Standby [message #394580 is a reply to message #369637] Fri, 27 March 2009 19:54 Go to previous message
mlaunce
Messages: 3
Registered: March 2009
Junior Member
Take a look at Dbvisit (www.dbvisit.com). This is an alternative to Data Guard but works for Oracle Standard Edition, Standard One and XE. Works for all Oracle version 8i upwards.
Has all the features of Data Guard including Graceful Switchover, failover, multiple standby databases, reporting standby databases and supports Oracle RAC, but is much simpler to use. There is a free 30 day trial. New version 5.2 will even automatically create the standby database.
Previous Topic: Setting up a disaster server
Next Topic: problem in switchover
Goto Forum:
  


Current Time: Fri Mar 29 01:45:00 CDT 2024