While making a datafile offline, got below error.


SQL> ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline;
ALTER database datafile ‘/export/home/oracle/user02.dbf’ offline
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled



To make a datafile offline, archive mode need to be enabled.


Below are steps for enabling archive mode:

Now try to make the datafile offline.