Quick demo of OMF and UMF.

       ###################################

       #         LOGIN as Oracle        #

       ###################################

[oracle@OEL61A admin]$ ps -ef | grep pmon

grid      3176     1  0 Dec12 ?        00:00:18 asm_pmon_+ASM

oracle    8176   677  0 15:19 pts/6    00:00:00 grep pmon

oracle   22351     1  0 Dec12 ?        00:00:17 ora_pmon_demo

[oracle@OEL61A admin]$ . oraenv

 ORACLE_SID = [demo] ? demo

[oracle@OEL61A admin]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 13 15:19:14 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

SQL> select name from v$database;

NAME

---------

DEMO

SQL> show parameter db_create_file_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- -------

db_create_file_dest                  string      +DATA

SQL> select name from v$datafile;

NAME

--------------------------------------------

+DATA/demo/datafile/system.273.801569117

+DATA/demo/datafile/sysaux.274.801569125

+DATA/demo/datafile/undotbs1.275.801569131

+DATA/demo/datafile/users.277.801569135

+DATA/demo/datafile/apps_tbs.278.801569853

+DATA/demo/datafile/indx_tbs.279.801569915

SQL> --Please note the changes to FRA are effective only in the memory

SQL> alter system set db_create_file_dest='+FRA' scope=MEMORY; 

System altered.

SQL> show parameter db_create_file_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest                  string      +FRA

SQL> --No file name is specified for the below :

SQL> create tablespace omf_tes;

Tablespace created.

SQL> select name from v$datafile;

NAME

-------------------------------------------

+DATA/demo/datafile/system.273.801569117

+DATA/demo/datafile/sysaux.274.801569125

+DATA/demo/datafile/undotbs1.275.801569131

+DATA/demo/datafile/users.277.801569135

+DATA/demo/datafile/apps_tbs.278.801569853

+DATA/demo/datafile/indx_tbs.279.801569915

+FRA/demo/datafile/omf_test.283.801933663  <---This is the new file created

       ###################################

       # LOGIN as GRID on another Session#

       ###################################

login as: grid

Access denied

grid@10.184.86.86's password:

[grid ~]$ ps -ef | grep pmon

grid      3176     1  0 Dec12 ?        00:00:18 asm_pmon_+ASM

grid      8456  8429  0 15:22 pts/7    00:00:00 grep pmon

oracle   22351     1  0 Dec12 ?        00:00:17 ora_pmon_demo

[grid ~]$ . oraenv

ORACLE_SID = [+ASM] ? +ASM

The Oracle base remains unchanged with value /u01/app/grid

[grid ~]$ asmcmd

ASMCMD> cd +FRA

ASMCMD> cd demo

ASMCMD> ls

ARCHIVELOG/

CONTROLFILE/

DATAFILE/

ONLINELOG/

ASMCMD> cd DATAFILE

ASMCMD> ls

OMF_TEST.283.801933663 <--- We could able to see the file created in our storage

       ###################################

       #         Back to Oracle Session  #

       ###################################

SQL> drop tablespace omf_test;

Tablespace dropped.

       ###################################

       #       Back GRID  Session         #

       ###################################

ASMCMD> pwd

+FRA/demo/DATAFILE

ASMCMD> ls                 <--- The File is auto matically deleted

ASMCMD-8002: entry 'DATAFILE' does not exist in directory '+FRA/demo/'

ASMCMD>

       ###################################

       #      Back to Oracle Session     #

       #      DEMO of USER MANAGED FILES #

       ###################################

SQL> --This time we are specifying a file on LOCAL Storage.

SQL> create tablespace omf_test datafile '/u01/app/oracle/admin/demo/datafile/omf_test.dbf' size 100k;

Tablespace created.

SQL> select name from v$datafile ;

NAME

-------------------------------------------------

+DATA/demo/datafile/system.273.801569117

+DATA/demo/datafile/sysaux.274.801569125

+DATA/demo/datafile/undotbs1.275.801569131

+DATA/demo/datafile/users.277.801569135

+DATA/demo/datafile/apps_tbs.278.801569853

+DATA/demo/datafile/indx_tbs.279.801569915

/u01/app/oracle/admin/demo/datafile/omf_test.dbf   

SQL> drop tablespace omf_test;

Tablespace dropped.

#File on OS even after deleting on the Unix File System

[oracle ~ datafile]$ ls -lt

total 112

-rw-r----- 1 oracle asmadmin 114688 Dec 13 15:36 omf_test.dbf