-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Oracle 11g R1 / R2 Real Application Clusters Handbook
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 group dgroup1.
A SYSAUX tablespace datafile in disk group dgroup1. 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 and dgroup2 (flash recovery area).
If automatic undo management...
Change the font size
Change margin width
Change background colour