Depending on the downtime allowed there are several options:
Goldengate Replication after a data restore onto Exadata.
13) What types of operations does Exadata “offload”?
Some of the operations that are offloaded from the database host to the cell servers are:
Column project filtering
14) What is cellcli?
This is the command line utility used to managed the cell storage.
15) How do you create obtain info on the Celldisks?
At the cellcli command line you can issue the “list celldisk” command.
16) How would you create a grid disk?
At the cellcli command you would need to issue the “create grididsk all ..” command.
16) What are the cellinit.ora and the cellip.ora files used for?
These files have the hostnames and the ip address of all the nodes in the cluster. They are used to run commands on remote database and cellserver nodes from a local host.
17) Which package can be used to estimate the compression ration of table?
18) Background services of Cell Server
MS- Management Server
cellsrv – Cell Server
RS – Restart Server
19) How many disk comes with in a storage cell?
20) What is the purpose of spine switch?
Spine switch is used to connect or add more Exadata machine in the cluster
21) How to migrate database from normal setup to Exadata ?
There many methods we can use to migrate DB to Exadata. Below are some of them.
2. Physical Standby
3. Logical Standby
4. Transportable Tablespace
5. Transportable Database
6. Golden gate
7. RMAN cold and hot backup restoration
8. Oracle Streams
22) Can we use flash disk as ASM disk?
23) Which protocol used for communication between database server and storage server?
24) which OS is supports in Exadata?
Database servers has two option for OS either Linux or Solaris which can be finalized at the time of configuration Cell storage comes with Linux only
25) What is ASR?
ASR is the tool to manage the Oracle hardware. Full form of ASR is Auto Service Request. Whenever any hardware fault occurs ASR automatically raise SR in Oracle Support and send notification to respective customer.
26) How to upgrade firmware of Exadata components?
It can be done through ILOM of DB or Cell server.
27) Where we can define which cell storage can be used by particular database server?
CELLIP.ORA file contains the list of storage server which is accessed by DB server.
28) What are the Exadata Health check tools?
4. OEM 12c
29) What is EHCC?
EHCC is Exadata Hybrid Columnar Compression which is used to compress data in the Database.
30) What is offloading and how it works?
It refers to the fact that part of the traditional SQL processing done by the database can be “offloaded” from the database layer to the storage layer
The primary benefit of Offloading is the reduction in the volume of data that must be returned to the database server. This is one of the major bottlenecks of most large databases.
31) What is the difference between cellcli and dcli?
Cellcli can be used on respective cell storage only.
DCLi (Distributed command Line Utility) – DCLI can be used to replicate command on multipla storage as well as DB servers.
32) What is IORM and what is its role in Exadata?
IORM stand for I/O Resource Manager which manages the I/Os of multiple database on storage cell.
33) How we can check whether oracle best practice has been configured on Exadata?
We can execute Exacheck and verify the best practice setup on Exadata machine.
34) How many networks required in Exadata?
1. Public/Client Network — For Application Connectivity
2. Management Network — For Exadata H/W management
3. Private Network — For cluster inter connectivity and Storage connectivity
35) What is the command to enable query high compression on table?
SQL>alter table table_name move compress for query high;
36) How to take cell storage software backup?
It is not required to take a backup as it happens automatically. Exadata use internal USB drive called the Cellboot Flash Drive to take backup of software.
37) What is the difference between wright-through and write-back flashcache mode?
1. writethrough –> Falshcache will be used only for reading purpose
2. writeback –> Flashcache will be used for both reading and writing
38) Which feature of Exadata is used to eliminate disk IO?
39) What is the capacity of Infiniband port ?
40) What is the difference between high capacity and high performance disk?
1. High capacity disk comes with more storage space and less rpm (7.5k)
2. High Performance disk comes with less storage and high rpm (15k)
41) When one should execute Exacheck?
Before and after any configuration change in Database Machine
42) What is grid disk?
Grid Disks are created on top of Cell Disks and are presented to Oracle ASM as ASM disks.
Space is allocated in chunks from the outer tracks of the Cell disk and moving inwards. One can have multiple Grid Disks per Cell disk.
43) Which network is used for RAC inter-connectivity?
44) What is Smart Scan?
It is a feature of the Exadata Software which enhances the database performance many times over. It processes queries in an intelligent way, retrieving specific rows rather than the complete blocks. It applies filtering criteria at the storage level based on the selection criteria specified in the query. It also performs column projection which is a process of sending only required columns for the query back to the database host/instance.
45) What are the Parallelism instance parameter used in Exadata?
The parameter PARALLEL_FORCE_LOCAL can be specified at the session level for a particular job.
46) Which statistic can be used to check flash hit ration on database level?
Cell flash cache read hits
47) Which disk group is used to keep OCR files on Exadata?
48) How many Exadata wait events contained in 126.96.36.199 release?
There are 53 wait events are exadata specific events.
49) What is the difference between DBRM and IORM?
DBRM is the feature of database while IORM is the feature of storage server software.
50) Which ASM parameters are responsible for Auto disk management in Exadata?
_AUTO_MANAGE_MAX_ONLINE_TRIES — It controls maximum number of attempts to make disk Online
_AUTO_MANAGE_EXADATA_DISKS — It control auto disk management feature
_AUTO_MANAGE_NUM_TRIES — It controls maximum number of attempt to perform an automatic operation
51) How to enable Flashcache compression?
CellCLI> ALTER CELL flashCacheCompress=true
52) How many Exadata Storage Server Nodes are included in Exadata Database Machine X4-8?
14 storage nodes
53) What is client or public network in exadata?
Client or public network is used to established connectivity between database and application.
54) What are the steps involved for initial Exadata configuration?
Initial network preparation
Configure Exadata servers
Configure Exadata software
Configure database hosts to use Exadata
Configure ASM and database instances
Configure ASM disk group for Exadata
55) What is iDB protocol?
iDB stands for intelligent database protocol. It is a network based protocol which is responsible to communicate between storage cell and database server.
56) What is LIBCELL?
Libcell stands for Library Cell which is linked with Oracle kernel. It allows oracle kernel to talk with the storage server via network based instead of operating system reads and writes.
57) Which packaged is used by compression adviser utility?
58) What is the primary goal of storage index?
Storage indexes are a feature unique to the Exadata Database Machine whose primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan.
59) What is smart scan offloading?
Offloading and Smart Scan are two terms that are used somewhat interchangeably. Exadata Smart
Scan offloads processing of queries from the database server to the storage server.
Processors on the Exadata Storage Server process the data on behalf of the database SQL query. Only the data requested in the query is returned to the database server.
60) What is checkip and what the use of it?
Checkip is the OS level script which contains IP address and hostname which will be used by Exadata in configuration phase. It checks network readiness like proper DNS configuration, it also checks there is no IP duplication in the network by pinging it which not supposed to ping initially.
61) Which script is used to reclaim the disk space of unused operating system?
For Linux: reclaimdisks.sh
For Solaris: reclaimdisks.pl
62) How database server communicates to storage cell?
Database server communicates with storage cell through infiniband network.
63) Can I have multiple celldisk for one grid disk?
No. Celldisk can have multiple griddisk but griddisk cannot have multiple celldisk
64) How many FMods available on each flash card?
Four FMods (Flash Modules) are available on each flash card.
65) What is smart flash log?
Smart flash log is a temporary storage area on Exadata smart flash cache to store redoes log data.
66) Which parameter is used to enable and disable the smart scan?
67) How to check infiniband topology?
We can verify infiniband switch topology by executing verify-topology script from one of our database server.
68) Can we use HCC on non-exadata environment?
No, HCC is only available data stored on Exadata storage server.
69) What is resource plan?
It is collection of plan directives that determines how database resources are to be allocated.
70) What is DBFS?
DBFS stands for Database File system which can be built on ASM disk group using database tablespace.
71) What is the purpose of infiniband spine switch?
Spine switch is used to connect multiple exadata database machines.
72) What is offload block filtering?
Exadata storage server filters out the blocks that are not required for the incremental backup in progress so only the blocks that are required for the backup are sent to the database.
73) Which protocol used by ASR to send notification?
74) Is manually intervance possible in storage index?
75) What are the options to update cell_flashcache for any object?
76) What is the default size of smart flash log?
512MB per module.
Each storage cell having 4 modules so its 4X512 MB per CELL
77) What is flash cache and how it works?
The flash cache is a hardware component configured in the exadata storage cell server which delivers high performance in read and write operations.
Primary task of smart flash cache is to hold frequently accessed data in flash cache so next time if same data required than physical read can be avoided by reading the data from flash cache.