Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Is it possible to rename/move datafile online - possibly under RMAN?

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

From: Eagle Fan <eagle.f_at_gmail.com>
Date: Mon, 12 Nov 2007 16:39:05 +0800
Message-ID: <4415a5ed0711120039t49f50788jfd36da17383971e@mail.gmail.com>


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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 12 2007 - 02:39:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US