Re: Hotbackup

"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