Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01555 while export

edited Dec 16, 2016 4:00AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

I have a 1 terabyte db,

we do export every night for crucial tables.

so we are getting ORA-31693, ORA-02354, ORA-01555

Currently undo retention is 1000, I've changed it to 6000 and move the export time for night to late night.

select max(maxquerylen) from v$UNDOSTAT;

MAX(MAXQUERYLEN)

----------------

           33321

select max(maxquerylen) from DBA_HIST_UNDOSTAT;

MAX(MAXQUERYLEN)

----------------

           38500

but i felt like the db will ask for more.

the questions:

1) why some of the solution at oracle support suggesting to change this value to something big before export, and change it back to normal after export. is there something not nice if the value stay big?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center