Re: Hot backup

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 - 18:59:49 CDT