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

The database on Pure cannot be used as a standby for Exadata because it doesn't support HCC columns. You would never be able to read those columns. The only way you could use DB on Pure as a spare is replication, with GG or SharePlex.
Regards
On 07/18/2018 08:36 AM, Chris Taylor 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?
> 2. If so, what issues (gotchas) did you run into that we may need to
> consider?
> 3. Does this sound like a 'bad idea' already?  My gut is telling me
> this may be a bad idea.
>
> Chris
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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