flashback archive
Hi,
we support flashback archive on one of our databases. Recently we were performing a disaster recovery test
on our box.
We were successfully able to restore our oracle database to a different location. However, we noticed that flashback is not working any more.
We were able to see all the data in flashback tables. Also flashback is enabled as per dba_flashback_archive_tables.
Is there any other setting that needs to be applied? All the other objects are working fine. Except that when data is changed in a table, history table no more capturing it.
Any direction is appreciated
we support flashback archive on one of our databases. Recently we were performing a disaster recovery test
on our box.
We were successfully able to restore our oracle database to a different location. However, we noticed that flashback is not working any more.
We were able to see all the data in flashback tables. Also flashback is enabled as per dba_flashback_archive_tables.
Is there any other setting that needs to be applied? All the other objects are working fine. Except that when data is changed in a table, history table no more capturing it.
Any direction is appreciated
1