Re: DR test

Posted by Roshan on Sep 09, 2022; 5:52am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DR-test-tp10920p11062.html

I revise my question.

On standby database, after you create the restore point and open it read only to make it new primary, the old primary database does it remain open read write or we mount it? I see only log_archive_dest is defered on old primary.

Also, should we set the new archivelog destination on new primary to ship to old primary before open database to read write?

I assume below steps will make standby new primary.

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;
<set log archive dest>?

alter database open;

Thanks,

Roshan