Dataguard Rollback Standby to Primary

Oct 21, 2021 8:39AM

I have set Primary to mound mode, shutdown Standby and 'set state="APPLY-OFF"' Then run revert via RMAN on Primary

RMAN>
run
{
set until time "to_date('2021-10-17:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore database;
recover database;
}

Then on Primary

SQL>ALTER DATABASE OPEN RESETLOGS;

Now SCN on Primary - 003, SCN on Standby - 009 (as example)

When I am trying to flashback Standby to Primary - On Standby flashback to SCN(RESETLOGS_CHANGE# - 2)

SQL>FLASHBACK STANDBY DATABASE TO SCN 001;

I got - ORA-38729: Not enough flashback database log data to do FLASHBACK.

How it is possible to make sync (rollback Standby to Primary back-in-time-state) ?

High Availability Data Guard, Sharding and Global Data Services (MOSC)