rman recovery

list backup;

 

restore datafile '/u02/oradata/cuddle/users01.dbf';

recover datafile '/u02/oradata/cuddle/users01.dbf';

 

select TABLESPACE_NAME,STATUS from dba_tablespaces;

select * from dba_tablespaces;

 

select FILE#,STATUS,ENABLED,NAME from v$datafile;

select * from v$datafile;

 

alter database datafile '/u02/oradata/cuddle/users01.dbf' online;

alter tablespace USERS online;