Re: Copy Files From ASM to Traditional Storage
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Mon, 20 Sep 2010 14:09:13 -0500
Well, if ASM were not in the picture he could do alter database begin backup
and then do the copy, as long as he remembers to copy the archive logs along
with it. However, that wont work with ASM. I havent really followed this
conversation much, is there some reason he cant do a backup as copy, then
backup the controlfile to trace and edit it?
On Mon, Sep 20, 2010 at 1:57 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:
> Ethan,
>
>
>
> If you need to move an existing datafile from ASM to fs, or the reverse, I
> don’t see how that would be possible without, at a minimum, taking the
> datafile offline. Even if ASM were not in the picture, and you were moving
> a file from one fs to another, or moving the contents of a raw device to a
> file or a another raw device, you’d need to offline the datafile. You can’t
> move a moving target. If we’re talking about moving a datafile at the
> Oracle and O/S level, Oracle can’t be writing to it while you’re trying to
> move the contents to another location.
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Ethan Post
> *Sent:* Monday, September 20, 2010 2:34 PM
> *To:* kamusis@xxxxxxxxx
> *Cc:* pjhoraclel@xxxxxxxxx; oracle-l
> *Subject:* Re: Copy Files From ASM to Traditional Storage
>
>
>
> The two methods explained in the note require the database to be in "MOUNT"
> or the tablespace to be offline. I need to this while the database is
> available.
>
> On Sat, Sep 18, 2010 at 11:28 PM, Leyi Zhang (Kamus) <kamusis@xxxxxxxxx>
> wrote:
>
> Hi
>
> Maybe you wanna check MOS Note: How to move a datafile from ASM to the
> file system [ID 390416.1]
>
> --
> Kamus <kamusis@xxxxxxxxx>
>
> Visit my blog for more : http://www.dbform.com
> Join ACOUG: http://www.acoug.org
>
>
>
>
> On Sun, Sep 19, 2010 at 12:52 AM, Peter Hitchman <pjhoraclel@xxxxxxxxx>
> wrote:
> > Hi,
> > I second that, use the rman copy command and then the switch command. I
> have
> > not used the asmcmd cp command in 11.2, but my use of it in 11.1 has been
> > very negative.
> >
> > Regards
> > Pete
> >
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
