sql 'alter tablespace users offline for recover';

--可选set newname for datafile 4 to '$ORACLE_BASE/product/10.2.0/oradata/oralife/user01.dbf';

restore tablespace users;

recover tablespace users;

sql 'alter tablespace users online';

alter database datafile 5 offline;

--可选set newname for datafile 4 to '$ORACLE_BASE/product/10.2.0/oradata/oralife/user01.dbf';

restore datafile 5;

recover datafile 5;

sql 'alter database datafile 5 online';

ITPub博客

rman恢复数据文件恢复表空间