Hi Arun,
I appreciate your Oracle DBA YouTube channel very lot.
My name is Anusa,
I am working as junior DBA,I stuck in some very sad situation. While exporting the full database from production to test , where it takes 24 hrs to finish the export and the size is 100 GB .I am getting the errors below :
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 26 with name
and I have increased the undo retention as well. However, the situation remains the same. because we can't do cold backup and Surprisingly, the test machine supports multitenant. Please suggest me what to do.It will be helpful .
Kind Regards,
Anusa.🙂
Hi Anusa,
The ORA-01555 error is due to the value of UNDO_RETENTION being too low.
To better assist you in solving the problem, kindly share the database size, current UNDO retention, and UNDO tablespace size with us.