Re: Can Anyone Explain ...

On Jan 29, 7:15 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
>The Oracle version is 10 Release 2. From what I gather from previous
> meetings there are a number of patches he hasn't installed since he's
> waiting for release 3 to come out.
>
> Also, the database is in NOARCHIVELOG mode.-

NOARCHIVELOG mode means no hot backups - that's why he wants a cold consistent backup. If all the database files are on the same set of physical disks now, you need to additional disks for archive logs - logs should not be on the same disks as data files. Enough disk for writing RMAN compressed backup sets before pushing the backup sets to tape is good too. Backup set disk can be relatively slow disks - since any disk is generally faster than any tape. (Yes, there are some high end tape systems where that's not a valid statement.)

You may want to talk with the DBA about what he needs to implement a better or less down time backup solution. Lots of times the DBA knows how to make things work better, but may have gotten beaten down by a management mind set to a point he or she is no longer proposing better methods. For example, management requires all database storage be a high dollar SAN, then states storage for a fast disk-to-disk backup strategy is too expensive - even when a few high capacity fixed disks could handle the job for a few hundred dollars.

Is there a particular bug you are having a problem with that is fixed in one of the outstanding patch sets? A lot of DBAs do not want to take a chance on destabilizing a system with minor patch levels. Patching oracle software will not fix what sounds like (from the limited info) underlying disk storage problems. Received on Mon Jan 29 2007 - 19:14:30 CST