Create an OMF Control File that is FRA managed on an existing database

Creating an OMF Control File in the FRA on an existing Database

(These instructions assumes that you are running your database in archivelog mode and have configured a FRA)

----- Create Control File Location -----

1.) On the OS create a dir %FLASH_RECOVERY_AREA%\%DB_NAME%\CONTROLFILE

2.) With the database open identify the location of the control files “select * from v$controlfile;”

3.) Shutdown database “Shutdown Immediate”

4.) Exit out of sql prompt

     

----- Generate OMF Control File Name -----

5.) Connect to RMAN “RMAN target=/”

6.) Startup mount

7.) Run the following command “ backup as copy current controlfile format 'o1_mf_%u_.ctl' ”

a. This will generate an error