Re: Cold & Hot backup!

The rule is simply this: to be able to guarantee complete recovery of all committed transactions, you need to supply the entire set of redo since the time the last complete backup started.

And that rule holds true whether you are talking hot or cold backup.

The only difference taking hot backups makes is that the phrase 'time the last complete backup *STARTED*' becomes all-important. Given a database with 3 tablespaces, you could back one up on Monday, one on Tuesday and one on Wednesday. You need to retain all redo generated since MONDAY, since that was the *start* of the backup cycle.

Regards
HJR <hartono_nugroho_at_attglobal.net> wrote in message news:3b4661cd_1_at_news1.prserv.net...
> Thanks for your quick response.
>
> I want to be able to delete all of the old archive redo log files after I
> did a cold backup and start over again with the ARCHIVE redo log.
> My undersanding is that by using cold backup, you only need to backup the
> ONLINE redo log file, while in hot backup you need to have all
> the ARCHIVE redo log file. Or do Oracle automatically reuse the archive
> redo log when you issue alter tablespace begin backup command?
> Currently I am using only a cold backup so I don't really know the
 situation
> of hot backup.
>
> Regards,
> Ari
>
> "Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
> news:9i5jep0be2_at_drn.newsguy.com...
> > In article <3b465115_3_at_news1.prserv.net>, <hartono_nugroho_at_attglobal.net
 says...
> > >
> > >Hi all,
> > >
> > >Is it possible to combine hot & cold backup together? I want to use
 hot
> > >backup but I think it will be nice if I do cold bakup as well once a
 month
> > >and delete all of the archive redo log and start again to conserve disk
> > >space.
> > >
> > >Thanks for your suggestion,
> > >Ari
> > >
> > >
> >
> > I don't understand -- you need just as many archives with cold as hot...
> >
> > Yes, you can mix and match them.
> >
> > No, cold won't save any disk space.
> >
> > You just need to be running in archivelog mode, you can use either a
 cold
 or hot
> > backed up file during media recovery.
> >
> > --
> > Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> > Expert one on one Oracle, programming techniques and solutions for
 Oracle.
> > http://www.amazon.com/exec/obidos/ASIN/1861004826/
> > Opinions are mine and do not necessarily reflect those of Oracle Corp
> >
>
>
Received on Sat Jul 21 2001 - 16:32:37 CDT