Re: Cold & Hot backup!

In hot backup you need only the archive redo logs used since the last backup (look in the alert.ora file to find out the archive logs needed).

Ofer
<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:31:35 CDT