- 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.