Hello..

One of the undo datafile is missing from our filesystem and i needed some help to figure out how to fix it.. I know file 52 is an undo datafile because from where it was copied from..the dba did a refresh from prod to uat but he must have used the old create controlfile script and left out undo03.dbf

alert.log is showing this error message.
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 52 cannot be read at this time
ORA-01111: name for data file 52 is unknown - rename to correct file
ORA-01110: data file 52: '/apps/oracle/product/9.2.0_64bit/dbs/MISSING00052'
*** 2006-01-27 18:37:39.943



SQL> select file#, name, status from v$datafile where file#=52;

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
52
/apps/oracle/product/9.2.0_64bit/dbs/MISSING00052
RECOVER