Oracle Managed Files : Database Creation

Follow these steps to create a simple OMF database

Oracle-managed files greatly simplifies the administration of an Oracle database. Oracle-managed files removes the need to directly manage the operating system files comprising an Oracle database. You specify operations in terms of database objects rather than filenames.

1. Export a SID for your OMF database 

]$export ORACLE_SID.=omf

2. Create parameter file and include the following parameters

 Included in the initialization parameter file:

db_name=omfdb
DB_CREATE_FILE_DEST = '/disk1/oradata/ omfdb'
DB_CREATE_ONLINE_LOG_DEST_1 = '/disk1/oradata/omfdb'

Note : all the datafiles ,logfiles and controlfiles will be created in /disk1/oradata/omfdb location.

 3. Make directory structure 

]$mkdir   -p /disk1/oradata/omfdb

4. Create Database Statement:
In nomount state of database issue below statement

SQL> CREATE DATABASE;

database created