Re: [RMAN]

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 25 Jun 2002 22:45:48 +1000
Message-ID: <muZR8.20710$Hj3.65484@newsfeeds.bigpond.com>

Hi Christian,

Yes, it needs to read the headers of the initialised blocks but if a large portion of them don't need to be recopied then you can save yourself a significant amount of time.

My recommendation would be to test an incremental strategy and see the benefits. If you only have a 5 hour window, you may want to consider performing a hot backup with RMAN which doesn't have quite the same overheads (although 5 hours may be sufficient time with the incremental backup).

I would also recommend testing your restore performance to help determine an appropriate incremental strategy.

Regards

Richard
"Christian GILBERT" <externe.gilbert_at_francetelecom.com> wrote in message news:1104_1025010242_at_10.193.118.17...
> Hi !
>
> A little thing I am wondering about :
>
> Is there an interest in using incremental backups to minimize the backup
time of a database ?
> I have a 650 Gb DB that can be backed up in a 12 hour window the saturday,
but the backup
> window drops at 5 hours during the week. The full backup takes 9 hours.
>
> The Oracle documentation says that as an RMAN incremental backup needs to
read all the
> blocks, in order to see which ones were modified, it's running time might
be almost the same
> as a full backup.
>
> Does someone have an experience about it ?
>
>
Received on Tue Jun 25 2002 - 07:45:48 CDT