Re: Deletion of archive logs.

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:un04hh1hl.fsf_at_standardandpoors.com...
> Get this. At 8am, I finish deploying our app to production,
> inclusive of data loads. (Up until this point, we have performed
> our data loading in QA and exported the data to production). At
> 12:30, I recieve an FYI that our DBA team can't bring up our
> Disaster Recovery site because a script deleted some of the
> archive logs from the production site while my team was
> performing their latest deployment. They would have to hotbackup
> production and then bring that over to DR and bring it up from
> that. So, after a few "WTF" emails, I find out that that top
> database administration manager for my entire company (and this
> is a really large multinational data-centric company) authorized
> this script. His statement was, "We don't want Oracle to hang,
> so our script deletes archive logs and then sends an email to the
> DBA team so they can do hotbackups and also restore the DR
> sites".
>
> Whew! And you guys bitched at me cause I went against the dba
> wishes and had local database instances for development. I sure
> wish these guys would get their scripts into CVS like the rest of
> us who build applications. At lease someone with some semblance
> of common sense could have said "What the hell are you guys
> doing?"
>
> --
> Galen Boyer

Galen,
We have development instances and keep our scripts under version control. (that's standard good practice) We do delete our archive logs, but we do it like this:
cron job that gzips the archive logs (except the most recent one) at least 1 per day. At least once per day we back them up to tape. Then we delete any archive logs that are older than 3 days. (since they are on tape 3 times at this point) We make sure we have plenty of disk space for archive logs - well over the 3 day on disk set. So if someone needed an archive log over three days old we would be able to get it unless 3 separate tapes were bad.

Jim Received on Sun May 09 2004 - 14:12:44 CDT