BTW: You can't move system & undo datafiles when database is open.
On Nov 12, 2007 4:39 PM, Eagle Fan <eagle.f_at_gmail.com> 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_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.
>
>
>
> --
> Eagle Fan
>
> Oracle DBA
>
--
Eagle Fan
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 12 2007 - 02:39:55 CST
