--使用alter database create datafile恢复丢失数据文件
SYS@PROD3> create table t tablespace t1 as select * from all_objects where rownum<100;
Table created.
SYS@PROD3> commit;
Commit complete.
SYS@PROD3> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@PROD3> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ocm1 ~]$ rm -rf /home/oracle/db1/t1.dbf --模拟删除数据文件
[oracle@ocm1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 18 20:18:03 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@PROD3> startup
ORACLE instance started.
Total System Global Area 958341120 bytes
Fixed Size 1348972 bytes
Variable Size 281021076 bytes
Database Buffers 671088640 bytes
Redo Buffers
使用alter database create datafile恢复丢失数据文件
最新推荐文章于 2023-03-20 15:10:32 发布