ORA-00439: feature not enabled:
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ORA-00439: feature not enabled:

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    You can only archive logs to a remote database when applying them to a standby database - not in normal operation

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  4. #4
    Join Date
    Mar 2001
    Posts
    144
    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]

  5. #5
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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 sameer_deshpande@hotmail.com

    Thanks

    Sameer


  6. #6
    Join Date
    Dec 2001
    Posts
    320
    hi Sameer,
    you need to set the log_archive_dest parameter, not the log_archive_dest_1.

    Cheers.

  7. #7
    Join Date
    Mar 2001
    Posts
    144
    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

  8. #8
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  9. #9
    Join Date
    Mar 2001
    Posts
    144
    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'

  10. #10
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    :-) 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width