Re: Hot Backup

Are you actually able to RESTORE this backup?

Tom
OraclePower.com

"Laurent Boutet" <laurent.boutet1_at_libertysurf.fr> wrote in message news:abrbgk$5k2$1_at_reader1.imaginet.fr...
> Hi !
> thanks for your answer...
> But I'd like to know the case when such a backup is not reliable, as you
> told me....because, it really seems
> to work...so, when will I have trouble doing this kind of backup ???
>
> Thanks,
> Laurent
>
> "Chuck" <chuckh_nospam_at_softhome.net> a écrit dans le message de news:
> abrbql$khcap$1_at_ID-85580.news.dfncis.de...
> > Backing up by just copying open database files does not produce a
reliable
> > backup. You need to...
> >
> > 1. Ensure database is in archive log mode.
> > 2. You should also turn on automatic archiving. This step is not
necessary
> > but without it you need to manually archive logs whenever they fill.
> > 3. For each tablespace do a: start backup, copy (or ocopy on NT) the
> > datafiles, end backup.
> >
> >
> > "Laurent Boutet" <laurent.boutet1_at_libertysurf.fr> wrote in message
> > news:abr6tj$48j$1_at_reader1.imaginet.fr...
> > > Hi all !
> > > please forgive my french accent...I hope you'll understand me ;-)
> > >
> > > a few weeks ago, I have had to make a software in order to do a backup
> of
> > > Oracle DataBase...
> > > First I began with cold backup which worked very well...I stopped my
> > Oracle
> > > DataBase then
> > > did a backup of all the necessaries files...the restoration of such a
> > backup
> > > worked well too...
> > > But I read that cold backups were not very very good...because of the
> need
> > > to shutdown the database...
> > > So, the hot backup was the solution...my customers could work while I
> was
> > > making my hot backup...
> > > I tried to do hot backups...but I had troubles....difficult to
> > solve....Hot
> > > backup was quite complicated to set...you
> > > know...I had to use the command "begin backup...end backup" to copy
all
> > the
> > > tablespace.... etc.
> > >
> > > And yesterday, someone told me that I just had to copy all the files
of
> my
> > > database (datafiles, control files, redologs files,
> > > archive files etc....) in order to do a hot backup ! Thanks to the
redo
> > > logs...
> > > I was astonished !...but indeed, copy-paste seems to work very well !
> > > I say "seems to work very well" because it seems...but I not 100% sure
> ...
> > > I thought that copy-paste of Oracle database was not
> permitted....because
> > > some backup software (like backup synchoniser for instance I think)
> can't
> > do
> > > copy-paste of oracle Database
> > >
> > > What do you think about this ????
> > > Do you have any suggestion ?
> > >
> > > How do you do you backups ?
> > >
> > > Thanks in advance,
> > > Laurent
> > >
> > >
> >
> >
>
>
Received on Thu May 16 2002 - 21:25:16 CEST