Re: Can Anyone Explain ...

On Jan 29, 8:29 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
>
> I know you cannot do hot backup in NOARCHIVE mode. I mentioned the database
> was in NOARCHIVE mode because in Mark Powell's response he mentioned hot
> backups.
>

Most of the time when someone is asking about RMAN backups, the assumption is the database is in ARCHIVELOG mode, since that is required for standard RMAN functionality. You may have known the database was in NOARCHIVELOG mode, but you had not communciated that information in this posting.
>
> I don't think this DBA is even thinking about implementing a better
> solution. He appears to rule using RMAN out at all because of the catalog
> not being installed despite, like Mark Powell also mentioned, you can use
> the control file with RMAN. I have to believe that RMAN would be must more
> efficient and quicker than whatever he currently is using which takes nearly
> an entire day to perform a backup.
>

Probably most of the delay is writing to the tape - maybe over a network connection. RMAN would be an improvement only because it would write less data (only used portion of tablespaces in a compressed backup set files), but it would still be a long and slow process unless you stage the backup sets to disk first and then write them to tape or improve your tape system or server-to-tape communication. Are you willing to take an extra outage period each week (12-18 hours) as the DBA performs the normal cold backup and tests an RMAN backup process?

Prior to 10g, RMAN required a recovery repository, so maybe that's a training issue. RMAN was also a bear to work with in 8i, so maybe your DBA got burned there too.

Unfortunately, the confrontational tone of your posting and responses indicate your situation probably won't improve. It's not enough to be technically correct; you have to be able to work with others to implement the technically correct solution. It's hard to imagine your DBA doing much listening while you are challenging his base competence. I understand your frustration, but try to remember... "You can catch more flies with sugar than salt."

Regards,
Margaret Received on Tue Jan 30 2007 - 06:46:16 CST