Undo Tablespace Failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Undo Tablespace Failure

  1. #1
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39

    Undo Tablespace Failure

    When i try to open my Oracle 9i database i get this :

    ORA-01122: database file 2 failed verification check
    ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF'
    ORA-01200: actual file size of 39680 is smaller than correct size 40960 blocks

    How can i correct this i cant open my database.

    thanks
    Gustavo Villaran

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can do this.
    Code:
    ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF' OFFLINE DROP;
    ALTER DATABASE OPEN;
    CREATE UNDO TABLESPACE UNDOTBS02 DATAFILE...;
    ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS02' SCOPE BOTH;
    DROP TABLESPACE UNDOTBS01;
    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by SANJAY_G
    You can do this.
    Code:
    ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF' OFFLINE DROP;
    ALTER DATABASE OPEN;
    CREATE UNDO TABLESPACE UNDOTBS02 DATAFILE...;
    ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS02' SCOPE BOTH;
    DROP TABLESPACE UNDOTBS01;
    HTH
    oh dear, are your serious? whack the rbs ts?
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by stmontgo
    oh dear, are your serious? whack the rbs ts?
    He wud be very much....

    Yes Whack the RBS TS1 and create TS2..wass wrong?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by stmontgo
    oh dear, are your serious? whack the rbs ts?
    Forgot to mention.
    *Do this only if the database was cleanly shutdown.*
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Or U could Startup ur DB somthing like this by commenting the Undo TS in pfile.

    #undo_tablespace=undotbs01

    Startup Pfile=...

    drop TS undo01
    Create a TS undo2...shutdown and startup using

    undo_tablespace=UNDOTBS02

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    i get this error :

    ALTER DATABASE OPEN
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    Gustavo Villaran

  8. #8
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39

    Question Undo Tablespace Error

    anybody knows what should i do?

    thanks
    Gustavo Villaran

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Check Alert.log file in bdump folder.

    Or check if any trace files are generated.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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