ORA-31693 ORA-02354 ORA-01555 snapshot too old During Export backup via expdp

Hi,

I will explain how to solve ORA-31693 ORA-02354 ORA-01555 During Export backup error.

Details of error are as follows.

ORA-31693: Table data object "USER"."TABLE" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 154 with name “_SYSSMU154_1434655980$” too small

 

To solve this problem, increase the undo_retention as follows.

 

SQL> show parameter undo

NAME              TYPE               VALUE
------------------------------------ ----------- 
undo_management   string             AUTO
undo_retention    integer            900
undo_tablespace

 

SQL> alter system set undo_retention=90000 scope=both sid='*';

System altered.

 

 

 

Query the retention of table as follows.

SQL> select retention from dba_lobs where table_name='DEVRAWDATA';

RETENTION
----------
900

 

lob retention of the table are updated as follows.

SQL> alter table MSD.DEVRAWDATA modify lob(VALUE) (pctversion 5);

Table altered.

SQL> alter table MSD.DEVRAWDATA modify lob(VALUE) (retention);

Table altered.

SQL>
SQL> select retention from dba_lobs where table_name='DEVRAWDATA';

RETENTION
----------
900000

Now problem has been solved.

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 79 views today,  3 views in last 3 hour

Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply