Re: Are Hot Backups Incremental?

I guess you got confused about the term HOT BACKUP.

When you perform a hot backup on your tablespace, you actually only put the tablespace on HOT BACKUP mode and then use OS copy command to copy the WHOLE datafiles to whatever places you want it to go. At the same time, you will need to backup all the archive log files in the process of the HOT BACKUP. I don't think that it is possible to do an incremental hot backups at all!! Since the data block is changing all the time (including the header), it is impossible to do an incremental hot backup.

I think you need need to read some books about backup and recovery. The method to recovery it to point of failure is like this:

SUN        MON        TUE         WED         THU        FRI        SAT
COLD        HOT        HOT        HOT         HOT        HOT        HOT

if your database crushed on wednesday, then all you need to do is to identify the datafile that had media failure. Then restore that file from Tuesday Hot Backup. And apply all the archive log files from the point of time you did the hot backup to the time of failure.

HTH Winnie

Margaret Peacock wrote in message <71889k$7lg$1_at_nrchh52.us.nortel.com>...
>If I do a cold backup once a week, and a hot backup every night, can I
write over the tarred hot backup file every night and still restore the database completely by restoring the cold, then the last tar file from the hot backup? OR .... Do I need to create a different tarred hot backup file for every day that follows the last cold backup in order to have a full restore? All advice is appreciated. Thanks in advance.
>
>-Margaret
>--
>---------------------------------------------------------------------------
 --
>Margaret Peacock ESN: 655-8559
>Intranet Web Master EXTERNAL: (408) 565-8559
>Nortel - Mission Park peacockm_at_nt.com
>---------------------------------------------------------------------------
- Received on Wed Oct 28 1998 - 00:00:00 CST