Exadata Software - Oracle Exadata Recipes: A Problem-Solution Approach - page 36

[oracle@cm01dbm01 ~]$ srvctl config database -d dwprd
Database unique name: dwprd
Database name: dwprd
Oracle home: /u01/app/oracle/product/11.2.0.3/dbhome_1
Oracle user: oracle
Spfile: +DATA_CM01/dwprd/spfiledwprd.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: dwprd
Database instances: dwprd1,dwprd2
Disk Groups: DATA_CM01,RECO_CM01
Mount point paths:
Services:
Type: RAC
Database is administrator managed
[oracle@cm01dbm01 ~]$ srvctl stop database -d dwprd
[oracle@cm01dbm01 ~]$ srvctl start database -d dwprd
[oracle@cm01dbm01 ~]$ srvctl status database -d dwprd
Instance dwprd1 is running on node cm01dbm01
Instance dwprd2 is running on node cm01dbm02
[oracle@cm01dbm01 ~]$
All database storage on Exadata resides in Oracle Automated Storage Management, or Oracle ASM. You can run
the query in Listing 2-1 to list the data files for the tablespaces in an Exadata database:
Listing 2-1. lst02-01-dbfiles.sql
SQL> select 'Data Files' type,substr(name,1,instr(name,'/',1,2)-1) asm_dg,count(*) cnt
from v$datafile
group by substr(name,1,instr(name,'/',1,2)-1)
union
select 'Temp Files',substr(name,1,instr(name,'/',1,2)-1) asm_dg, count(*) cnt
from v$tempfile
group by substr(name,1,instr(name,'/',1,2)-1)
union
select 'Redo Member',substr(member,1,instr(member,'/',1,2)-1) asm_dg, count(*) cnt
from v$logfile
group by substr(member,1,instr(member,'/',1,2)-1)
/
File Type ASM Disk Location Number of Files
-------------- -------------------- ---------------
Data Files +DATA_CM01/visx 239
Redo Member +RECO_CM01/visx 6
Temp Files +DATA_CM01/visx 5
You can see that in this database, the data files are stored in both the +DATA_CM01 and +RECO_CM01 ASM
disk groups.