| "ORA-01555:snapshot too old" in Oracle 9 using Automatic Undo [message #127308] |
Mon, 11 July 2005 03:25  |
yuniar
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
Hi there,
This is a very very frequently asked question, ORA-01555, yes i've done the research, googling all over the place. but it seem all those solutions seem doesn't work for me.
Ok this is the situation. Im using version 9 and i'm using Automatic Undo Management by using this value:
undo_management=AUTO
in the init.ora file
There was a harddrive controller failure, but all data files and control files seem to be fine.I've done recovery to ensure everything is okay.
But after doing the recovery, the database won't start.
It keeps giving "ORA-01555: snapshot too old".
How should i fix this? lot of suggestion to alter the rollback segment, but how do I do that if i can't even open the database??
And I shouldn't need to alter the rollback segment since I'm using automatic undo management right?
alter database open keeps giving me ORA-01555 error.
I'm sorry if this is very frequent question, but i've tried all suggesstion and none of them works.
Thank you so much for your help.
btw for your information, the datafiles is about 90GB size
|
|
|
|
|
|
|
|
| Re: "ORA-01555:snapshot too old" in Oracle 9 using Automatic Undo [message #127361 is a reply to message #127314] |
Mon, 11 July 2005 07:00  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
undo_retention parameter specifies time in seconds for storing committed undo information in auto managed undo segments.
Undo segments are on disk & thus can survive instance crashes.
Default value is 900 seconds.
Keeping this value as 1 second can potentially increase the chances of snapshot too old error.
Regds
Girish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
