step by step How to make Oracle Database DR site as PR Site and vice versa in Oracle
How to make oracle database DR site as PR Site and vice versa in Oracle step by step PR Site DR Site S.no alter system job_queue process=0; alter system job_queue process=0 scope =both SID='*'; 1 emctl stop dbconsole emctl stop dbconsole 2 select 'APPLIED', max(sequence#), thread# from v$archived_log where APPLIED='YES' group by thread# union all select 'ARCHIVED', max(sequence#),thread# from v$archived_log where archived='YES'group by thread# order by 2; 3 check the status of both pr and dr select SWITCHOVER_STATUS from v$database; select SWITCHOVER_STATUS from v$database; 4 stop the instances only leave one instance which need to become DR