ORA-00439: feature not enabled:

Hi All,

I ma using 8.1.6 on Sun 5.8.

I am just tring to set log parameters..

log_archive_start = true
log_archive_dest_1 = "location=/opt/oracle/data2/ora4/arch"
log_archive_format = arch_%t_%s.arc

But when I start instance I get

ORA-00439: feature not enabled: Managed Standby

When I comment log_archive_dest_1 I can able to start the instance

Then where my logs will get arched?

Why I am geeting error while setting log_archive_dest_1

Please help

Thanks

Sameer

You can only archive logs to a remote database when applying them to a standby database - not in normal operation

Quote:

---

Originally posted by fraze
You can only archive logs to a remote database when applying them to a standby database - not in normal operation

---

I am not setting stand by database at the moment..

Just trying to set location for my arch logs

Take a look at this exchange on metalink. This may indicate something for you:

http://metalink.oracle.com/metalink/...1&p_showHelp=1

Check to make sure that you have Oracle Enterprise installed as the log_archive_dest_n parameter is only available with the enterprise. In Standard you can only set it as log_archive_dest.

This may be part of what is happening with the issues you have mentioned in your other thread.

[Edited by ramaral on 08-07-2002 at 09:46 AM]

Hi ramaral,

If the document is nto big then will you please copy paste here because I don't have access to Metalink

or Is it possible for you to send it to me at [email protected]

Thanks

Sameer

hi Sameer,
you need to set the log_archive_dest parameter, not the log_archive_dest_1.

Cheers.

Okay. Here it is. Note: it's not really an article but an exchange with someone who was having the exact same problem that your are encountering right now:

Thread Status: Closed

From: JD Smith 25-Jan-02 14:08
Subject: Getting Managed Standby error when creating database

RDBMS Version: 8.1.7
Operating System and Version: Sun Solaris 5.8
Error Number (if applicable): 01034 and 00439
Product (i.e. SQL*Loader, Import, etc.): Database Configuration Assistant and svrmgrl
Product Version:

Getting Managed Standby error when creating database

Installed Standard Edition, now trying to create a database instance that is using the Archive Redo Logs feature, so hot backups can happen. Getting error ORA-00439 in svrmgrl when starting the database with a init.ora file that has log archive turned on:

log_archive_start = true
log_archive_dest_1 = "location=/u01/app/oracle/admin/CTVW/arch"
log_archive_format = arch_%t_%s.arc

When creating from within Database Configuration Assistant I get the generic error ORA-01034 that says Oracle is not available.

Does Standard Edition support archiving redo log files? Is there a patch to fix this, or a syntax change required in the init.ora file?



From: Oracle, Kalpana Malligere 25-Jan-02 17:09
Subject: Re : Getting Managed Standby error when creating database

Hello,

You should use LOG_ARCHIVE_DEST instead of LOG_ARCHIVE_DEST_n, which is valid only if you have installed Oracle Enterprise Edition.

136921.1 ORA-439 Creating Database with DBASSISTANT
1078962.6 ORA-00439: STARTING PRIMARY OR STANDBY DATABASE
101543.1 ORA-00439 when Creating a Standby Database
68537.1 Init.ora Parameter "LOG_ARCHIVE_DEST_n" Reference Note
66433.1 Oracle8i - Multiple Archive Destinations and Remote Archival

FYI: If you are using 8.1.x Standard Edition, then you are limited to maintaining the standby database in manual Recovery Mode.

112591.1 Differences Between Standard Edition and Enterprise Edition in 8i

Thanks!
Kalpana
Oracle Technical Support

From: JD Smith 25-Jan-02 17:28
Subject: Re : Re : Getting Managed Standby error when creating database

I did as you suggested, but now get these errors:

SVRMGR> startup nomount pfile = "/u01/app/oracle/admin/CTVW/pfile/initCTVW.ora"

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
SVR4 Error: 2: No such file or directory

I verified that the directory indeed does exist:

/u01/app/oracle/product/8.1.7/assistants/dbca>cd /u01/app/oracle/admin/CTVW/arch
/u01/app/oracle/admin/CTVW/arch>
/u01/app/oracle/admin/CTVW/arch>
/u01/app/oracle/admin/CTVW/arch>ls
total 4
drwxr-xr-x 2 oracle oinstall 512 Jan 22 16:06 .
drwxr-xr-x 10 oracle oinstall 512 Jan 22 16:06 ..
/u01/app/oracle/admin/CTVW/arch>



From: Oracle, Kalpana Malligere 28-Jan-02 21:01
Subject: Re : Re : Re : Getting Managed Standby error when creating database

Hello,

Looks like in your init.ora file, log_archive_start parameter is set to "false" or remarked out, so archive logging is NOT enabled. Suggest to set to true or enable and set log_archive_dest to the directory you wish to write to. If there are any extraneous characters included in this setting (such as single quotes) remove them and let us know if you need assistance.

Thanks!
Kalpana
Oracle Technical Support

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device

Thanks ramaral for the post... But still fighting :-(

Now I am using log_archive_dest and I get the above error. As said in the docs I have to set log_archive_start = true
which is set to TRUE and also directory exists which appropriate rights

Sameer

Just something to try at this point. use single quotes so that the parameter reads something like:

log_archive_dest='location=/u01/app/oracle/admin/CTVW/arch'

:-) It worked

log_archive_dest = "location=/u01/app/oracle/admin/CTVW/arch"

There is no need to specify location word while specified value in dest. It worked and also archs logs to specified directory.. It gives error if you mention "location" word

Thanks

Sameer