LLI Wiki — My Digital Knowledge Base

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.

Mastodon LLIMastodon SocialFosstodon