Re: Is it possible to rename/move datafile online - possibly under RMAN?

No, there is no such functionality in RMAN. (BTW what's your version?)

If you can afford taking the related tablespace READ ONLY during the operation, you may try such a method: tablespace switch to READ ONLY -> OS copy of the datafile (long) -> datafile switch to OFFLINE -> datafile renaming -> datafile switch to ONLINE -> tablespace switch to READ WRITE which limits the unavailability duration.

Be sure to try the procedure on a test box beforehand. ;)

On Nov 7, 2007 10:14 PM, Dhimant Patel <drp4kri_at_gmail.com> wrote:
> Hi,
>
> I need to move certain datafiles to another partition which is recently made
> available. I can move/rename files after taking them offline - although I
> would prefer if RMAN can do this while the file is online!
>
> Is there such way of moving files? A quick look at RMAN commands doesn't
> offer any clue.
>
> -Thanks,
> DP.

--
http://www.freelists.org/webpage/oracle-l