Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2005
    Posts
    67

    Unanswered: log_archive_dest & flash_recovery_area

    Hi all,

    I set an Oracle 10gR2 in archivelog.
    pfile:
    *.db_recovery_file_dest='M:\oracle\flash_recovery_ area'
    log_archive_format='ARC%S_%R.%T'
    log_archive_dest=G:\oracle\archive\sath

    note that only the first line has an "*", not the others. But I think it doesn't matter.

    What I don't understand is why archivelogs are being moved to both destinations:
    - M:\oracle\flash_recovery_area\SATH\ARCHIVELOG\2009 _07_29
    - G:\oracle\archive\sath

    Any ideas?

    I need only one destionation (in fact there is only one destionation defined, not two.)

    Thanks in advance,
    Diego.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I need only one destionation (in fact there is only one destionation defined, not two.)
    So change the "wrong" destination to the desired value.
    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
    Sep 2005
    Posts
    67
    Quote Originally Posted by anacedent
    >I need only one destionation (in fact there is only one destionation defined, not two.)
    So change the "wrong" destination to the desired value.
    Sure, but as far as I know in flash_recovery_area are stored, among others, archive logs, online redo, etc.

    how do I tell Oracle that do not store archive in flash_recovery_area ?

    Thanks!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    *.db_recovery_file_dest='G:\oracle\archive\sath'
    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
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Use one of the log_archive_dest_n parameters and do not use the log_archive_dest parameter.

    For example

    log_archive_dest_1 = 'LOCATION=G:\oracle\archive\sath'

Posting Permissions

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