Monday , September 25 2017
Home / Oracle DBA / ORACLE MANAGED FILES (OMF)

ORACLE MANAGED FILES (OMF)

ORACLE MANAGED FILES (OMF)

  1. OMF gives flexibility in managing CRD files
  2. We can use OMF by setting below parameter
db_create_file_dest
db_create_online_log_dest                 dynamic parameters

COMMANDS

# To configure OMF parameters
SQL> alter system set db_create_file_dest=’/u02/prod’ scope=memory;
SQL> alter system set db_create_online_log_dest=’/u02/prod’ scope=memory;
Read More:
BIGFILE TABLESPACE
LOCAL Vs DICTIONARY managed tablespaces
ARCHIVELOG FILES

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *