Re: Archived logs

Daniel wrote in message <772v13$se2$1_at_inet16.us.oracle.com>...
>People often do this;
>
>Oracle archives to the archive log destination. (lets say c:\arch)
>The contents of c:\arch are backed up to tape.
>The contents of c:\arch are then deleted!!!
>
>## This is wrong ##
>
>If a log switch happens during the backup of c:\arch and the arch file does
>not make it onto the tape then you have a big problem... The next thing you
>do is delete the contents of the directory and along with it the un-backed
>up arch file. If this happens you have just made a very very big problem
for
>yourself !!!
>
>

I believe that if you only delete the files which have the archive flag set (or is it cleared?), as shown below, you should be OK:

del j:\orant\archive\*.dbf /a:-a

Otheriwise you will spend a lot of time every day verifying what was or was not archived...
Am I over-simplifying?

Zach Received on Fri Jan 08 1999 - 07:42:18 CST