unnamed_instance_4 [message #650469] |
Tue, 26 April 2016 03:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
zeeshan047
Messages: 99 Registered: June 2010 Location: PAKISTAN
|
Member |
![zeeshan_pk47](/forum/theme/orafaq/images/skype.png)
|
|
hi,
I am using 2 node RAC recently i have add and remove a node from my cluster after that when ever my instance restart a new redo log group created with a new thread number , which cause my replication process struck. How i refrain my database to create new redo log group after instance restarted.
Regards
Zeeshan
[Updated on: Tue, 26 April 2016 03:54] Report message to a moderator
|
|
|
|
|
Re: unnamed_instance_4 [message #650473 is a reply to message #650471] |
Tue, 26 April 2016 04:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
zeeshan047
Messages: 99 Registered: June 2010 Location: PAKISTAN
|
Member |
![zeeshan_pk47](/forum/theme/orafaq/images/skype.png)
|
|
As seen below thread number 4 with redo group 1 and 2 are created automatically when ever instance restart.
select * from gv$thread;
INST_ID THREAD# STATUS ENABLED GROUPS INSTANCE
3 2 OPEN PUBLIC 2 rac2
3 3 OPEN PRIVATE 2 rac3
3 4 CLOSED PUBLIC 2 UNNAMED_INSTANCE_4
2 2 OPEN PUBLIC 2 rac2
2 3 OPEN PRIVATE 2 rac3
2 4 CLOSED PUBLIC 2 UNNAMED_INSTANCE_4
select GROUP#,THREAD#,STATUS from v$log;
GROUP# THREAD# STATUS
1 4 ACTIVE
2 4 UNUSED
3 2 INACTIVE
4 2 CURRENT
5 3 INACTIVE
6 3 CURRENT
[Updated on: Tue, 26 April 2016 04:25] Report message to a moderator
|
|
|
|
|
Re: unnamed_instance_4 [message #650485 is a reply to message #650482] |
Tue, 26 April 2016 07:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
1. It would help if you showed what you are doing and the results.
2. Is this database policy managed or administrator managed?
3. Have you set the thread parameter? I would not do so, best to remove it from the spfile.
4. Is the presence of a third thread a problem actually a problem? I would usually create three threads for a two node RAC, just to have one spare.
|
|
|