Study Guide for 1Z0-027 Certification

Exadata Database Machine Overview

• Identify the benefits of using Database Machine for different application classes
• Describe the integration of the Database Machine with Oracle Database Clusterware and ASM
• Describe Exadata Storage Server and the different Database Machine configurations
• Describe the key capacity and performance specifications for Database Machine
• Describe the key benefits associated with Database Machine

Exadata Database Machine Architecture

• Describe the Database Machine network architecture
• Describe the Database Machine software architecture
• Describe the Exadata Storage Server storage entities and their relationships
• Describe how multiple Database Machines can be interconnected
• Describe site planning requirements for Database Machine
• Describe network requirements for Database Machine

Key Capabilities of Exadata Database Machine

• Describe the key capabilities of Exadata Database Machine
• Describe the Exadata Smart Scan capabilities
• Describe the capabilities of hybrid columnar compression
• Describe the capabilities and uses of the Smart Flash Cache
• Describe the capabilities of the Smart Flash Log
• Describe the purpose and benefits of Storage Indexes
• Describe the capabilities and uses of Exadata Secure Erase

Exadata Database Machine Initial Configuration

Configure Exadata Flash Disk as Grid Disk

We can use Flash Cache as Grid Disk to create the ASM disk group and can keep the database on flash disk but this is not reccomended solution as flash cache performs better to cache frequently access data rather than creating database on it.

If you want put your database on Flash cache than below are the steps to configure FLASH CACHE as ASM disk.

Steps:

1. Drop existing flash cache

2. Create flashcache with required size

3. Create grid disk from Flash Cache

4. Create ASM disk group on top of the Flash Griddisk

5. Put your database on ASM disk group which has been configured from Flash grid disk

Step-1

CellCLI>drop flashcache

If it gives error like below

CELL-02769: Cannot complete flash cache drop on: FD_03_ex01cceladm03. 

Received error: CELL-02732: There may be data not synchronized to the grid disks (dirty data) in flash cache.

Use ALTER FLASHCACHE to flush the dirty data and to stop caching, and then retry the command.

This error comes because flash cache mode has been configured as writeback hence some of the dirty data are still not written to the grid disks.

To overcome from this error flush all the flashcache

CellCLI>  alter flashcache all flush

Flash cache exa1cel01_FLASHCACHE altered successfully

CellCLI> drop flashcache 

Flash cache exa1cel01_FLASHCACHE successfully dropped 

Step-2

How to move a datafile from one ASM disk group to another

Explaining how to move datafile from one ASM DG to another.

Note: Database must be in archivelog mode before doing this activity.

1. Find the name of the datafile that you're going to migrate

SQL> SELECT file_name FROM dba_data_files;

FILE_NAME

----------------------------------------------

+DATA/mydb/datafile/system.312.825938943

+DATA/mydb/datafile/sysaux.313.825938957

+DATA/mydb/datafile/undotbs1.314.825938971

+DATA/mydb/datafile/undotbs2.315.825938991

+DATA/mydb/datafile/users.317.825939005

+DATA/mydb/datafile/mydb01.dbf

+RECO/mydb/datafile/mydb_tbs.7665.836338453 <Moving this file from +RECO to +DATA

7 rows selected.

2. Take the datafile offline

SQL> Alter database datafile '+RECO/mydb/datafile/mydb_tbs.7665.836338453' offline;

Database altered.

3. Copy the file using RMAN: