Hi !
indeed, a backup with copy-paste is not the right solution (as I thought
before I was told to do so...)...
When you do a copy-paste, while lots of operations such as insert or delete
are made, the restoration does not
work !...it works sometimes, but when thare no operations done on the
database...
"Laurent Boutet" <laurent.boutet1_at_libertysurf.fr> a écrit dans le message de
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 Wed May 15 2002 - 05:51:25 CDT
