The recommended method of creating your database is to use Database Configuration Assistant (DBCA). However, if you create your database manually using the CREATE DATABASE statement, then Oracle ASM enables you to create a database and all of its underlying files with a minimum of input.
The following example shows the use of the CREATE DATABASE statement, where database files are created and managed automatically by Oracle ASM. This example creates a database with the following Oracle ASM files:
A SYSTEM tablespace data file in disk group data.
A SYSAUX tablespace data file in disk group data. The tablespace is locally managed with automatic segment-space management.
A multiplexed online redo log with two online log groups, one member of each in data and fra (fast recovery area).
If automatic undo management mode is enabled, then an undo tablespace data file in directory data.
If you do not specify a value for the CONTROL_FILES initialization parameter, then two control files, one in data and another in fra (fast recovery area). The control file in data is the primary control file.
The following initialization parameter settings are included in the initialization parameter file:
DB_CREATE_FILE_DEST = +data DB_RECOVERY_FILE_DEST = +fra DB_RECOVERY_FILE_DEST_SIZE = 10G
The following statement can be run at the SQL prompt:
SQL> CREATE DATABASE orcl;