Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can Anyone Explain ...
On Jan 29, 6:50 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Why the "DBA" in charge of a database would not use RMAN to back up a
> database? It currently takes nearly 24 hours each weekend to do a cold
> backup.
>
> When I questioned why about all the answer I got was that the RMAN catalog
> "wasn't installed". I also wasn't able to find out what it was he was using
> to do the backup of an over 2,000 GB data warehouse.
>
> Also, can anyone confirm/deny whether he has valid points in not using
> Oracle ASM when we are experiencing bad I/O throughput. His "reasons" were
> that he'd have to shut the database down in order to convert to ASM and he
> had a problem with raw devices.
>
> The I/O throughput problem we've been having is that there are 6 data
> tablespaces, 5 indexes tablespaces and 3 temporary tablespaces (and their
> associated physical files) all on the same drive causing massive waits if
> more than a few people start querying data.
PS - Obviously ASM means 10g. -- Mark -- Received on Mon Jan 29 2007 - 18:04:44 CST