Multiple threads on NON RAC database

[Arjen Visser]

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.