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

From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Wed, 18 Jul 2018 16:57:16 +0000
Message-ID: <CY1PR10MB0683B0687C14DD9AD8F72FFCD8530_at_CY1PR10MB0683.namprd10.prod.outlook.com>



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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Ls Cheng <exriscer_at_gmail.com> 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_at_gmail.com<mailto: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
Received on Wed Jul 18 2018 - 18:57:16 CEST

Original text of this message