PROBLEM:

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

 

SOLUTION:

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.