Laurent Boutet wrote:
>
> 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
> >
> >
use rman.
--
Ron Reidy
Oracle DBA
Received on Mon May 20 2002 - 07:45:05 CDT
