Need help VB app copying redo log archives

[Joe Tseng]

I've been asked to write a VB6 app to have any redo archive files
copied to an alternative location where they'll be saved to tape. I
was told this app should be smart enough to leave any open archive
file that is being appended to by the database alone until the next
time the app is run.

Is there any programmatic way to determine if a file is open by
another process? I didn't see any method or property in FSO that did
this. I thought I could perhaps suck in the results of "net file",
but I'm not entirely sure that would work as I do not know how Oracle
copies its redo logs to the .ARC files.

Any useful suggestions will be greatly appreciated.

Joe

[marist89]

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 [url]http://dbforums.com[/url]