flashback

Oracle 12.2 Dataguard : PDB Flashback on the Primary

By Mouhamadou Diaw The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle(…)

Oracle 12c – Combining Flashback Drop and Flashback Query

By William Sescu If you think that Flashback Drop feature just brings back your table, then this is only half of the story. It does much more than that. Besides undropping the table, it also brings back your constraints, your(…)

Dbvisit replicate when you flashback the target

By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is(…)

Flashback logging overhead: ‘db file sequential read’ on UNDO tablespace

By Franck Pachot . in my previous post I’ve reproduced an issue where some bulk insert into a GTT was generating too much undo. But the real case I encountered was worse: the insert was reading lot of(…)