Re: Huge memory consumption during hot backup

borghesi_at_libero.it (Paolo) wrote in message news:<63aec3d1.0409220241.24c31d01_at_posting.google.com>...
> Hi Howard,
> I've configured RMAN, with a simple scripts like:
>
> -----------------------------------
> run
> {
> allocate channel ch1 type disk format 'd:\backup\backup_PBW';
> backup database;
> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
> }
> -----------------------------------
>
> and the memory consumption during backup is about 30-40 Mb (about 1/15
> than using the operating system scripts!).

RMAN 1, user-managed backups 0.

Good, I'm glad things are working OK for you.

> Besides, I tried to use RMAN without a catalog, by using the command
> "rman target user/password_at_pbw nocatalog @d:\test_rman\script.txt log
> d:\backup\backup.log", and everything worked correctly.

Of course.

> What do you mean exactly by "It's a distraction that requires
> management that gives you nothing very much in return"?

I was answering someone's comment that "it's a good idea if at all possible" to USE a catalog. I said, 'no actually, the use of a catalog is really just a distraction, that requires additional management burdens -because there's a new database to be looked after- and that in fact RMAN will work perfectly well without a recovery catalog.

>I've read the
> "Oracle 8i - Recovery Manager User's Guide and Reference", and I've
> not seen any particular drawnback of using the control file instead of
> the catalog...

There are some, but they tend to be a little exotic. You cannot, for example, restore the database back to a prior incarnation without a catalog dataabse. You cannot perform Tablespace Point in time Recovery (TSPITR) without a catalog, and you can't report on what a database's physical makeup historically was. But I have never felt the need to do any of those things, and so I say again that the recovery catalog is, for me at least, a bit of a distraction and an extra management hassle.

RMAN works beautifully without one. As you have discovered.

I think you might just been misunderstanding the context in which I made that original remark.

Regards
HJR Received on Wed Sep 22 2004 - 17:27:14 CDT