How Are ASM Files Used in the Database?
The
next topic to explore is how to create a database using ASM
files.
Using ASM to Create a Database
Oracle recommends the use of the Database
Configuration Assistant (DBCA) to create a new database.
However,
one can be created
manually
with minimal user
intervention using ASM files
as the following example shows.
Use the following initialization parameter
settings in init.ora file:
DB_CREATE_FILE_DEST = +dskgrp01
DB_RECOVERY_FILE_DEST = +dskgrp02
CONTROL_FILES = +dskgrp03
DB_CREATE_ONLINE_LOG_DEST_1 = +dskgrp04
DB_CREATE_ONLINE_LOG_DEST_2 = +dskgrp05
LOG_ARCHIVE_DEST = +dskgrp02
Issue the following command at the SQL
prompt to create a new database:
CREATE DATABASE QASALES ;
This command will create a database with
SYSTEM and SYSAUX tablespaces in the disk group dskgrp01. It
will create a multiplexed online redo with two log groups
