Total System Global Area 303532544 bytes
Fixed Size 731648 bytes
Variable Size 285212672 bytes
Database Buffers 16777216 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
==================================
so, i went into alert log and saw this...
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
so, i changed the pfile and changed undo_management from AUTO to MANUAL and started the database. Database started fine. So then, i deleted the old UNDO that is creating the problems, and created a new UNDO, and shutdown the database.
Then, I went and changed the pfile and changed the undo_management from MANUAL to AUTO and started the database.
Hi dear, im just confused....I haven't really explore much of this undo thing...
Originally Posted by vr76413
so, i changed the pfile and changed undo_management from AUTO to MANUAL and started the database. Database started fine. So then, i deleted the old UNDO that is creating the problems, and created a new UNDO, and shutdown the database.
Then, I went and changed the pfile and changed the undo_management from MANUAL to AUTO and started the database.
Ron
So you mean here that changing the pfile from AUTO to MANUAL and
deleting the UNDO(supposedly creating the problem) was not the
real solution right?
The real problem is that, the undo tablespace name was not reflected in the pfile's (undo_tablespace parameter).
I mean the solution is just to reflect the undo tablespace name.
Am i right? davey...
Last edited by yxez; 10-25-2006 at 08:42 PM.
Behind The Success And Failure Of A Man Is A Woman
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Originally Posted by vr76413
Bookmarks