Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: Standby Database (QUICK QUESTION!!!)

    Hi folks,

    May I set more than one path to the standby_archive_dest parameter in my Standby Database?
    My current value is: /backup/SPCAP/arch/
    I want to change it to: 'arch1/SPCAP,arch2/SPCAP,arch3/SPCAP'
    Reason: I have 3 primary instances in a RAC.
    Their archives are always stored in first destination ('arch1/SPCAP','arch2/SPCAP' OR 'arch3/SPCAP') depending on the instance (1,2or3).
    The archiving never fails in first destination.
    The archiving sometimes fail to send the archives to the second destination (/backup/SPCAP/arch) wich is general and must have all the archives generated by the 3 instances... This is the destination wich my standby database uses to copy the production archives....
    So, does someone know how I can set 3 paths to standby_archive_dest? So I would solve the problems I'm having to recover standby database...

    Thank you in advance.....

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Did you try setting LOG_ARCHIVE_DEST_3='LOCATION=..etc..arch3/SPCAP'?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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