-
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.
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.
-
Hot or cold backup?
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.
Jeff Hunter
-
Since this is a test database, try to Create a new undo tablespace, alter the system to use the new undo, offline the old one, and drop it. (make sure you've changed the init parameter or spfile.)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|