Re: Benefits of RMAN

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 26 Jun 2004 21:33:42 +1000
Message-ID: <40dd5efb$0$18194$afc38c87@news.optusnet.com.au>

You're missing the big one.

Alter tablespace...begin backup causes your tablespaces to generate 10, 20 maybe even 30 times as much redo as they would normally. That redo inflation rate doesn't happen with RMAN. Extra redo writing is not good news for performance.

Besides: RMAN needs no scripting. So no home development whose quality is often dubious. Also, ASM works as well with raw as with cooked file systems.

And keep an eye on things like 10g's ASM: RMAN is the *only* way to back up ASM-based data files. So... just as when 9.2 came along, and we could smell that the days of dictionary-managed tablespace were nearing their end, so you should begin to sense that the days of "begin backup" are drawing to a close. Get with the program, therefore, and invest some effort into the one technology that has a future.

Regards
HJR "DB2 Convert" <db2convert_at_yahoo.com> wrote in message news:15fb8792.0406260122.5dcb55b4_at_posting.google.com...
> Hi,
>
> Really, if my database isn't big enough to deploy incremental backup, I
don't
> see the advantages of RMAN over the conventional ALTER TABLESPACE ...
BACKUP BEGIN.
>
> Advantages of RMAN are:
>
> 1. Incremental where only modified data blocks will be copied
> 2. Integrity check for the data block in case they are corrupted
> 3. Can do parallelism instead of sequential
> 4. ???
>
> What else?
>
> Anyone can list down more advantages of RMAN will really be appreciated.
>
> Thanks
>
> DB2 Convert
Received on Sat Jun 26 2004 - 06:33:42 CDT