9.5. Using ASM Filenames
All ASM files are OMF, so the details of the actual filename within the disk group are not needed for most administrative functions. When an object in an ASM disk group is dropped, the file is automatically deleted. Certain commands will expose the actual filenames, such as ALTER DATABASE BACKUP CONTROLFILE TO TRACE, as well as some data dictionary views. For example, the data dictionary view VSDATAFILE shows the actual filenames within each disk group:
SQL> select file#, name, blocks from v$datafile; ------- -------------------------------------- --------- FILE# NAME BLOCKS 1 +DATAl/racO/datafile/system.256.1 57600 2 +DATAl/racO/datafile/undotbsl.258.1 3840 3 +DATAl/racO/datafile/sysaux.257.1 44800 4 +DATAl/racO/datafile/users.259.1 ...
Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
