OraFAQ Forum: Server Administration » ORA-1555 Famous Snapshot-Error

Home » RDBMS Server » Server Administration » ORA-1555 Famous Snapshot-Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-1555 Famous Snapshot-Error [message #140105]

Fri, 30 September 2005 19:32

hexmanju
Messages: 78
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

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #140111 is a reply to message #140105]

Sat, 01 October 2005 00:29

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

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #140124 is a reply to message #140111]

Sat, 01 October 2005 03:11

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

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #140125 is a reply to message #140124]

Sat, 01 October 2005 03:13

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

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #140136 is a reply to message #140125]

Sat, 01 October 2005 05:01

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #140146 is a reply to message #140105]

Sat, 01 October 2005 07:21

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

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #140147 is a reply to message #140136]

Sat, 01 October 2005 07:22

William Robertson
Messages: 1643
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.

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #142491 is a reply to message #140105]

Fri, 14 October 2005 17:17

hexmanju
Messages: 78
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

Report message to a moderator

Re: ORA-1555 Famous Snapshot-Error [message #142496 is a reply to message #142491]

Fri, 14 October 2005 18:32

William Robertson
Messages: 1643
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