Re: transporting 3 TBs of data to a new database
Date: Thu, 2 Oct 2008 22:30:47 +0100
I thought you were moving to a new database? If so then streams is certainly one option. If your question is about moving datafiles around then you should look at convincing the other team about ASM. Certainly I find the argument that you can move the database from one SAN to another without any downtime fairly convincing (though of course the san storage needs to be presented to the server in a non-downtime manner as well.
On Tue, Sep 30, 2008 at 9:26 PM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:
> the data is already in the database. i thought streams worked off the redo
> logs? they would not do us any good.
> On Tue, Sep 30, 2008 at 12:50 PM, Barun, Vlado <Vlado.Barun_at_jtv.com>wrote:
>> And if downtime is a concern, you can use streams to minimize to downtime.
>> Vlado Barun, M.Sc.
>> Senior Database Architect
>> Jewelry Television
>> Mobile: 865 335 7652
>> Email: vlado.barun_at_jtv.com
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of Martin Klier
>> Sent: Tuesday, September 30, 2008 11:00 AM
>> To: oracledbaquestions_at_gmail.com
>> Cc: oracle-l_at_freelists.org
>> Subject: Re: transporting 3 TBs of data to a new database
>> do you have a DB link in between? Or do you want to have the data on
>> disk for transport?
>> Just a hint: If not, use impdp via DB link, works like a charm in late
>> Dba DBA schrieb:
>> > I am on ASM, the group moving the data is not. I think transportable
>> > tablespaces is the best way to do this. So I have to use RMAN to put the
>> > data in ASM. Is this a copy to an an ASM tablespace? Any idea how
>> > this works? I am trying to figure out how long this will take. We may be
>> > able to do it in pieces.
>> > I dont think data pump is good for this.
>> > I also dont know a good wait to write comma delimitted files out of this
>> > much data to sql load.
>> Usn's IT Blog for Linux, Oracle, Asterisk
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 02 2008 - 16:30:47 CDT