Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    27

    Unanswered: remove one location of archivelog

    Hi all,

    at my oracle , I has 3 archivelog location but now I need to just only 2 location.
    So what I need to remove one location for archivelog file?

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >So what I need to remove one location for archivelog file?
    Do you realize that the syntax has changed over various versions of Oracle?
    We do not know Operating System name or version or Oracle version to 4 decimal places.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2008
    Posts
    5
    try setting init parameter "log_archive_dest_state_n" to "defer"

    or

    remove the log_archive_dest_n from init.ora and update the spfile

Posting Permissions

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