Re: QUESTION: Basic stuff about RMAN 9i

DW wrote:
> I guess that's part of my need for research; I need to clearly quantify
> the added flexibility of the catalog, and then establish whether we
> need that. I guess for now I may as well learn to use it, and when the
> time comes to review with my 'masters', then we'll decide what we
> really need.
>
> Back to da' books. ;-)
>
> Thanks!
>

You're welcome.

After rereading the whole thread, one thing still wasn't addressed properly. If you do a level 0 backup and then a level 1 backup whithout much activity between the two backups, then your level 1 backup should be significantly smaller.

If level 1 is faster depends really. For one thing rman does backup *changed* blocks. But to know if a block has changed, it has to read the block first, so the backup might take as long as the level 0 backup.

If OTOH the level 0 backup was constrained by the backup device (slow tape drive) then level 1 will be faster.

BTW, are you in archivelog mode? (I don't know if you can do level 1 backups in noarchivelog mode, but if you can, that would explain the size).

Cheers,
Holger Received on Tue Jun 14 2005 - 18:25:14 CDT