Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01184: logfile group 1 already exists

276231May 17 2002 — edited Dec 23 2011

After startup nomount, I try to create database as follows:

CREATE DATABASE SISDEV04
LOGFILE GROUP 1 '/sisdev04/dbs/log01a.dbf'
SIZE 10M
, GROUP 1 '/sisdev04/dbs/log01b.dbf'
SIZE 10M
, GROUP 2 '/sisdev04/dbs/log02a.dbf'
SIZE 10M
, GROUP 2 '/sisdev04/dbs/log02b.dbf'
SIZE 10M
NOARCHIVELOG
CHARACTER SET ZHT16BIG5
NATIONAL CHARACTER SET ZHT16BIG5
DATAFILE '/sisdev04/dbs/system01.dbf'
SIZE 210M AUTOEXTEND OFF
, '/sisdev04/dbs/rbs01.dbf'
SIZE 105M AUTOEXTEND OFF
, '/sisdev04/dbs/temp01.dbf'
SIZE 105M AUTOEXTEND OFF
, '/sisdev04/dbs/users01.dbf'
SIZE 1050M AUTOEXTEND OFF
, '/sisdev04/dbs/ts_index_ivr01.dbf'
SIZE 105M AUTOEXTEND OFF
, '/sisdev04/dbs/ts_ivr01.dbf'
SIZE 21M AUTOEXTEND OFF
, '/sisdev04/dbs/ts_ems01.dbf'
SIZE 21M AUTOEXTEND OFF
, '/sisdev04/dbs/ts_index_ems01.dbf'
SIZE 21M AUTOEXTEND OFF
;

However, I receive such error:

ORA-01501: CREATE DATABASE failed
ORA-01184: logfile group 1 already exists

I have checked that there is no files in '/sisdev04/dbs/' before I issue the command, what can I do?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2012

Added on May 17 2002

#general-database-discussions

6 comments

8,168 views