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.
Another option to consider - Oracle's ZFS storage has HCC available, which
could be used in scenarios like these (it works with commodity hardware) so you
can minimize the configuration differences between the environments.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Ls Cheng <exriscer@xxxxxxxxx>
Sent: Wednesday, July 18, 2018 12:47 PM
To: Chris Taylor
Cc: ORACLE-L
Subject: Re: Question - standby database from Exadata to non-exadata ?
response in-line
On Wed, Jul 18, 2018 at 2:36 PM, Chris Taylor
<christopherdtaylor1994@xxxxxxxxx<mailto:christopherdtaylor1994@xxxxxxxxx>>
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