1.删除文件

    1. [oracle@instance-ej1hspdt ~]$ cd /opt/oracle/oradata/ORCLCDB/
    2. [oracle@instance-ej1hspdt ORCLCDB]$ rm users01.dbf

    2.启动数据库到mount

    1. RMAN> startup force  mount;

    3.恢复表空间

    1. select   *  from v$dbfile;查询数据文件编号
    2. run{
    3. set newname  for datafile 12  to '/opt/oracle/oradata/ORCLCDB/user/users01.dbf';
    4. restore database;
    5. switch datafile  all;
    6. recover database;
    7. }
    8. alter database open;