Unable to change the log archive location
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Unable to change the log archive location

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    Unable to change the log archive location

    Hi all,

    can someone please tell me why the location of the archive log is not changing after I already pointed to the new location?

    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 536
    Next log sequence to archive 538
    Current log sequence 538
    SQL> alter system archive log start to '/oracle/archlogs/TEST/archTEST';

    System altered.

    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 536
    Next log sequence to archive 538
    Current log sequence 538



    Thanks all,

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Cool set

    Try:
    Code:
    Alter System Set Log_Archive_Dest_1='LOCATION=/oracle/..etc..' scope=both;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Mar 2006
    Posts
    176
    Alter System Set Log_Archive_Dest_1='/oracle/archlogs/TEST' scope=both
    *
    ERROR at line 1:
    ORA-32017: failure in updating SPFILE
    ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    Re-read LKBrwn_DBA's syntax closely.

  5. #5
    Join Date
    Mar 2006
    Posts
    176
    thx

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