Oracle技术分享 ORA-01145异常

数据库：oracle 11.2.0.4

系统：centos 7.9

问题描述：将数据文件users02.dbf离线时，出现“ORA-01145：除非启用介质恢复，否则不允许立即脱机”告警，如下所示：

SQL> alter database datafile 5 offline;

alter database datafile 5 offline

*

ERROR at line 1:

ORA-01145: offline immediate disallowedunless media recovery enabled

SQL> selectd.tablespace_name,v.file#,d.file_name,d.bytes/1024/1024,v.status,v.enabled,d.autoextensible,d.increment_byfrom dba_data_files d,v$datafile v where d.file_id=v.file#

TABLESPACE_NAME FILE# FILE_NAME D.BYTES/1024/1024 STATUS ENABLED AUT INCREMENT_BY

--------------- ------------------------------------------------------------ ----------------- ----------------- --- ------------

USERS 4/u01/app/oracle/oradata/leodb/users01.dbf 5 ONLINE READ WRITE YES 160

UNDOTBS1 3/u01/app/oracle/oradata/leodb/undotbs01.dbf 70 ONLINE READ WRITE YES 640

SYSAUX 2 /u01/app