Re: Consistent export vs.snapshot too old.

Jarek Palka <jarek_at_kamsoft.com.pl> wrote in <3AACF264.164F3D85_at_kamsoft.com.pl>:

>During export of large database using parameter CONSISTENT=Y
>we received an error :
>
>EXP-00056: ORACLE error 1555 encountered
>ORA-01555: snapshot too old: rollback segment number 5 with name "RB14"
>too small
>EXP-00222:
>System error message 1
>System error message: No such file or directory
>
>Becouse database is on-line 24*7 lot of transactions was in-doubt during
>this export. Is it possible to force export to use SELECTED
>rollback_segment ?
>How can we avoid such errors ?

There is another option that we use here. We have a database that is up 24x7. Every morning we clone this database, then export the clone.

The whole process is automated and goes like this:

- Place each datafile in turn into backup mode and copy.
- Recover clone database to a point in time.
- Open clone database and export.

Since noboddy has access to the clone we do not have to worry about the CONSISTENT=Y parameter. We do, however, pick a time that is relatively quiet. This may not be an option for you.

Kev. Received on Mon Mar 12 2001 - 23:53:52 CST