Hi all,
I need help understanding what I'm doing wrong.
Oracle 11.2.0.4
SQL> select value from v$parameter where name = 'undo_tablespace';
VALUE
--------------------
UNDOTBS1
SQL> select retention from dba_tablespaces where tablespace_name = 'UNDOTBS1';
RETENTION
-----------
GUARANTEE
SQL> select value/60 as hours from v$parameter where name = 'db_flashback_retention_target';
HOURS
----------
36
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
The UNDOTBS1 has lots of space available and it can still auto extend.
Yesterday I launched a "consistent" export, meaning, fixing the date to the moment I started EXPDP ( 2019-01-31 15:00 ).
What I got was several tables not being exported due to error ORA-01555.
If I check the oldest SCN I can flashback to, it says:
SQL> SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') FROM v$flashback_database_log;
TO_CHAR(OLDEST_FLASHBACK_TIME,
------------------------------
2019-01-22 01:20:15
So, why does it say jan-22 if some tables lost the data from yesterday (jan-31) ?
What am I missing here?
Thanks for your help.
Flavio