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

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

Quote:

---

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?

Quote:

---

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?

Quote:

---

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

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.

i get this error :

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

anybody knows what should i do?

thanks

Check Alert.log file in bdump folder.

Or check if any trace files are generated.