I need to know Is oracle exadata database is same as the oracle database which is installed in my laptop. What is the main difference.
Can I simply take backup from exadata database and restore it in my laptop?
What is Oracle Exadata Database?
exadataoracleoracle-11goracle-11g-r2oracle-12c
Related Question
- How to restore 11gR2 fullbackup to 12c database in rman
- Oracle – Fix TNS Permission Denied When Creating Database
- Oracle Full Database Backup – Required After ARCHIVELOG Mode
- ‘OraOLEDB.Oracle’ provider is not registered on the local machine – Oracle Database Client 12C
- Restore database using impdp full back
- How could we start Oracle database in Oracle Exadata which’s celldisk has proactive failure
- Oracle restore to a differnet drive
Best Answer
Oracle Exadata database machine is a hardware solution from Oracle which runs the usual Oracle Database Software. However it has an extension: the disks are accessed by special storage nodes which are smart: when the DB tells them to read blocks from a database table they can also tell them filter conditions: the result is that IO bandwidth and caches are distributed to multiple machines and table scans are parallelized (offloading from the main database machine). Besides that there can be additional Flash Cache and the interconnect use fast Infiniband network connections.
This makes it not only faster for typical OLAP queries, but also more robust against wild ad-hoc queries. The disadvantage is that you need to have a big workload so it is worth it.
Exadata uses Linux or Solaris as the Operating System.
It must not be confused with ODA, which is the database appliance without the special storage nodes.
Exadata is for the purpose of applications interacting with it invisible. This also means you can import backups from there and run the same queries (sans management queries for the distributed storage of course).