The Oracle Exadata and ODA

Dear all,

  Right now we are going to do the Oracle database consolidation so that we use less server and therefore the operation cost can be lower down.

  We are considering to use Exadata and oracle database applicant, and please advice any pro and cons of both approach.

  Also how can they be managed ?Oralce comparsion
DBA100.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Franck PachotConnect With a Mentor Commented:
One ODA has 2 servers in RAC that share their storage: load balancong among those 2 nodes and high availability if one node is down.

Another ODA cannot share the first one, but can be a standby for the first one.

You can load balance (RAC) within an ODA, not across several ODA.

You can DR (DataGuard) across several ODA.
0
 
Franck PachotCommented:
Hi,

ODA is for ease of administration: in few hours you have storage+network+cluster+database+RAC installed. You have good performance because you have dedicated hardware. And you can start with few CPU (lower license cost) and activate them later.

Exadata is for performance and scalability: If you already have tuned your workload to use the all available CPU power (with parallel query) and have reached the point where I/O is the bottleneck, the Exadata can remove that bottleneck.

Regards,
Franck.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"have reached the point where I/O is the bottleneck, the Exadata can remove that bottleneck.
""
why is it ? as the storage is scabable too ?

will it be correct logic that right now we use ODA first and if later on we found the disk I/O is the bottleneck , then we can easily switch to Exadata? doable, right?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
marrowyungSenior Technical architecture (Data)Author Commented:
"You have good performance because you have dedicated hardware."

Exadata don't have dedicated hardware?

" And you can start with few CPU (lower license cost) and activate them later."

Exadata can't do it either ?
0
 
Franck PachotCommented:
Yes of course Exadata has dedicated hardware. But it has also special software to address performance: SmartScan, Storage Index, Hybrid Columnar Compression...

I mean Exadata has features for performance. ODA has good performance onbly because you have dedicated hardware.

Yes, on Exadata, you can start small (with 1/8 of RAC) and increase later. But 1/8 of RAC is still a big machine... nothing like an ODA with 2 CPU activated...
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"Yes, on Exadata, you can start small (with 1/8 of RAC) and increase later. But 1/8 of RAC is still a big machine... nothing like an ODA with 2 CPU activated... "

you mean the RAC cost for Exadata and ODA is different?

and the RAC for ODA is has ready 2CPU activated per RAC license? and RAC cost for Exadata is very expensive even for 1/8 of RAC ?

"ODA has good performance onbly because you have dedicated hardware.
"
this only mean ODA has no software to address performance: SmartScan, Storage Index, Hybrid Columnar Compression...
 ?

can we buy the software separately for ODA ? or only for Exadata ?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
someone also tell me that for inter site, like DR, only data guard can help.

RAC only help for intra server, like the 2 x cluster nodes, right?
0
 
Franck PachotCommented:
The RAC cost depends on the number of activated CPU. In ODA minimum is 2 In Exadata X3 minimum is 16 (I think - check the 1/8 rack configuration)

Exadata features are available only on Exadata machine (need storage cell)

RAC is high availability in cluster: you can loose one node. But it's not deasaster recovery: if your machine burns you loose all your cluster (both ODA and Exadata have all the servers in the same machine). You can have a dataguard standby on another site. That's just another machine to by ;)
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
ok, we just finsih a meeting on this.

Any refernece you can think of that ODA is good use and what if something wrong in the ODA and we can't find that out ? Which in this case Exadata is better as all server is separted and we can fix it one by one and we can't do it for ODA ?
0
 
Franck PachotCommented:
I don't understand your question.
>> all server is separted
That's the case for both: servers are separated but put in the same box. The box is just a bit more compact for ODA. Exadata 1/8 rack has a lot of free space ;)

>> Any refernece you can think of that ODA is good use
If you want an Oracle RAC cluster that is not too hard to configure, the ODA is good.
Even if Exadata is an applicance, don't expect to set it up in few hours.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
">> all server is separted
That's the case for both: servers are separated but put in the same box. The box is just a bit more compact for ODA. Exadata 1/8 rack has a lot of free space ;)"

yeah, the ODA just 4 U from what we understand.
\

"If you want an Oracle RAC cluster that is not too hard to configure, the ODA is good.
Even if Exadata is an applicance, don't expect to set it up in few hours. "

what I mean is, for example, are you using ODA at this moment?  any incident that the ODA fail before and how it fail ? how to recover that?

we just didn't see ODA's perfomance at all and not sure if ODA is good to use and scalarble !

can RAC connect 2 x ODAs ?each ODA has only 2 x server, right?
0
 
Franck PachotCommented:
>> each ODA has only 2 x server, right?
Right
>> can RAC connect 2 x ODAs ?
No. Each has its own storage, cannot be shared.
>> any incident that the ODA fail before and how it fail ? how to recover that?
Same as any database: either restore a backup or failover to a standby
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"Same as any database: either restore a backup or failover to a standby "

then we relies on RAC or Data Guard, right?


">> can RAC connect 2 x ODAs ?
No. Each has its own storage, cannot be shared."

no. I mean is 2 x the ODA nodes share a storage, the RAC will DR and load balance the 2 x nodes, right?

I would like to know if 2 x ODA can use RAC to load balance and DR ?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"Another ODA cannot share the first one, but can be a standby for the first one."

how ? using RAC or data guard?
0
 
Franck PachotCommented:
RAC: load balancing + high availability in case of server failure
-> is in the same ODA box


DataGuard: Deasaster Recovery (in case of server+disk failure)
-> is across several ODA box
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"
DataGuard: Deasaster Recovery (in case of server+disk failure)
-> is across several ODA box "

we have dataguard for the DR server that is not readable in normal operation, active data guard is readable only in normal operation, what else?

"RAC: load balancing + high availability in case of server failure
-> is in the same ODA box"

so the RAC is installed on both nodes of server in the same ODA and RAC can't across that boundary anyway.
0
 
Franck PachotCommented:
Yes, right.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.