Obviously archived redo logs are backed up as frequently as required, but does it make any sense to backup online redo logs? Is the online redo log an open and active file such that copying it in this state is a waste of time (same as backing up an open database)?
If the online redo log hasn't switched for 20 minutes (so that the log was available for archiving) then if the system fails and media recovery is required and you haven't backed up the online redo log, surely you've just lost the last 20 minutes of transactions?
I know there are other, more robust ways of transporting redo information to ensure nothing is lost, but I'm still interested in the state of the online redo log files.
Thanks for your time.
There is a regular background process running regularly that ships off archived log files and online log files. I don't have much control of this process. Are the online log files usable, or could they be corrupt if the log was being written to when the backup was taken?