DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Missing log files during recovering undo tablespace

Hybrid View

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

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