Re: Minimizing backup induced downtime

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 12 Jul 2007 14:10:01 -0500
Message-ID: <46967060$0$16351$88260bb3@free.teranews.com>

Alexander Skwar wrote:
> · Martin T. <bilbothebagginsbab5_at_freenet.de>:
>

>> You know ... after reading through the problem I have to say: Stick
>> with you scripts!
>> Since you need to shutdown the "system" anyway to make a backup AND
>> you need your application data as well

>
> Yep.
>

>> I really see no point in 
>> complicating things with RMAN. 

>
> Some people say, that RMAN offers advantages. I came to this newsgroup,
> to find out if this is true. So far, I cannot see an advantage. I mean,
> I see advantages, if I wanted to do something simple as taking a backup
> of just Oracle.

There are many advantages to RMAN for backing up your Oracle database. While not an exhaustive list, the advantages of RMAN include:

1. Block level incremental backups
2. Incrementally updated backups
3. Block-level restore
4. Ability to skip READ ONLY tablespaces
5. Automatically backup the control file and SPFILE
6. Ability to parallelize the backup
7. Restartable backups
8. Clone databases

Regular, user-managed hot and cold backups either cannot do the above, or have a very difficult time doing the above.

Please read the documentation again as all of these advantages are outlined there.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Thu Jul 12 2007 - 14:10:01 CDT