log_archive_dest
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: log_archive_dest

  1. #1
    Join Date
    Oct 2001
    Posts
    4
    Working on a UNIX hot backup script for an 8.1.6 DB and I am looking for information about the best way to dynamically retrieve the log_archive_dest - v$parameter or v$archive_dest. Also, looking for info about the switch to log_archive_dest_n from log_archive_dest.

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm, depends on what you are looking for. I would probably get the info from v$archive_dest because there would be less parsing involved. If you are running with standby db, this might get tricky, though, unless there is some sort of flag in v$archive_dest that signifies if the dest is a filesystem or service name...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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