Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help re: VB app copying redo log archives
Karsten Farrell wrote:
> Joe Tseng wrote: >
> > An Oracle background process, ARCH, copies the online redo log files to > an archived redo log file once it fills up. Depending on your operating > system, you might not be able to open the archive file currently being > written. But since ARCH writes to only one at a time, in serial fashion, > you might be better off if your VB6 app simply ignores the most recent > .arc file whenever it's called (I assume your app runs periodically and > not manually). >
Careful - any given ARCH process is only writing to one archive at a time, but you *can* have multiple ARCH processes writing to multiple archives simultaneously. This can happen if you're generating redo faster than you can archive it - a new online redo fills up before a previous log has finished being archived.
If you're not going to use RMAN to manage your backups, you'll want your script to be a bit paranoid (after all, these are your backups we're talking about). For example, our archive manage script 1) checks the file with 'fuser' to see if there are any open processes on it; 2) queries the database to make sure the database says it's done with it (not a trivial query when standby databases are involved); 3) copies (not moves) the file to the remote destination; 4) does a checksum on the source file and dest file and compares results; and 5) if the checksum comes back identical, it deletes the source file.
Given these complexities, I can't say I'd recommend this method if you don't have much experience with Oracle backup and recovery. Probably worth looking into RMAN.
Regards,
Sean
Received on Tue Jan 07 2003 - 16:25:59 CST