Oracle DR Drill

Oracle DR Drill

How to make DR site as PR Site and vice versa in Oracle

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                                                                                                             srvctl stop instance -d xxxx -i  instance_name		5
then give the command on the primary which have to become dr     ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;		6
shutdown the instance shutdown immediate; startup mount;		7
	ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;	8
	Startup;	9
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;		10
	Start other instances if required	11