The ls command shows the three disk groups in the ASM
instance used throughout this chapter, +DATA, +DATA2, and +RECOV.
Note also that the du command only shows the used disk space and total disk space used
across mirrored disk groups; to get the amount of free space in each disk group, use the lsdg
command instead.
In this example, you want to find all files that have the string user in the filename:
ASMCMD> pwd
+
ASMCMD> find . user*
+DATA/DW/DATAFILE/USERS.259.627432977
+DATA/DW/DATAFILE/USERS2.267.627782171
+DATA/purch/users.dbf
+DATA2/DW/DATAFILE/USERS3.256.627786775
ASMCMD> ls -l +DATA/purch/users.dbf
Type Redund Striped Time Sys Name
N users.dbf =>
+DATA/DW/DATAFILE/USERS.259.627432977
ASMCMD>
Note the line with +DATA/purch/users.dbf: the find command finds all ASM objects; in this
case, it finds an alias as well as datafiles that match the pattern.
Finally, you can perform file backups to external file systems or even other ASM instances. In
this example, you use the cp command to back up the database??™s SPFILE to the /tmp directory on
the host??™s file system:
ASMCMD> pwd
+data/DW
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
Chapter 4: Physical Database Layouts and Storage Management 119
spfiledw.ora
ASMCMD> cp spfiledw.ora /tmp/BACKUPspfiledw.ora
source +data/DW/spfiledw.ora
target /tmp/BACKUPspfiledw.ora
copying file(s)...
file, /tmp/BACKUPspfiledw.ora, copy committed.
Pages:
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223