ORA-01555: snapshot too old: rollback segment number

SCHEMA: WMPYMYISADMIN82
TABLE: BIZDOCCONTENT

ORA-31693: Table data object "WMPYMYISADMIN82"."BIZDOCCONTENT" 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 15 with name "_SYSSMU15_134866855$" too small

---------------------------------------------------------------------------------------------------------------------------------
SQL> alter system set undo_retention=88888888 scope=both;

SQL> show parameter undo_retention

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
undo_retention                       integer                           88888888

select owner,table_name, column_name, nvl(retention, 0) retention, pctversion from dba_lobs where owner = 'WMPYMYISADMIN82'
and table_name='BIZDOCCONTENT';

OWNER                          TABLE_NAME                     COLUMN_NAME       RETENTION PCTVERSION
------------------------------ ------------------------------ ----------------- ---------- ----------
WMPYMYISADMIN82                BIZDOCCONTENT                  CONTENT           900

alter table WMPYMYISADMIN82.BIZDOCCONTENT modify lob (CONTENT) (pctversion 5);
alter table WMPYMYISADMIN82.BIZDOCCONTENT modify lob (CONTENT) (retention);

OWNER                          TABLE_NAME                     COLUMN_NAME        RETENTION PCTVERSION
------------------------------ ------------------------------ ------------------ ---------- ----------
WMPYMYISADMIN82                BIZDOCCONTENT                  CONTENT            88888888

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

SCHEMA: WMPYMYISADMIN82
TABLE: UTSCHS

ORA-31693: Table data object "UNILAB"."UTSCHS" 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 8 with name "_SYSSMU8$" too small

---------------------------------------------------------------------------------------------------------------------------
SQL> alter system set undo_retention=88888888 scope=both;

SQL> show parameter undo_retention

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
undo_retention                       integer                           88888888


select owner,table_name, column_name, nvl(retention, 0) retention, pctversion from dba_lobs where owner = 'UNILAB'
and table_name='UTSCHS';

Automatic Archival Process in Oracle 9i

In the alert log, ...
Tue May 31 09:57:05 2016
ORACLE Instance ldwtdb - Can not allocate log, archival required



The archival process died after automatic archival is disabled.



This is only happen in oracle 9i and oracle 10g on wards, auto archival is enabled when the database is placed in archive log mode.

In the alert log, ...
Wed Jun  1 14:08:53 2016
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Jun  1 14:08:53 2016
ARC0: Becoming the 'no FAL' ARCH
ARC1 started with pid=28
ARC1: Archival started
ARC1: Becoming the heartbeat ARCH
Wed Jun  1 14:08:53 2016
ARC0: Becoming the 'no FAL' ARCHARC0: Evaluating archive   log 2 thread 1 sequence 1458
Wed Jun  1 14:08:53 2016
ARC1: Becoming the heartbeat ARCHARC1: Evaluating archive   log 2 thread 1 sequence 1458



Since, these 2 archival processes is working, archiving redolog is working pretty good.

Oracle Database Migration Utilities

I did not really update my blog for sometimes.
Today , I am going to share with you on Oracle database migration utilities.

First of all, there is no migration utility (Script or DBUA) to perform a cross platform migration of an Oracle Database.

Changing platforms requires the database be re-built and / or the data moved using one of the following methods:

1. Export / Import to include the use of Datapump facilities.
    (All versions support Export/Import but for Datapump 10.1.0.2 or higher is required.)
2. Transportable Tablespaces 10G or Later
3. RMAN Convert Database functions. 10G or Later
4. Streams Replication
5. Create Table As Select (CTAS)
6. Dataguard Heterogeneous Primary and Physical Standbys
7. Oracle Golden Gate


Each of techniques have their strength or weakness, before implement it, you must study and do own research.

There is Oracle paper is writting on this topic - Migration Of An Oracle Database Across OS Platforms (Generic Platform) (Doc ID 733205.1) if you have interested to

Thanks! Have a great day!