Hi all,
I faced a strange problem to day.I have created a flashback data archive with quota unlimited and then associated a table with it.After a few day i received an alert in the alert log of the database
Flashback Archive MYFLASH ran out of space in tablespace MYTBS.
Flashback archive MYFLASH is full, and archiving is suspended.
Please add more space to flashback archive MYFLASH .
And that's normal because the tablespace have more than 90% of used space but many users are getting these error althought there is a lot of free space (more than 6G)
Caused by: java.sql.SQLException: ORA-55617: Flashback Archive "MYFLASH " out of space and tracking on "" is suspended
And these cause the DML to fail.So the tablespace quota is not exceeded and the DML on the table is blocked haw these can happen.Thanks for your help
Database version : Oracle RAC 11.2.0.3.9 two nodes
Platform : HP-UX IA (64-bit)