Home » RDBMS Server » Server Administration » using OMF database creation (oracle 9i, Windows XP)
using OMF database creation [message #345986] Fri, 05 September 2008 08:19 Go to next message
Messages: 4
Registered: September 2008
Junior Member
Hi All,

I am creating database using OMF using follwing parameter in parameter file.

db_create_file_dest = c:\oracle\oradata\test
db_create_online_log_dest_1 = c:\oracle\oradata\test\u01
db_create_online_log_dest_2 = c:\oracle\oradata\test\u02
db_create_online_log_dest_3 = c:\oracle\oradata\test\u03

giving command in startup nomount phase
create database test;

This command creates my test database successfully by creating 3 control files in each destination 1,2 & 3.
But, creating 2 groups with 2 memebers each in destination 1 and 2 only.

It is not supposed to create 3 groups?

What is the meaning of adding log_dest_3?

I am new to ORAcle DBA. Any help/explanation would be apprecited.

Purvi Shah
Re: using OMF database creation [message #346301 is a reply to message #345986] Mon, 08 September 2008 02:38 Go to previous message
Messages: 106
Registered: December 2005
Senior Member
check the limit on the number of loggroups that you have put in your controlfiles.
Previous Topic: swap space
Next Topic: ORA-04031: unable to allocate 4192 bytes of shared memory
Goto Forum:

Current Time: Thu Jul 27 23:51:42 CDT 2017

Total time taken to generate the page: 0.06292 seconds