Can Anyone Explain ...

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Mon, 29 Jan 2007 18:50:22 -0500
Message-ID: <TKvvh.298$o61.270@newssvr19.news.prodigy.net>

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. Received on Mon Jan 29 2007 - 17:50:22 CST