Re: Is it possible to rename/move datafile online - possibly under RMAN?
- From: Dan Norris <dannorris@xxxxxxxxxxxxx>
- To: vitalisman@xxxxxxxxx, drp4kri@xxxxxxxxx
- Date: Thu, 8 Nov 2007 06:46:00 -0800 (PST)
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@xxxxxxxxx>
To: drp4kri@xxxxxxxxx
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
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@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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
