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
HH24:MI:SS')"\"
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
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
_________________________________________________________________
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
Other related posts:
