Re: Hot Backup

Laurent,
I have an application named Installgen which automates creating backup/recovery scripts along with creating the documentation for performing 15 different database recovery scenarios.

You may download a demo version of Installgen so that you may conveniently look at or modify the scripts on your own computer: http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

Or you may choose to browse the individual output files via the web: http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_win90 1.html

Here is a full-featured RMAN backup script I like to use for situations where I am not using a recovery catalog: http://www.dotcomsolutionsinc.net/products/installgen/installgen_win901_29_. html
RMAN is preferred by Oracle over the Hot Backup method because it generates less redo in the database and you can also throttle the amount of I/O used by RMAN. (I have implemented this functionality on my scripts.) This means that if necessary, you can perform the RMAN backup while users are actively using the server without consuming all of the I/O bandwidth of the server. You will need to adjust the default I/O rate to a value which is suitable for your server.

If you really want to do hot backups, here is a script I have written: http://www.dotcomsolutionsinc.net/products/installgen/installgen_win901_33_. html
Each of these backup scripts also produces a disaster_recovery.txt output file to help you keep your database documentation up-to-date in case you need to rebuild the database on a different server in an emergency.

David Simpson
www.dotcomsolutionsinc.net

"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 Sun May 19 2002 - 17:35:36 CDT