Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Archived logs

Re: Archived logs

From: Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com>
Date: Fri, 8 Jan 1999 08:42:18 -0500
Message-ID: <77523i$2nqa3@tmpsp002.tmpprv.allied.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US