-
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
-
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"
-
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
-
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"
-
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"
-
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"
-
i get this error :
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Gustavo Villaran
-
Undo Tablespace Error
anybody knows what should i do?
thanks
Gustavo Villaran
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|