RE: Copy Files From ASM to Traditional Storage
- From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Wed, 22 Sep 2010 11:59:12 +0100
What about making the tablespace read only and then using
DBMS_FILE_TRANSFER.COPY_FILE ?
Cheers,
Ian
|---------+----------------------------->
| | Mark.Bobak@proques|
| | t.com |
| | Sent by: |
| | oracle-l-bounce@fr|
| | eelists.org |
| | |
| | |
| | 20/09/2010 19:57 |
| | Please respond to |
| | Mark.Bobak |
| | |
|---------+----------------------------->
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: post.ethan@xxxxxxxxx, kamusis@xxxxxxxxx
|
| cc: pjhoraclel@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
|
| Subject: RE: Copy Files From ASM to Traditional Storage
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
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
This email was received from the INTERNET and scanned by the Government
Secure Intranet anti-virus service supplied by Cable&Wireless Worldwide in
partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) In
case of problems, please call your organisation?x02019;s IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
For the latest data on the economy and society consult National Statistics at
http://www.ons.gov.uk
*********************************************************************************
Please Note: Incoming and outgoing email messages are routinely monitored for
compliance with our policy on the use of electronic communications
*********************************************************************************
Legal Disclaimer : Any views expressed by the sender of this message are not
necessarily those of the Office for National Statistics
*********************************************************************************
The original of this email was scanned for viruses by the Government Secure
Intranet virus scanning service supplied by Cable&Wireless Worldwide in
partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On
leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
��i��0���zX���+�� n��{�+i�^
Other related posts:
