I have read that Oracle 11gR2 no longer supports storage of datafiles on raw devices. I am wondering if that is only true when using ASM or Oracle Restart. I am looking at installing a single instance database without* ASM or Oracle Restart. I want to use raw devices to store the datafiles. Is this possible or must I use ASM or file system if I want to use 11gR2? Thanks!
Check out the following document: 754305.1.
In release 11.2, the Oracle installer and DBCA (Database configuration assistant) will no longer support raw/block devices for database files. . In addition, there will no longer be raw/block device support for storing the OCR and Voting Disks for new installs. Customers who create a new 11.2 database will need to store their database files in either ASM, a file system, or on an NFS filer. RAC database files must be stored on ASM, a certified clustered file system, or a certifed NFS filer.
Customers who wish to create 11.2 databases on RAW must use the command line interfaces to create datafiles on RAW (i.e., CREATE DATABASE/TABLESPACE). Alternatively, they can create an 11.1 database and upgrade it to 11.2.
Edited by: A Tael on Jun 1, 2010 2:50 PM