which one is best option to change standby database status to open

[deshavi]

Hey Erman,

We want to open our standby database periodically for developers.Normally we were using snapshot standby,but i wonder that why dont we open database directly . Which one is best ?

[ErmanArslansOracleBlog]

You need to open your standby db read-write, right?
snapshot standby is a good option.
You can also use the guaranteed restore point;

On Standby DB tier:

alter database recover managed standby database cancel;
alter database flashback on;
create restore point OPEN_STANDBY guarantee flashback database;
alter database activate standby database;
alter database open;


--you shouldn't directly open your standby database. You need to use the mechanisms/technologies which let you continue to feed this standby and make it sync with the PROD, after your developers finish their work.