Re: Hot backup

Opps, just read my post and I forgot to say Hi Zeb,

The comments regarding reading up on Backup and Recovery were aimed at Zeb and not Daniel (whom I'm guessing probably has B& R manual cached in his head :)

Regards

Richard
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:dToX8.33225$Hj3.99939_at_newsfeeds.bigpond.com...
> Hi
>
> IMHO there are basically three things that are essential to recover a
> database:
>
> 1) A complete backup of the database (at least all data files and control
> files). This backup can be either cold or hot. The cold backup has certain
> advantages such as being easy to perform and being consistent (which might
> be useful if you lack one of the other key things) but a complete hot
backup
> fully protects your database.
>
> 2) All the redo logs between the oldest backed up file and the current
state
> of the DB. Having multiple copies of your archived logs in not a bad idea.
> They're really really important.
>
> 3) A DBA who knows what they are doing. Sounds obvious but essential.
>
> I suggest a good read of the Backup and Recovery doco and ensure your
> organisation has all three.
>
> Good Luck
>
> Richard
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3D2DE457.1553AA8B_at_exesolutions.com...
> > zeb wrote:
> >
> > > Hi,
> > >
> > > I just passed my base in archive log
> > > so now I do my backup with begin backup / end backup
> > >
> > > I have to do a cold-backup ????
> > > or can I live like this without problem ? (recovery )
> > >
> > > conf: 8.1.7 on HP-UX 11.0
> >
> > A lot more information is required to give you anything approaching a
> > good answer.
> >
> > But, for myself, I consider a combination of a cold backup and an export
> > essential.
> >
> > Daniel Morgan
> >
>
>
Received on Thu Jul 11 2002 - 19:19:51 CDT