Hot Backup

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 - 09:39:49 CDT