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:55 +0800
BTW: You can't move system & undo datafiles when database is open.
On Nov 12, 2007 4:39 PM, Eagle Fan <eagle.f@xxxxxxxxx> wrote:
> 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
>
--
Eagle Fan
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
