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

    Exclamation 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
    Last edited by skhawar03; 12-21-04 at 08:17. Reason: Very Urgent

Posting Permissions

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