RRENT_MASTER,
m.PREVIOUS_MASTER, m.REMASTER_CNT
from dba_objects o, v$gcspfmaster_info m
where o.data_object_id=74626
and m.data_object_id = 74626 ; OBJECT_NAME CURRENT_MASTER PREVIOUS_MASTER REMASTER_CNT ――――― ――――? ――――― ―――― TEST 0 2 3 ? Issue an insert statement on scott.test from node3 so that scott.test
will be remastered to node3
SCOTT@NODE3>insert into scott.test select * from test;
? check repeatedly that opens are increasing on scott.test with time
SYS@NODE1>select inst_id, sopens, xopens
from x$object_policy_statistics
where object=74626; INST_ID SOPENS XOPENS ―――- ―――- ―――- 1 3664 0
SYS@NODE1>/
INST_ID SOPENS XOPENS ―――- ―――- ―――- 1 7585 1305 . . .
SYS@NODE1>/
INST_ID SOPENS XOPENS ―――- ―――- ―――- 1 12788 17000
SYS@NODE1>/
INST_ID SOPENS XOPENS ―――- ―――- ―――- 1 35052 39297 ? check repeatedly if remastering has been initiated ?
? Note that after some time . current master changes from node1CURRENT_MASTER =0) to node3 (CURRENT_MASTER =2) . Previous master changes from node3 ( PREVIOUS_MASTER=2) to node1( PREVIOUS_MASTER=0) ? Remaster count increases from 3 to 4. .
SYS@NODE2>select o.object_name, m.CURRENT_MASTER,
m.PREVIOUS_MASTER, m.REMASTER_CNT
from dba_objects o, v$gcspfmaster_info m
where o.data_object_id=74626
and m.data_object_id = 74626 ;
16:09:16 SYS@NODE2>/
OBJECT_NAME OBJECT_NAME CURRENT_MASTER PREVIOUS_MASTER REMASTER_CNT ―――――? ――――? ――――― ―――― TEST 0 2 3 . . . .
16:12:24 SYS@NODE2>/
OBJECT_NAME CURRENT_MASTER PREVIOUS_MASTER REMASTER_CNT ――――――――――――――――――――――――――? TEST 2 0 4 ―- REMASTERING DUE TO INSTANCE CRASH ? Presently node3 is the master of SCOTT.TEST Let us crash node3 and monitor the remastering process
root@node3#init 6
? check repeatedly if remastering has been initiated ? ? Note that scott.test has been remastered to node2 (CURRENT_MASTER=1) ? PREVIOUS_MASTER =2 and REMASTER_CNT has increased from 4 to 5
SYS@NODE2>select o.object_name, m.CURRENT_MASTER,
m.PREVIOUS_MASTER, m.REMASTER_CNT
from dba_objects o, v$gcspfmaster_info m
where o.data_object_id=74626
and m.data_object_id = 74626 ; OBJECT_NAME CURRENT_MASTER PREVIOUS_MASTER REMASTER_CNT ――――― ――――? ――――― ―――― TEST 1 2 5 ― CLEANUP ―
SYS@NODE1>drop table scott.test purge;
SYa@NODE1S>
alter system reset "_gc_policy_minimum" = 10 scope=spfile;
alter system reset "_gc_policy_time" = 1 scope=spfile;
[oracle@host01 ~]$ srvctl stop database -d racdb
srvctl start database -d racdb
srvctl status database -d racdb References: