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

Home -> Community -> Usenet -> c.d.o.server -> Re: Small remark - Was: Backup Oracle ? Online Redo Log.

Re: Small remark - Was: Backup Oracle ? Online Redo Log.

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 11 Jan 2002 16:15:34 -0000
Message-ID: <3c3f0fa7$0$8507$ed9e5944@reading.news.pipex.net>


Actually it is far worse than that. I suspect that the consultants do know at least a bit about Oracle. The statement about what might be lost from the current redo log (should you lose all copies of it) is of course true. Unfortunately they don't have a clue about why you would wish to backup and recover in the first place.

So these consultants may or may not know about a particular technical product - however their ability to apply thought processes to that knowledge and then apply them to business requirements looks suspect. This of course bears no resemblance to any consultants I have ever come across.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Hemant K Chitale" <hkchital_at_singnet.com.sg> wrote in message
news:a1n29f$nqg$1_at_dahlia.singnet.com.sg...

>
> Those "consultants" don't know Oracle. They shouldn't
> have opened their mouths at all. And now we are speechless !
> Hemant K Chitale
> http://hkchital.tripod.com
>
>
> "Dusan Bolek" <pagesflames_at_usa.net> wrote in message
> news:1e8276d6.0201110140.40c82f18_at_posting.google.com...
> > "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:<3c3d744b$0$1586$afc38c87_at_news.optusnet.com.au>...
> > > Without doubt, the current redo log is the
> > > Achilles' heel of the entire Oracle architecture -which is why they
> invented
> > > redo log mirroring (or, more accurately) multiplexing so that total
loss
> of
> > > the current log should be a very rare occurrence -making attempted
> backups
> > > of it even more of a waste of time than they otherwise would be.
> >
> > Only small off-topic remark. Just few days back I had here two
> > consultants from well known worldwide consulting company. They trying
> > to sell us some new system based on Oracle database. One of my many
> > comments to their design was absence of any backup strategy for this
> > extremely important server. They responded me in way, which almost
> > knock me out.
> > There is (they've said) no need for online, offline backup or running
> > in ARCHIVELOG, because when using Oracle you will always lose, in case
> > of failure, data from active redo log, so everything you need are only
> > daily !exports!. And that's 1TB database we're talking about. This
> > perfect logic made me speechless. :-)))
> >
> > --
> > _________________________________________
> >
> > Dusan Bolek, Ing.
> > Oracle team leader
> >
> > Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> > can call it an overture to bankruptcy) on that server. I'm still using
> > this email to prevent SPAM. Maybe one day I will change it and have a
> > proper mail even for news, but right now I can be reached by this
> > email.
>
>
Received on Fri Jan 11 2002 - 10:15:34 CST

Original text of this message

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