Locate Archive log destination
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Locate Archive log destination

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Hi all,
    What the syntax or script to locate the your archive log destination(full path) if you don't want to check it in the init.ora file?
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You can either get the information from svrmgrl by issuing the command "archive log list" or you can check v$parameter for 'log_archive_des%'.
    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."

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    select * from V$ARCHIVE_DEST;

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks for all the help.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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