DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005

    Missing log files during recovering undo tablespace

    oracle version:
    Backup S/W:Netvault


    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;

    ----------------------------------- -------
    /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.

  2. #2
    Join Date
    Nov 2000
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2005
    AZ, USA
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.