Can you list the errors you get when attempting to use "set until time" ?
Thanks for the replies. The problem the "set until time" with Oracle 8.1.7 and Solaris is that it does not appear to work, well at least it doesn't on the set-up we have here! So that's why I wanted to use an scn, v$archived_log looks like the place to find it. Also using "set until logseq" is another option, I am trying that to see if it will work, since getting the sequence number for a archive log is easy.
Pete -----Original Message-----