Hot Backup

From: Laurent Boutet <laurent.boutet1_at_libertysurf.fr>
Date: Tue, 14 May 2002 16:39:49 +0200
Message-ID: <abr6tj$48j$1_at_reader1.imaginet.fr>



Hi all !
[Quoted] [Quoted] please forgive my french accent...I hope you'll understand me ;-)

[Quoted] a few weeks ago, I have had to make a software in order to do a backup of Oracle DataBase...
[Quoted] First I began with cold backup which worked very well...I stopped my Oracle DataBase then
[Quoted] [Quoted] did a backup of all the necessaries files...the restoration of such a backup [Quoted] [Quoted] [Quoted] worked well too...
But I read that cold backups were not very very good...because of the need [Quoted] to shutdown the database...
So, the hot backup was the solution...my customers could work while I was [Quoted] making my hot backup...
I tried to do hot backups...but I had troubles....difficult to solve....Hot [Quoted] [Quoted] [Quoted] backup was quite complicated to set...you know...I had to use the command "begin backup...end backup" to copy all the [Quoted] tablespace.... etc.

[Quoted] [Quoted] And yesterday, someone told me that I just had to copy all the files of my [Quoted] [Quoted] database (datafiles, control files, redologs files, [Quoted] archive files etc....) in order to do a hot backup ! Thanks to the redo logs...
[Quoted] [Quoted] I was astonished !...but indeed, copy-paste seems to work very well ! [Quoted] I say "seems to work very well" because it seems...but I not 100% sure ... [Quoted] 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 [Quoted] copy-paste of oracle Database

What do you think about this ????
[Quoted] Do you have any suggestion ?

[Quoted] How do you do you backups ?

Thanks in advance,
Laurent Received on Tue May 14 2002 - 16:39:49 CEST

Original text of this message