实验步骤:
1.手工备份example表空间的数据文件;
2.除备份的文件;
3.手工恢复被删除的文件;
操作如下:
(1) 查看example表空间所包含的文件;
SYS@GMDBA> set lines 200
SYS@GMDBA> col file_name for a45
SYS@GMDBA> select file_id,file_name,tablespace_name from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME
---------- --------------------------------------------- ------------------
1 /u01/app/oracle/oradata/GMDBA/system01.dbf SYSTEM
2 /u01/app/oracle/oradata/GMDBA/sysaux01.dbf SYSAUX
3 /u01/app/oracle/oradata/GMDBA/undotbs01.dbf UNDOTBS1
4 /u01/app/oracle/oradata/GMDBA/users01.dbf USERS
5 /u01/app/oracle/oradata/GMDBA/example01.dbf EXAMPLE
6 /u01/app/oracle/oradata/GMDBA/test01.dbf TEST
7 /u01/app/oracle/oradata/GMDBA/test02.dbf TEST
7 rows selected.
(2) 将表空间至于热备状态;