Home » Server Options » RAC & Failsafe » unnamed_instance_4 (oracle 11g r2, OEL 5)
unnamed_instance_4 [message #650469] Tue, 26 April 2016 03:50 Go to next message
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 #650470 is a reply to message #650469] Tue, 26 April 2016 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The real question is "why is it creating new redo log group?".

Re: unnamed_instance_4 [message #650471 is a reply to message #650470] Tue, 26 April 2016 03:55 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

Recently i have add and remove one node from my cluster , after that i am facing this issue.

Regards
zeeshan
Re: unnamed_instance_4 [message #650473 is a reply to message #650471] Tue, 26 April 2016 04:16 Go to previous messageGo to next message
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 #650476 is a reply to message #650473] Tue, 26 April 2016 05:44 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Can you disable and drop the thread?
Re: unnamed_instance_4 [message #650482 is a reply to message #650476] Tue, 26 April 2016 07:15 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

yes i have disable and drop it but it created again when instance restarted, is there any option to remove it permanently.
Re: unnamed_instance_4 [message #650485 is a reply to message #650482] Tue, 26 April 2016 07:34 Go to previous message
John Watson
Messages: 7150
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.
Previous Topic: TAF connectivity
Next Topic: RAC Database refresh from active cloning in same server.
Goto Forum:
  


Current Time: Wed Nov 22 21:46:12 CST 2017

Total time taken to generate the page: 0.05989 seconds