961469 wrote:Some confusion on above scenario, As i understood correctly the stright forward question is, Can you create manual restore points ? If so Yes, but create a restore point with Guarantee , You can refer below link for more details
I really dont think this is possible so expecting a no but asking anyway as I cant find a definitive answer
Dataguard standby in physical standby mode
Open in standby snapshot mode for Read Write testing, this automatically create a snapshot point
Re-Open in physical standby mode which uses above snapshot point, querying the snapshots after open and we dont see it anymore.
My question is it possible to have a manual snapshot point created on the standby database which is persistent across snapshot and physical opens. So
Open standby in snapshot mode (auto snapshot point A)
do some work
take a manual snapshot (point B)
open in physical mode (point A, no longer available)
some time later open database in snapshot mode using Point B.
I cant test this til later in the week but Im guessing Point B will be just gone once physical is re-opened.