If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Missing log files during recovering undo tablespace

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.

Either way, you're going to have to restore your last backup. If it is a hot backup, you'll have to restore your database and do an incomplete recovery (including through the end of the backup and open resetlogs.

If you have a cold backup, you'll have to restore your database, recreate your control file and open resetlogs.