+ Reply to Thread
Results 1 to 4 of 4
  1. 01-29-2002 11:59 AM #1
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    370
    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.
    Reply With Quote Reply With Quote
  2. 01-29-2002 12:23 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    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."
    Reply With Quote Reply With Quote
  3. 01-29-2002 12:29 PM #3
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,131
    select * from V$ARCHIVE_DEST;

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  4. 01-29-2002 08:23 PM #4
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    370
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width