oracle version:10.1.0.2
O.S:AIX5.2
Backup S/W:Netvault

Hi,

I have lost the undo tablespace in our database.I restored the tablespace from the latest backup,After restoring the tablespace when I tried to recover the tablespace,it is asking for the first redo log file that we dont have in the backup.

The database is in mount state, But all the datafiles are online.

Is there any way we can get rid of this situation
This is our test database.We have full backup taken last week.

snapshots taken:

SQL> recover datafile '/u01/oradata/testdb/undotbs01.dbf';
ORA-00279: change 5492 generated at 02/17/2006 17:47:04 needed for thread 1
ORA-00289: suggestion : /u01/arch/sameer/1_1_582659173.dbf
ORA-00280: change 5492 for thread 1 is in sequence #1

Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/u01/arch/testdb/1_1_582659173.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3



SQL> select name,status from v$datafile;

NAME STATUS
----------------------------------- -------
/u01/oradata/testdb/system01.dbf SYSTEM
/u01/oradata/testdb/undotbs01.dbf ONLINE
/u02/oradata/testdb/sysaux01.dbf ONLINE
/u01/oradata/testdb/test01.dbf ONLINE


we dont have this archive log file "1_1_582659173.dbf'"
This was the first log file.


Any ideas.