Oracle 9i Recovery (Tablespace Recovery)

3) Tablespace Recovery:

The Recover Tablespace option is used to recover all datafiles needing recovery in a tablespace up to the point of failure, synchronizing them with the other datafiles (complete recovery only).

C:\> sqlplus "/ as sysdba"
SQL> startup mount
SQL> alter database datafile '/u03/oradata/PROD/devl_PROD_01.dbf' offline;
SQL> alter database open;
SQL> alter tablespace development offline;
SQL> ocopy /u03/oradata/prod1/devl_PROD* /u03/oradata/PROD
SQL> recover automatic tablespace development;
SQL> alter tablespace development online;
Note:- development is the tablespace_name

If a write error occurs on one of the datafiles when you offline a tablespace, use
"alter tablespace tsname offline temporary;". Then, you can run a recovery on the datafile.
If all datafiles in an offlined tablespace have write errors, use "alter tablespace tsname offline immediate;". Then, you can run a recovery on the tablespace.