My Oracle Support Banner

How To Turn OMF ON or OFF (Doc ID 1369579.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.
*** Checked for relevance on 12-Apr-2016 ***

Goal

How to clarify whether OMF (Oracle Managed Files) is ON or OFF?
Can it be turned off?

This may for instance be relevant for setting up a physical standby database where an 'alter database create standby controlfile...' may show messages in the alert log like the following:

...
WARNING: OMF is enabled on this database. Creating a physical
standby controlfile, when OMF is enabled on the primary
database, requires manual RMAN intervention to resolve OMF
datafile pathnames.
NOTE: Please refer to the RMAN documentation for procedures
describing how to manually resolve OMF datafile pathnames.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.