RE: ORA-1555 error with AUM already enabled

  • From: Martin Brown <martinfbrown@xxxxxxxxxxx>
  • To: <janine@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 25 May 2010 18:56:04 -0400

I had the same problem and fixed it by setting a flashback_time. 

Partial script below, but you can get the idea.

today=`date +%F`
time=`date +%T`
fb_time=FLASHBACK_TIME=\""TO_TIMESTAMP('$today $time','YYYY-MM-DD 
sleep 30


expdp $connectString schemas=$schemaList dumpfile=$fileName logfile=$logName 
job_name=$jobName parallel=$parallel directory=$directory $fb_time


> From: janine@xxxxxxxxxx
> Subject: ORA-1555 error with AUM already enabled
> Date: Tue, 25 May 2010 15:22:24 -0700
> To: oracle-l@xxxxxxxxxxxxx
> A full export of my database takes far longer on AWS than it does on my old 
> Linux server (30 minutes vs 2+ hours). During the export, I receive the 
> following error:
> EXP-00056: ORACLE error 1555 encountered
> ORA-01555: snapshot too old: rollback segment number 1 with name 
> "_SYSSMU1_3780397527$" too small
> I checked the parameters that control automatic undo management and found 
> them to be set correctly:
> SQL> show parameter undo
> ------------------------------------ ----------- 
> ------------------------------
> undo_management string AUTO
> undo_retention integer 900
> undo_tablespace string UNDOTBS1
> I tried running the export again, to see whether Oracle would have 
> automatically adjusted something to fix the problem, but it failed again.
> Is this just one of those freak cases where circumstances have psyched out 
> the automatic feature, or is there something I can do to fix it, beyond 
> whatever the manager is doing? Clearly the immediate problem is that my 
> rollback segments are too small, but since Oracle is managing them I hesitate 
> to go make them bigger myself. The longer range issue is the slow performance 
> of the virtual disk drives, which is something I haven't delved into yet.
> thanks,
> janine
> --
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.

Other related posts: