Re: Hotbackup

I consider this Backup document from Howard so important that I downloaded the pdf for my own use.

If so badly needed, I can e-mail it to Titi, with Howie permission, of course.

Regards,

1. Fuentes afuentes_at_goodpremises.com

"Titi" <thierry.constant2_at_wanadoo.fr> wrote in message news:3cbc7b53$0$5005$626a54ce_at_news.free.fr...
> Thanks for the answers...
>
> "Howard Rogers" <Howard.Rogers_at_oracle.com> a écrit dans le message de
news:
> 3CBBC467.9A61C114_at_oracle.com...
> > 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
> >
>
>
Received on Wed Apr 17 2002 - 16:53:20 CDT