How to Create Database using OMF parameter

In this article we are going to discuss How to Create Database using OMF parameter, we don’t need to create a location for Datafile, Controlfile, Tempfile, Redolog file, and RMAN backups, it all managed automatically.

There are three new parameter which is using for making new database.

• DB_CREATE_FILE_DEST (This parameter defines the location of the default file system directory for datafiles and temporary files)
• DB_CREATE_ONLINE_LOG_DEST_n (This parameter defines the location for redo log files and control file creation)
• DB_RECOVERY_FILE_DEST (This parameter defines the location for RMAN backups)

Table of Contents

• Lets Start Creating omf Database
  • Create parameter file using OMF Parameters
  • STARTUP NOMOUNT

Lets Start Creating omf Database

create some mandatory directory for Database using the below commands, In my case, I’m going to create a database name with Acer.

#mkdir /u01/acer
#mkdir -p /u01/acer/flash_recoevry_area
#mkdir -p /u01/acer/pfile

Create parameter file using OMF Parameters

Create pfile to start OMF database as mansion below.

$vim /u01/acer/pfile/init.ora

db_name=acer
db_block_size=8192
db_cache_size=70m
shared_pool_size=100m
db_create_file_dest=/u01/acer
db_create_online_log_dest_1=/u01/acer
db_recovery_file_dest=/u01/acer/flash_recovery_area
db_recovery_file_dest_size=2g
compaible=11.2.0.3
remote_login_passwordfile=exclusive

Now export your ORACLE_SID using the export command. After that login to your Database using sys user, using the below commands.

$export ORACLE_SID=acer
$sqlplus sys/sys as sysdba

STARTUP NOMOUNT

start your database nomount using below command.

startup nomount pfile=/u01/acer/pfile/init.ora;

Now run the CREATE DATABASE command, once you run this command all Datafiles, Controlfiles, and Redo log files will be created automatically.

create database;

Now run catalog and catproc command for creating pl/sql objects and permissions.

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

Now your OMF Database has been created successfully, it is ready to use. But EM (Enterprise Manager) and Listener not configured right now. Configured as per your requirement.