Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - 'How Do I' Questions

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-22-2010, 03:40 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 381
Default Multiple threads on NON RAC database

It maybe possible that when migrating a RAC database to a single instance environment the instance still carried some of RAC signatures such as multiple threads.

To check if there are multiple threads:
SQL> select group#, thread#, status from v$log;

GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 CURRENT
2 1 INACTIVE
3 2 CURRENT
4 2 INACTIVE


In the above example it can be seen that thread 2 is not yet disabled. This can be disabled with the following SQL:

SQL> alter database disable thread 2;


The database should now have only a single thread.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 05:09 PM.