OraFAQ Forum: Server Utilities » ora-01555 during export.

Home » RDBMS Server » Server Utilities » ora-01555 during export.

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

ora-01555 during export. [message #123926]

Wed, 15 June 2005 10:45

oskarthik
Messages: 26
Registered: March 2005

Junior Member

hi,

Please advise as to what you think may be the problem here. The exports have failed many times showing this error.

EXP-00008: ORACLE error 1555 encountered

ORA-01555: snapshot too old: rollback segment number 4 with name "RBS3" too small

EXP-00000: Export terminated unsuccessfully

thanks,
karthik

Report message to a moderator

Re: ora-01555 during export. [message #123929 is a reply to message #123926]

Wed, 15 June 2005 10:59

macdba
Messages: 27
Registered: May 2005
Location: US

Junior Member

Hi,
Pls check whether u have given consistent=Y while exporting.

rgds
--Mak

Report message to a moderator

Re: ora-01555 during export. [message #123932 is a reply to message #123926]

Wed, 15 June 2005 11:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Seems the other sessions are updating the database during your export.
So use CONSISTENT=N ( which is default).
Dont specify CONSISTENT=Y.
Else
Increase your RBS(in 8i) and look into undo Management in 9i.
There is a long running transaction that needs more undo space than the available one.

Report message to a moderator

Re: ora-01555 during export. [message #123991 is a reply to message #123932]

Wed, 15 June 2005 16:11

oskarthik
Messages: 26
Registered: March 2005

Junior Member

mahesh,

here there are about 8 datafiles in the RBS tablespace and about
6 rollback segment online.

here there is no any parameter related to undo when i prompted "show parameter undo".

so what to do to resolve..?

oracle-->9i
os-->linux

karthik

Report message to a moderator

Re: ora-01555 during export. [message #123996 is a reply to message #123991]

Wed, 15 June 2005 16:25

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are you using Rollback segments intead of Undo tablespace in 9i!!?
Confirm this first.

Your UNDO RETENTION or RBS is too small.
Increase it!.

Switch to Undo Tablespaces and increase the undo_retention

scott@9i > show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     0
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDOTBS1

If the UNDO_RETENTION initialization parameter is not specified, the default value is 900 seconds.( I must have tweaked mine. Ingore it).

to reset this would be the command.
ALTER SYSTEM SET UNDO_RETENTION = 30000;

quoting docs

Committed undo information normally is lost when its undo space is overwritten by a newer transaction. But for consistent read purposes, long running queries might require old undo information for undoing changes and producing older images of data blocks. The initialization parameter, UNDO_RETENTION, provides a means of explicitly specifying the amount of undo information to retain. With a proper setting, long running queries can complete without risk of receiving the "snapshot too old" error.

Report message to a moderator

Re: ora-01555 during export. [message #124003 is a reply to message #123996]

Wed, 15 June 2005 16:50

balavignesh
Messages: 180
Registered: March 2005

Senior Member

sorry mahesh,

now only we noticed that the client's server is 8i.

so there is no undo parameters.how to set that..?

karthk

Report message to a moderator

Re: ora-01555 during export. [message #124007 is a reply to message #124003]

Wed, 15 June 2005 16:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

answer is the same.
Increase your rollback segments or increase the size of those rollback segments.

Report message to a moderator

Re: ora-01555 during export. [message #124008 is a reply to message #124007]

Wed, 15 June 2005 17:02

oskarthik
Messages: 26
Registered: March 2005

Junior Member

i have created one more rbs and made it online and how to increase the size of rbs..?

karthik

Report message to a moderator

Re: ora-01555 during export. [message #124011 is a reply to message #124008]

Wed, 15 June 2005 17:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/rollbak.htm#5895

What i meant is , create BIGGER RBS

[Updated on: Wed, 15 June 2005 17:09]

Report message to a moderator

Previous Topic:	ORA 01092 error
Next Topic:	export unsucessfull - ora-24389

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 12:32:30 CST 2025