How does flash back of the primary database affect its standby database?
I am running 19C oracle enterprise on Linux Redhat 7
I have been testing flash back in my test databse, creating a table, adding data, flashing it back to a previous SCN and also doing a database flash back giving a timestamp with no issues.
My testing is moving to a data guard environment: I have a principal and its standby.
I am looking to running the same tests:
On the principal side Flash back a table:
get 1st SCN, create a table, add 6 rows of data, get 2nd scn, add 10 more rows of data, get 3rd scn, flash back to 2nd scn, check table - returns 6 rows, flash back to 1st scn, check table - returns table not created, flash back to 3rd SCN, check table- returns all 16 rown, drop table.