Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    26

    Question Unanswered: Very urgent-Error messeges implementing Archiving

    --------------------------------------------------------------------------

    Hi,

    1- I already transfer database into archive log mode and automatic archival is also enabled
    but when I want to implement multiple destination for archiving it gives error.
    2- I want to give drive and folder location with SERVICE parameter is there any option to add alter system set log_archive_dest_2='SERVICE=db01'(in this command I want to add drive specification/letter)

    Below are some of the details.



    SQL> alter system set log_archive_dest_1='service=mnbsll';
    alter system set log_archive_dest_1='service=mnbsll'
    *
    ERROR at line 1:
    ORA-32017: failure in updating SPFILE
    ORA-00439: feature not enabled: Managed Standby


    SQL> alter system set log_archive_dest_1='local=d:\oracle';
    alter system set log_archive_dest_1='local=d:\oracle'
    *
    ERROR at line 1:
    ORA-32017: failure in updating SPFILE
    ORA-00439: feature not enabled: Managed Standby


    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination d:\oracle
    Oldest online log sequence 188
    Next log sequence to archive 190
    Current log sequence 190

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    What version of Oracle are you using? - It sounds like you have the Standard Edition, as Managed Standby Recovery requires the Enterprise Edition.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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