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

  • From: "Eagle Fan" <eagle.f@xxxxxxxxx>
  • To: drp4kri@xxxxxxxxx
  • Date: Mon, 12 Nov 2007 16:39:05 +0800

hi:

There is no online way to move datafiles.

But you can use RMAN "copy file" to minimize the downtime.

1. use RMAN to copy datafiles
2. take datafiles offline
3. rename to new path
4. RECOVER DATAFILE
5. bring the datafile online.



On Nov 8, 2007 5:14 AM, Dhimant Patel <drp4kri@xxxxxxxxx> 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.



-- 
Eagle Fan

Oracle DBA
--
//www.freelists.org/webpage/oracle-l


Other related posts: