Can Flashback table work after restore also?

Hi Experts, one more question on Flashback. I have one small table with 100 rows only. It has updates on every batch run. And suppose a batch aborts we want to flashback this. So, enabled the row movement on this table.  And it helps to restore the data of this table. And it is very effective. But the question is can this flash back (row movement at table level) also after the entire DB restore?
Or on the DB restore it will erase the logs and cannot flashback before the restore time?

Thank you.
Chandan PratihastAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I've never tried but as long as it is a normal restore to a point in time after the need to flashback, I would assume the flashback should still work.

If you want to flashback to say 8:00AM and you restore to 9:00AM, you should still be able to flashback.

If you open the database with resetlogs, you probably cannot flashback to a point before that time.

Again, never tried.  Might be an interesting experiment.  If you absolutely need to know:  I would set up a sample database and try it.
1
Chandan PratihastAuthor Commented:
Thank you for reply, I will also try and let you all know.
0
Chandan PratihastAuthor Commented:
Hi, I have tried and it seems after the restore the flashback table is not able to retrieve.
What I am trying "alter table <MYTABLE> ENABLE ROW MOVEMENT;" to try with one table.
Now is 11:00 AM 8-Aug. Restore done at 8:00 AM 8-Aug (today). Then flashback till 8-Aug 9:00AM is fine. But flashback 8-Aug 6:00AM gives below message:
ORA-01555: snapshot too old: rollback segment number 14 with name "_SYSSMU14_2473030277$" too small
flashback to 8-Aug 9:00 AM gives the data.

I think the retention period duration controlled by the below parameter (for row movement also?) am I right?
NAME                          TYPE    VALUE
----------------------------- ------- -----
db_flashback_retention_target integer 4320  

Thank you.
0
slightwv (䄆 Netminder) Commented:
Based on the docs, I believe db_flashback_retention_target is for a database flashback.

Going from this:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-performing-flashback-dbpitr.html#GUID-AA471072-D35C-410E-8C68-14E0DF8FB5D1

I believe you need undo_retention.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chandan PratihastAuthor Commented:
Hi

I set the undo_retention to 24*3600 but the flashback does not show data beyond the restore time. Thanks anyway.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.