"Mirroring" of DBF files

Hi all,

I'm a UNIX admin, and only have minor oracle experience, so chances are this is a stupid question (there are no stupid questions, only stupid people.) We have a production database which is growing a little large. We're in the process of adding more disk to allow growth. We'd like to migrate the existing system away from the 12GB volumes it currently uses, and toward 72GB volumes. We'd like to have only one size of volume used on the system, so we'd need to move our data from the old ones to the new larger filesystems. Talking to our DBA, he says the only method to accomplish this is to shut down the database, move the files, modify init.ora and bring the instance back up. The problem with this is it would create too much down time (we're moving more than a quarter terabyte.) Is there any method within oracle to have the database either use two identical copies of a DBF file simultaneously (essentially mirror them) or to have oracle itself relocate a DBF file to prevent downtime? I'm open to ideas here, so creative thinking is welcome.

Thanks
Keith Received on Fri Nov 07 2003 - 08:05:47 CST