Re: Question - standby database from Exadata to non-exadata ?

Out of curiosity, I assume you use TDE and Advanced Compression on the Exadata side. What storage are you using on the standby commodity hardware and are you using the same datafile compression & TDE on the commodity hardware for the standby?

Chris

On Wed, Jul 18, 2018 at 11:47 AM Ls Cheng <exriscer_at_gmail.com> wrote:

> response in-line
>
> On Wed, Jul 18, 2018 at 2:36 PM, Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> We're gearing up for a massive migration to an Exadata machine and in the
>> process we're going to be freeing up a lot of our previous hardware and
>> storage. The current storage is Pure m70.
>>
>> What we 'thought' we were going to do was something like this (high
>> level):
>> 1. Migrate DB to Exadata
>> 2. Rebuild standby dbs on non-exadata using the now freed up Pure storage
>> 3. Clone dev/test/staging environments from Standby DB on Pure
>>
>> HOWEVER, I'm not sure that's doable as Exadata uses TDE and Advanced
>> Compression. It doesn't appear that Pure likes using AC at the DB layer
>> and instead prefers managing the compression and deduplication internally.
>>
>> Question(s):
>> 1. Has anyone here built a standby on different hardware from Exadata
>> when primary is on Exadata?
>>
> *I do, I have recently (a few months) helped a customer migrate from Sparc
> platform to Exadata quarter rack x6-2 in primary site and commodity intel
> Dell servers in DR site.*
>
>> 2. If so, what issues (gotchas) did you run into that we may need to
>> consider?
>>
> *No, no gotchas as long as you don use Cell functionalities such as HCC.
> Some of migrated database is running since December 2017 and so far we have
> not hit any issues.*
>
>> 3. Does this sound like a 'bad idea' already? My gut is telling me this
>> may be a bad idea.
>>
> *Well if you talk with Oracle Sales or presales they will tell you this is
> a bad idea mainly because your DR site has not got the same power as
> primary site. In my customer case they were willing to have less powered DR
> site, they assumed once in DR they can only have 30% primary site's
> capacity*
>
>>
>> Chris
>>
>>
>

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