Re: "Mirroring" of DBF files

Hi UNIX admin,
  Are you moving the whole database? How many files are you moving? You have already got very valid and good suggestions. HEre is one more :

Basically you can use the hot backup approach along with the 'offline .... rename .... online' already suggested.

1. Put the tablespace in hot backup mode.
2. Copy the datafiles at the OS level to the new location.
3. Put the tablespace out of backup mode.
4. Put the tablespace datafiles offline.
5. Rename all of them to the new files at new location.
6. Recover tablespace
7. Put the datafiles tablespace online.

This way you are only offline for the duration of the recovery not the entire copy. Good luck.

This will ofcourse mean a lot of manual effort if you do it one tablespace at a time. By extension you can offcourse do it in one shot for all the tablespaces to be moved.  

dejanews_at_keithkris.com (Keith Kris) wrote in message news:<c0a42db2.0311070605.58fa9baa_at_posting.google.com>...
> 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 - 19:35:06 CST