Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2007
    Posts
    8

    Unanswered: Oracle 9i - Win2k - Archive Folder Destination Issue

    Hi, I am using Oracle 9i on Win2k. I am just starting archiving. I have changed my init.ora file to set the path for the archive files to be in one specific spot. Unfortunately, the path won't change. My archive folders are going to the default Oracle location. I have saved my init.ora file, shutdown and restarted the db, but the archive destination folder remains the same. Any help you can provide on this is much appreciated.

    In init.ora I have set it as follows:

    LOG_ARCHIVE_DEST = F:\ARCHIVE

    When I select destination from v$archive_dest it shows:

    F:\oracle\ora81\RDBMS

    It is writing the files to the F:\oracle\ora81\RDBMS path.

    Please help. Thanks much!

  2. #2
    Join Date
    May 2006
    Posts
    132
    You do not have restart to change the archive log destination (however, since you mentioned "init.ora" file, then you should make the change in the file to ensure that it maintains this location on restart. You may also want to consider using an SPFILE instead).

    You can simply issue:

    ALTER SYSTEM SET LOG_ARCHIVE_DEST = <destination>;

    What is the output of:

    sho parameter archive_dest
    Quote Originally Posted by geo0071
    When I select destination from v$archive_dest it shows:

    F:\oracle\ora81\RDBMS
    Just curious why you have an 8i home path listed for your 9i database?

  3. #3
    Join Date
    Mar 2007
    Posts
    8
    Hi, Thanks for your response.

    When I followed your direction and used "ALTER SYSTEM SET LOG_ARCHIVE_DEST = 'F:\_arch';" it worked fine. I then forced it to archive and everything worked great. Unfortunately, I don't want to have to do it this way each time. For some reason when I stop and start the database it is not reading it from my init.ora file. I am sure I am updating the correct file. The line I have entered in init.ora is:
    LOG_ARCHIVE_DEST = "F:\_ARCH"
    LOG_ARCHIVE_START = TRUE

    It does start logging properly, but it puts the file in the wrong spot.

    You asked me for the results of "sho parameter archive_dest".

    Before I set the location manually it showed:
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest string

    After I updated it manually it showed the correct path.

    Do you have any idea why it is not picking up the correct path from my init.ora file?

    Thanks very much for your assistance.

    George

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Do you have any idea why it is not picking up the correct path from my init.ora file?
    Might Oracle be using SPFILE & not the pfile?
    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.

  5. #5
    Join Date
    Feb 2007
    Posts
    71
    anacedent: sir, I also think that geo0071 started his/her oracle instance using the default SPFILE. Can he issue a CREATE SPFILE FROM PFILE='<path to customized pfile' before performing a restart? So that the next time the instance is restarted it reads from the generated SPFILE? thanks

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Can he issue a CREATE SPFILE FROM PFILE='<path to customized pfile' before performing a restart?
    If in fact the DB was started from SPFILE, I believe Oracle will refuse to overwrite this file; even if PFILE exists.
    When the DB has been started using SPFILE, I have noticed the timestamp gets periodically updated; which implies that Oracle is actively writing to this file.
    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.

Posting Permissions

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