Oracle Managed Files: setting the default file destination
Set DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n so that Oracle names and places datafiles, redo logs and control files automatically (OMF, non-ASM).
Oracle Managed Files (OMF) let the database create and name datafiles, redo log files and control files by itself, in directories defined by initialization parameters. The database then needs no file names in CREATE TABLESPACE or ALTER DATABASE ADD LOGFILE. For background, see Oracle Base: Oracle Managed Files.
Check the current destinations
show parameter db_create_file_dest
show parameter db_create_online_log_dest
Set the default destinations
ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u02/oradata' SCOPE=BOTH;
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata' SCOPE=BOTH;
| Parameter | Used for |
|---|---|
DB_CREATE_FILE_DEST |
datafiles and tempfiles created without a file name |
DB_CREATE_ONLINE_LOG_DEST_n |
online redo log members and control files created without a file name |
These parameters apply to files created after they are set. Existing non-OMF files stay where they are. Converting them is a separate procedure; see the conversion guide on thegeekdiary.