Restore and recover missing datafile and no backups available in 9i

 Hi all,

  My db is 9.2.0.4

  I have a case such as: My db is ARCHIVELOG MODE, but no RMAN backups of database and archivelog. Just remain archivelog files.

  And I lost some datafiles (not system datafile).

  Ok,  I know that from 10g+, with above case I can restore and recover datafile missing by:

  SQL> alter database datafile 10 offline immediate;

  

  And after that, retore datafile just missing

  RMAN> restore datafile 10; ---> 10g, Oracle creates missing datafile !

  ....

  SQL> alter database datafile 10 online;

  But in 9i, Oracle not creates missing datafile, and I used some script to recreate missing datafile:

  SQL> alter database datafile 10 offline immediate;