SOLVED

ORA-01145: Offline Immediate Disallowed Unless Media Recovery Enabled

Asked by OracleDba••13 views•oracle
1
2
3
4
5
ORA-01145: Offline Immediate Disallowed Unless Media Recovery Enabled

PROBLEM:

While making a datafile offline, we got this error.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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!
OracleDba•

Post Your Solution