Missing a datafile from the controlfile during a clone.
I recently cloned a production database to dev database and during the process, missed including a datafile in the control file. I copied teh control file but has not made it part of the database thru control file.
When I select from dba_data_files, the datafile for one of the tablespace is of course showing up as "missing".
I thought I can fix it by doing a shutdown, delete controlfiles & logfiles, adding in the datafile, re-issuing the CREATE CONTROLFILE statement but while the other datafiles are marked with the development db name in the header, this lone datafile still referes to the production db name.
Is tehre a way to make this datafile a part of this database? I can't reclone as the developemt team wants it from that date when the clone was made ( 3 days ago). I can redo from the backup etc., but was wondering if tehre is a way to just add this datafile.
Oracle 10.2.0.4 on HP-UX 11i. Development database is in noarchivelog mode.
Thank you.