log_archive_dest

[mcomer]

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

[marist89]

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...