256.622426913
2 +DATA/dw/datafile/sysaux.257.622426915
3 +DATA/dw/datafile/undotbs1.258.622426919
4 +DATA/dw/datafile/users.259.622426921
5 +DATA/dw/datafile/example.265.622427181
5 rows selected.
SQL> select name from v$controlfile;
NAME
----------------------------------------
+DATA/dw/controlfile/current.260.622427059
+RECOV/dw/controlfile/current.256.622427123
2 rows selected.
SQL> select member from v$logfile;
MEMBER
----------------------------------------
+DATA/dw/onlinelog/group_3.263.622427143
+RECOV/dw/onlinelog/group_3.259.622427145
+DATA/dw/onlinelog/group_2.262.622427135
+RECOV/dw/onlinelog/group_2.258.622427137
+DATA/dw/onlinelog/group_1.261.622427127
+RECOV/dw/onlinelog/group_1.257.622427131
6 rows selected.
Within the disk groups +DATA and +RECOV, we see that each of the database file types, such
as datafiles, control files, and online log files, has its own directory. Fully qualified ASM filenames
have the format
+
///..
where is the disk group name, is the database to which the file belongs,
is the Oracle file type, is information specific to the file type, and the pair
. ensures uniqueness within the disk group.
Automatic Storage Management is covered in Chapter 6.
72 Oracle Database 11g DBA Handbook
Oracle Installation Tablespaces
Table 3-2 lists the tablespaces created with a standard Oracle installation using the Oracle
Universal Installer (OUI); the EXAMPLE tablespace is optional; it is installed if you specify that
you want the sample schemas created during the installation dialogue.
Pages:
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171