oracle12c offline-online表空间数据文件（noarchivelog）

非归档模式下

1、离线数据文件

?

1	alter database datafile '/u01/app/oracle/oradata/orcl/cc2.dbf' OFFLINE FOR DROP;

结果显示：

2、使数据文件在线

3、rman介质恢复数据文件8

?

1 2 3 4 5 6 7 8 9 10 11 12

[oracle@deam orcl]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Fri Dec 31 15:51:07 2021 Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved. connected to target database: ORCL (DBID=1543646389) RMAN> recover DATAFILE 8; Starting recover at 31-DEC-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=248 device type=DISK starting media recovery media recovery complete, elapsed time: 00:00:00 Finished recover at 31-DEC-21

4、再次online数据文件

5、结果显示