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

This isn't really answering your question, but it reminded me of a great article posted yesterday by Christo Kutrovsky on how to recover deleted datafiles with no downtime. It's a great read: http://tinyurl.com/ytrtt6

Dan

• Original Message ---- From: Vitalis Jerome <vitalisman_at_gmail.com> To: drp4kri_at_gmail.com Cc: oracle-l <oracle-l_at_freelists.org> Sent: Thursday, November 8, 2007 8:13:32 AM Subject: 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





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