Subject: Re: Migrate from AIX to Linux
To: Deepak Sharma <sharmakdeep_oracle@yahoo.com>,
 "oracle-l@freelists.org" <oracle-l@freelists.org>
References: <566B7C92.5090103@gmail.com>
 <777984936.105214.1449897844642.JavaMail.yahoo@mail.yahoo.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <566BBFC1.2050806@gmail.com>
Date: Sat, 12 Dec 2015 01:33:37 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: <777984936.105214.1449897844642.JavaMail.yahoo@mail.yahoo.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com

On 12/12/2015 12:24 AM, Deepak Sharma wrote:
> It's about 200TB active data-warehouse with 8B rows loaded and 5-6TB 
> arch generated a day.
>
> We'll try to look into the "Cross Platform Incremental Backup" that 
> Andrew mentioned.
>
> -thanks

If HUR or SRDF are available, they can significantly speed up making the 
initial data files copy. I would be very surprised if a 200TB database 
wasn't on EMC VMAX or Hitachi , so SRDF or HUR are probably an option. 
Just don't forget to put the database into the backup mode before 
cloning it with a disk replication tool.
I know that the decision has already been made, but in my opinion, IBM 
can handle high IO loads, like the ones typically imposed by a DW type 
database, much better than any Linux/x86_64 box. The difference is in 
the machine architecture. IBM has memory attached smart channels, while 
x86_64 boxes have interrupt based IO technology, which is inferior to 
the large IBM boxes. I hope a realistic benchmark was performed prior to 
such a decision. I sometimes see such migrations as intermediate step 
before "migrating to the cloud". I will refrain from expressing my 
opinion about that.
Regards.

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l