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

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/which-one-is-best-option-to-change-standby-database-status-to-open-tp4716p4717.html

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.