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