Datasheet

Overview of ASM Data Dictionary Views
29
TABLE 1.3 ASMCMD Commands (c o n tin u ed)
Command Purpose Example
md_restore Restores ASM metadata. md_restore –t full –g dgroup1
–i /tmp/dgbackup070222
pwd
Locates where you are on the ASM
directory tree.
pwd
remap
Remaps a range of physical blocks
on disk.
remap data data_0003 6000-8000
rm
Removes an ASM directory or file. rm Current.258.613087119
rm current*
rm -r current*
rmalias
Removes an ASM alias. rmalias +cooked_dgroup1/11gDB/
datafile/alias_tbs_01.dbf
Overview of ASM Data Dictionary Views
You were introduced to Oracle’s data dictionary as a part of your OCA studies. Recall that
the data dictionary provides views on the operation and performance of the database. The
data dictionary also provides a great deal of metadata about database structures. Several data-
dictionary views are available for use with ASM. Table 1.4 lists those views and gives descrip-
tions of their use.
You can learn more about the Oracle data dictionary in Chapter 2, “Performing Oracle
User-Managed Backups.
TABLE 1.4 ASMCMD Commands
View Name In ASM Instance In Database
V$ASM_DISKGROUP This view will describe a
given disk group.
This view contains a single
row for each ASM disk group
that is mounted by the local
ASM instance. Note that dis-
covery will occur each time
you query this view. This can
have performance impacts.
95134c01.indd 29 1/28/09 9:43:44 AM