To Change Archive Destination
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: To Change Archive Destination

  1. #1
    Join Date
    Nov 2008
    Posts
    30

    To Change Archive Destination

    Hi
    I'm using Oracle 10g.When i issued the command Archive log list to determine the Archived destination but the output is
    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 90
    Next log sequence to archive 92
    Current log sequence 92
    I changed the Destination but it still remains the same.How can i change now??
    LittleAngel
    DBA-SQL,Oracle

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    which parameter you changed to reflect the new archive log destination?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Nov 2008
    Posts
    30
    I used "Alter system set log_archive_dest='path' scope=spfile" for changing the destination.
    LittleAngel
    DBA-SQL,Oracle

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    log_archive_dest parameter is deprecated in favor of log_archive_dest_n. However, if you don't specify any value to log_archive_dest_n parameter then it is valid.

    In this case, you need to set the new path to log_archive_dest_1 parameter using alter system.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Nov 2008
    Posts
    30
    Thanks,Finally it worked by using "Log_archive_dest_1='location=path'" Parameter.
    LittleAngel
    DBA-SQL,Oracle

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