When Oracle ASM creates a data file for a permanent tablespace (or a temporary file for a temporary tablespace), the data file is set to auto-extensible with an unlimited maximum size and 100 MB default size. The following statement can be run at the SQL prompt: SQL> CREATE DATABASE orcl

The following initialization parameter settings are included in the initialization parameter file: DB_CREATE_FILE_DEST = +data The control file in data is the primary control file. 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). If automatic undo management mode is enabled, then an undo tablespace data file in directory data. The tablespace is locally managed with automatic segment-space management.Ī multiplexed online redo log with two online log groups, one member of each in data and fra (fast recovery area).

This example creates a database with the following Oracle ASM files:Ī SYSTEM tablespace data file in disk group data.Ī SYSAUX tablespace data file in disk group data. The following example shows the use of the CREATE DATABASE statement, where database files are created and managed automatically by Oracle ASM. 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 recommended method of creating your database is to use Database Configuration Assistant (DBCA).

Table plus create database