Backing up by just copying open database files does not produce a reliable
backup. You need to...
- Ensure database is in archive log mode.
- You should also turn on automatic archiving. This step is not necessary
but without it you need to manually archive logs whenever they fill.
- 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 Tue May 14 2002 - 10:51:45 CDT
