ORA-00439: feature not enabled: Managed Standby [message #366375] |
Sat, 13 December 2008 02:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #366388 is a reply to message #366381] |
Sat, 13 December 2008 04:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #394580 is a reply to message #369637] |
Fri, 27 March 2009 19:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|