Home » RDBMS Server » Server Utilities » ORA-01555: snapshot too old (Oracle 10.2.0.4 windows 64 bit)
ORA-01555: snapshot too old [message #481402] Wed, 03 November 2010 02:42 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello Team,

We are taking full logical backup ( export) in freeze hours( no user login). But prompting error "ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small".

I request to please explain the error and suggest the solution.

Thanks
Jay vardhan
Re: ORA-01555: snapshot too old [message #481404 is a reply to message #481402] Wed, 03 November 2010 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 67545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I request to please search before posting, ORA-01555 is one the MOST posted and answered question among these last 15 years on Oracle forums.

Retry the operation and if there is REALLY no one working then it will likely work, if not retry once more.

Regards
Michel

[Updated on: Wed, 03 November 2010 02:46]

Report message to a moderator

Re: ORA-01555: snapshot too old [message #481412 is a reply to message #481404] Wed, 03 November 2010 05:50 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks for your prompt response.

What punch me is that we are getting error ora-01555 in freeze hours and non of the user is allowed to update any tables.

Regards,
jay vardhan
Re: ORA-01555: snapshot too old [message #481419 is a reply to message #481412] Wed, 03 November 2010 07:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but Oracle may have to do some job on your blocks when you query them (this is called "delayed block clean out").

Regards
Michel

[Updated on: Wed, 03 November 2010 07:16]

Report message to a moderator

Re: ORA-01555: snapshot too old [message #481424 is a reply to message #481419] Wed, 03 November 2010 08:00 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Michel.

I will look for the "delayed block clean out" and try to explore the topic.

Regards,
jay vardhan
Re: ORA-01555: snapshot too old [message #481432 is a reply to message #481424] Wed, 03 November 2010 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing you can do about this but "select count(*)" on the table you want to export, if you want to export all tables this is of course not possible.

Regards
Michel
Re: ORA-01555: snapshot too old [message #497312 is a reply to message #481402] Fri, 04 March 2011 16:39 Go to previous message
srraajesh
Messages: 63
Registered: May 2005
Member
I took some time to search on this snapshot too old error, and found that the following link could be useful in understanding more about this error. You may refer if you wish too.
Previous Topic: expdp with remap_schema?
Next Topic: expdp only procedures
Goto Forum:
  


Current Time: Sun Nov 29 04:02:08 CST 2020