Re: Hotbackup

Comment below
HJR Sybrand Bakker wrote:

> "Titi" <thierry.constant2_at_wanadoo.fr> wrote in message
> news:3cb950d3$0$15587$626a54ce_at_news.free.fr...
> > Hi,
> >
> > I do my backup whith:
> >
> > >alter tablespace toto begin backup
> > >host cp ...
> > >alter tablespace toto end backup
> > For all tablespaces
> > I am in archivelog ( 8.1.7 )
> >
> > Is it a right way to do the backup ?
> >
> > What RMAN do more ?
> >
> > Thanks ...
> >
> >
> >
> >
> >
> >
>
> You need to (after the actual backup)
> alter system switch logfile
> backup your archived redo log files (NOT the online redolog files)
> backup your controlfile.
> If this is your complete backup you will be toast when anything goes wrong.
> Please checkout www.hjrdba.com this has a complete course in the books link
> (one single pdf document)
>

>
> RMAN completely automates the backup process. Right now you have probably
> hardcoded all your datafiles in your script. If you add a datafile and
> forget to change the backup script you are also toast (in my job, this
> happened with a particular site 2 times already). RMAN on every run
> determines which files to backup.
> It also determines which files to restore, which archive logs to apply, it
> can crosscheck and validate a backup against the database, it can perform
> TableSpace Point in Time Recovery, and above all it allows for incremental
> backup.
> It also integrated with Legato Storage Manager, a stripped version of Legato
> Network Manager, and it comes with it's own Media Management API, which is
> supported by many third party backup products.
>
> Anyone, who already has RMAN (comes with Enterprise Edition), would waster
> their time by writing their own conventional backup scripts.
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address

Due to various technical problems, I'm afraid the site will not be available until about Friday. My apologies to all who might have been interested in some of its contents. Normal service will be resumed as soon as possible.

Regards
HJR