ORA-01145: Offline Immediate Disallowed Unless Media Recovery Enabled - Learnomate Technologies

ANKUSH THAVALI
14 Dec, 2023
0 Comments
21 Secs Read

ORA-01145: Offline Immediate Disallowed Unless Media Recovery Enabled

PROBLEM: While making a datafile offline, we got this error.

SOLUTION: To make a datafile offline, archive mode need to be enabled.
Below are steps for enabling archive mode:

shutdown immediate;

startup mount

alter database archivelog;

alter database open;

archive log list

Now try to make the datafile offline.

SQL> ALTER database datafile '/data/app/oracle/oradata/PRIM/user02.dbf' offline;

Database altered.

Hope it Helps!