Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Force remastering resource using oradebug

zizu#1985Jan 4 2019 — edited Jan 10 2019

Hi,

I have question.

Is it possible to remaster resource using oradebug in RAC 12.2?

I have below situation on 2-nodes RAC.

oradebug setmypid

oradebug lkdebug -m pkey 294328 1

col object_name for A10

select o.object_name,m.PREVIOUS_MASTER, m.CURRENT_MASTER

from   dba_objects o, v$gcspfmaster_info m

where o.data_object_id=294328

and m.data_object_id = 294328 ;

OBJECT_NAM CURRENT_MASTER

---------- --------------

SEQUENCER               1

oradebug setmypid

oradebug lkdebug -m pkey 294328 2

col object_name for A10

select o.object_name,m.PREVIOUS_MASTER, m.CURRENT_MASTER

from   dba_objects o, v$gcspfmaster_info m

where o.data_object_id=294328

and m.data_object_id = 294328 ;

I believe RAC ignore my request.

Is there any way I could force remastering using oradebug?

Regards,

Tomasz Ziss

Comments
Post Details
Added on Jan 4 2019
6 comments
977 views