Q

Creating a database on raw partition

I tried to create a database on raw partition with the command:

CREATE DATABASE RAW
LOGFILE '\.L:' SIZE 10M,
    '\.M:' SIZE 10M,
    '\.N:' SIZE 10M
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE '\.S:' SIZE 20M
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
and I got the error:
 
ORA-02165: invalid option for CREATE DATABASE
When I tried:
 
ALTER DATABASE ADD LOGFILE GROUP 4 ('\.J:')
on database that wasn't created on raw partition, it works. Does it mean I can't create a database on raw partition, just create tablespace or logfile and to add them to an existing database?

You should be able to create the DB on raw partition just fine. Before creating the database you need to prepare the partitions on which datafiles will be created. The size of the partitions should be greater (at least two Oracle blocks) than the datafile size that you are going to create. You can create the partitions using "format" command as root user. Once partitions are created, change the owner and group of raw partition to oracle and dba. If your raw partition is /dev/rdsk/c0t0d0s6

chown oracle:dba /dev/rdsk/c0t0d0s6 
Similarly for all the raw partitions. Note that the raw partition should be character device (and not block device).

Now, create the database with REUSE option for each datafile and logfile which are going to be on the raw partition.

For More Information


This was first published in December 2002

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close