| unnamed_instance_4 [message #650469] |
Tue, 26 April 2016 03:50  |
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
|
Member |
|
|
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  |
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
|
Member |
|
|
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 |
John Watson
Messages: 8974
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
