Re: Need help re: VB app copying redo log archives

I would look at v$archived_log to find out which files Oracle thinks has been archived. Something like:

SELECT name, completion_time
FROM v$archived_log
WHERE completion_time >= trunc(sysdate);

--
Posted via http://dbforums.com