12.2 : Synchronize/Restore standby after Primary restore

Hello,

The production database (12.2.0.1) has been restored after an application delivery error.

Restore point was the exact time of delivery :

STEPS :

1 / Disabling dataguard

2 / Restore PRIMARY DB:

run

{

allocate channel c1 type sbt;

allocate channel c2 type sbt;

alter database mount;

restore database until time '2022-01-09 21:00:00';

recover database until time '2022-01-09 21:00:00';

sql "alter database open resetlogs";

}

Now how to synchronize/restore standby DB?

Is there any simple method to restore other then based on DUPLICATE TARGET ?

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;

Thanks.

GD.