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 ...
Comments
Post a Comment