Home » RDBMS Server » Server Administration » ORA-1555 Famous Snapshot-Error
ORA-1555 Famous Snapshot-Error [message #140105] Fri, 30 September 2005 19:32 Go to next message
hexmanju
Messages: 71
Registered: September 2005
Location: MUMBAI
Member
Hi

Hey

Can Someone help me rectify this error...

ORA-01555: snapshot too old: rollback segment number 8 with name
"_SYSSMU8$" too small
EXP-00008: ORACLE error 1555 encountered
EXP-00000: Export terminated unsuccessfully

I had actually scheduled an export backup........Script has been written by the previous DBA..Well i would be very much helped if someone knows the solution to this and could provide me a step by step(Queries will be very helpful)solution.

Thanks
Manjunath
Re: ORA-1555 Famous Snapshot-Error [message #140111 is a reply to message #140105] Sat, 01 October 2005 00:29 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Check this article .. if u run out of patience reading the whole rhing do a Ctrl + F on gzexp it will take you to your problem string ..

http://asktom.oracle.com/pls/ask/f?p=4950:8:1282975601771549339::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:275215756923,

-Sai
Re: ORA-1555 Famous Snapshot-Error [message #140124 is a reply to message #140111] Sat, 01 October 2005 03:11 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
@vjeedigunta

Can you please elaborate on use of gzexp & gzimp commands & how does it help in controlling "01555 error". Frankly never heard of these, & when serahced google couldn't get much.
Got to know this much only that it uses high rate of compression & thus gives good speed.
Source: http://translate.google.com/translate?hl=en&sl=ko&u=http://forever-js.pe.kr/posting.php%3Fmode%3Dtopicreview%26t%3D138%26sid% 3Db8e5a59b2b5520403310d02912ad510f&prev=/search%3Fq%3Dgzexp%26hl%3Den%26hs%3DgKw%26lr%3D%26client%3Dfirefox-a%26rls%3Dorg.mozilla :en-US:official

--Girish
Re: ORA-1555 Famous Snapshot-Error [message #140125 is a reply to message #140124] Sat, 01 October 2005 03:13 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
@hexmanju

You can increase the size of rollback segments for controlling this error.

--Girish
Re: ORA-1555 Famous Snapshot-Error [message #140136 is a reply to message #140125] Sat, 01 October 2005 05:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to properly design your RBS and adequetly size it to hold a full a transaction.
Re: ORA-1555 Famous Snapshot-Error [message #140146 is a reply to message #140105] Sat, 01 October 2005 07:21 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

ahh...sorry for driving you into confusion..
what I meant was..look at the above asktom url...where in he explained the rollback seg' running out of space issues ..

gxexp is probably a customized script name of the guy who opened the case with tom ..

I hope I made it clear now ..

-Sai Jeedigunta
Re: ORA-1555 Famous Snapshot-Error [message #140147 is a reply to message #140136] Sat, 01 October 2005 07:22 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Oracle version and script details would be helpful here.

This is a bit of a guess, but you could try DIRECT=Y, the idea being that the quicker you can dump data out of the database the less time it has to maintain a read-consistent snapshot.

Also, are other sessions updating the tables while they are being exported?

You could also look at the setting of UNDO_RETENTION, assuming you are on 9i or later.
Re: ORA-1555 Famous Snapshot-Error [message #142491 is a reply to message #140105] Fri, 14 October 2005 17:17 Go to previous messageGo to next message
hexmanju
Messages: 71
Registered: September 2005
Location: MUMBAI
Member
Hi

Thanks a Lot every body for all your suggestions...

I did the following to rectify the error...


Made all existing RBS's to be offline and created a Big RBS..


CREATE PUBLIC ROLLBACK SEGMENT rbs_big
TABLESPACE RBS
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 5
MAXEXTENTS 100 );

Worked out...What do you think..Is it a permanent solution..

However Thanks a lot Once again..

Manju



Re: ORA-1555 Famous Snapshot-Error [message #142496 is a reply to message #142491] Fri, 14 October 2005 18:32 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
No, unless that increases your total undo resources. Maybe you just got lucky this time and nobody happened to be updating the tables you were querying.

Are other sessions updating the tables while they are being exported?

Oracle version and script details would be helpful here.

[Updated on: Mon, 17 October 2005 02:31]

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #142644 is a reply to message #142496] Mon, 17 October 2005 01:40 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Check out below link that will also help u

http://www.orafaq.com/forum/m/121457/67993/#msg_121457

Regards
sunilkumar
Re: ORA-1555 Famous Snapshot-Error [message #219810 is a reply to message #140105] Fri, 16 February 2007 03:40 Go to previous message
oraclearora
Messages: 6
Registered: February 2007
Location: Delhi
Junior Member
Check this as well.

http://oracle-online-help.blogspot.com/2007/02/size-your-undo-tablespace.html
Previous Topic: Oracle Streams questions (merged)
Next Topic: same user connecting from 10 machines
Goto Forum:
  


Current Time: Sun Dec 11 04:13:39 CST 2016

Total time taken to generate the page: 0.07205 seconds