SQL> create tablespace ts1 datafile '/tmp/ts1.dbf' size 8M;

Tablespace created.

SQL> create table ts1_t1 (id number) tablespace ts1;

Table created.

SQL> alter tablespace ts1 offline;

Tablespace altered.

SQL> !cp /tmp/ts1.dbf /u02/oradata/ts1.dbf

SQL> alter database rename file  '/tmp/ts1.dbf' to '/u02/oradata/ts1.dbf';

Database altered.

SQL> recover datafile '/u02/oradata/ts1.dbf';
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required


SQL> alter tablespace ts1 online;

Tablespace altered.

SQL>