Database Backup and Recovery (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center