Specifying Oracle-Managed Files at Database Creation (76)

You can minimize the number of clauses and parameters that you specify in your
CREATE DATABASE statement by using the Oracle-managed files feature. You do this
either by specifying a directory in which your files are created and managed by Oracle
Database, or by using Automatic Storage Management. When you use Automatic
Storage Management, you specify a disk group in which the database creates and
manages your files, including file redundancy and striping.

By including any of the initialization parameters DB_CREATE_FILE_DEST,
DB_CREATE_ONLINE_LOG_DEST_n, or DB_RECOVERY_FILE_DEST in your
initialization parameter file, you instruct Oracle Database to create and manage the
underlying operating system files of your database. Oracle Database will
automatically create and manage the operating system files for the following database
structures, depending on which initialization parameters you specify and how you
specify clauses in your CREATE DATABASE statement:
■ Tablespaces
■ Temporary tablespaces
■ Control files
■ Redo log files
■ Archive log files
■ Flashback logs
■ Block change tracking files
■ RMAN backups

使用OMF
1. 可以指定路徑 , 或者使用OMF, 或者ASM
2. 使用OMF, 指定DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n,
DB_RECOVERY_FILE_DEST 任意一個 , Oracle在建立表空間 , 臨時表空間時 將在指定的目錄下
建立相關的作業系統檔案

[@more@]