Now you are going to discover another powerful way to manage and administer the ASM resources by means of using the Oracle SQL*Plus. This section requires more advanced knowledge of SQL to manage the ASM. You will need to carefully plan your tasks before executing them.
The recommended method of creating your database is to use the Database Configuration Assistant (DBCA). However, if you create your database manually using the CREATE DATABASE
statement, then ASM enables you to create a database and all of its underlying files with a minimum of input. You can create a database that uses the following ASM files:
A
SYSTEM
tablespace datafile in disk groupdgroup1
.A
SYSAUX
tablespace datafile in disk groupdgroup1
. 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
dgroup1
anddgroup2
(flash recovery area).If automatic undo management...