Re: Backup on standby database

Hi Mladen,

"Mladen Gogala" <gogala.mladen_at_gmail.com> writes:

> Restoring just a full backup is simpler because you don't have
> to wait for the restore of the incremental backups. However,
> you are right: I should have said "faster" not "simpler".

Admittedly, it's taken me a bit to follow your line of thought. As an example, if a level 0 is taken on Sunday and the six incremental backups are taken on consecutive days, you are asserting that it would be better to instead take level 0s every day.

I can see how deduplication can speed up writes and possilby conserve space for the backups, but there is still is a performance hit with this strategy, right?

Level 0s still require scanning every block which takes time, so with BCT, RMAN already knows what has changed and the incrementals are going to complete much faster than dedplucated level 0s.

Do you have some test cases that prove this strategy?

Thanks,

Andy K

--
http://www.freelists.org/webpage/oracle-l