Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hotbackup

Re: Hotbackup

From: Titi <thierry.constant2_at_wanadoo.fr>
Date: Tue, 16 Apr 2002 21:29:13 +0200
Message-ID: <3cbc7b53$0$5005$626a54ce@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 Tue Apr 16 2002 - 14:29:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US