Re: CREATE DATABASE (..) LOGFILE question

Probably Oracle forces you to mirror the logfiles. In this case the statement is
create database
 test DATAFILE '/u7/test.db' SIZE 600M LOGFILE group 1 ('/u7/test1a.log','/u7/test1b.log') SIZE 6M -- 60M is way too big , group 2 ('/u7/test2a.log','/u7/test2b.log') size 6M You need at least two redo log file groups. The filespecs as they are now take care of mirroring. If you do that, ideally those files should reside on two different physical drives. If you don't want mirroring at all, you probably will need to include maxlogmembers 1
The default is 2, and this is probably the reason why you are getting ora-1518.

Hth,

Sybrand Bakker, Oracle DBA

Surf the World wrote in message <7j9c21$m41$1_at_dailyplanet.wam.umd.edu>...
>Hello All-
>
>Forgive my ignorance as I'm a newcomer to the realm of installing and
>administering Oracle, but I'm lost and had no where else to turn to.
>
>I'm running Linux and have created my init<SID>.ora file and have
>successfully startup'ed it with the svrmgrl. However, when I try to
>create my test database using the following command:
>
>CREATE DATABASE test DATAFILE '/u7/test.db' SIZE 600M LOGFILE
>('/u7/test.log') SIZE 60M
>
>I get:
>ORA-01518: CREATE DATABASE must specify more than one log file
>
>
>I have tried several variations on the above logfile entry, including
>things like ('/u7/test.log' SIZE 60M, '/u7/test2.log' SIZE 60M) and have
>also tried using the MAXLOGFILES variable. I couldn't get it to work.
>
>I have several fairly heavy Oracle books that're good for Oracle research
>(as well as smashing bugs) but none of them give a good concrete example
>of the CREATE DATABASE command. Similarly, the Oracle 8 documentation for
>the ORA-01518 error message isn't too informative.
>
>One of the bug-squashing books I have mentioned that "File specifications
>for log files depend on the operating system." I take that to mean that
>under *nix systems you have a '/blah/nowhere' logfile format and WinX
>boxes have a "C:\blah\nowhere' format.
>
>If someone could gimme a pointer on this, I would be grateful.
>
>
>
>------------
>En Taro Adun
>Chris Blunck
>
Received on Fri Jun 04 1999 - 15:52:12 CDT