OMF (Oracle Manage Files) is a database feature, that simplifies tablespace creation. Using OMF, Oracle will automatically assign datafile names to tablespaces and automatically create and delete the required datafiles the operating-system level. It is introduced in Oracle 9i.
These are the parameter for this feature:
db_create_file_dest and db_create_online_log_dest_n.
The db_create_file_dest specifies, where the datafiles will be placed.
The db_create_online_log_dest_n specifies, where the online logs will be placed. Use 1,2,3 instead of n, when you want to have 3 members in each group.
Example:
How to convert NON-OMF to OMF files ( Oracle Managed File conversion - NON-ASM ) (Doc ID 2182089.1)
These are the parameter for this feature:
db_create_file_dest and db_create_online_log_dest_n.
The db_create_file_dest specifies, where the datafiles will be placed.
The db_create_online_log_dest_n specifies, where the online logs will be placed. Use 1,2,3 instead of n, when you want to have 3 members in each group.
Example:
db_create_file_dest='/oracle/oradata' db_create_online_log_dest_1='/oracle/oradata' db_create_online_log_dest_2='/oracle/oradata
How to convert NON-OMF to OMF files ( Oracle Managed File conversion - NON-ASM ) (Doc ID 2182089.1)
No comments:
Post a Comment