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 ...
Thanks for the post Brother,
ReplyDeleteHave you used these Q & A to pass the exam? Or just posted from elsewhere? I see some differences in answers for some questions
dear in these the answers are not accurate so please do verify each question and its answer by yourself
ReplyDeleteValuable information thanks for sharing Oracle RAC DBA Online Training