Hello,
I have to convert a 3 node RAC Database with a 3 node Standby Configuration to single Instance. This has been worked so far, but one problem is still open:
On Primary I was able to remove the threads for the other Nodes with
ALTER DATABASE DISABLE THREAD 2;
ALTER DATABASE DISABLE THREAD 2
and than I was able to drop the logfiles groups for that threads.
Futher I removed all entries from init file directing to the RAC Nodes.
On Primary
select thread#,instance from v$thread;
gives me back one instance - fine.
On Standby (the init files is clean and tidy also, now), I am not able the disable the threads:
DO1S9180.DWH1B.sqlplus>select thread#,instance from v$thread;
THREAD# INSTANCE
---------- --------------------------------------------------------------------------------
1 DB1B
2 DB1B2 # I would like to get rid of this
3 DB1B3 # I would like to get rid of this
But
ALTER DATABASE DISABLE THREAD 2
*
ERROR at line 1:
ORA-01109: database not open
# further
alter database recover managed standby database cancel;
alter system set standby_file_management='MANUAL';
is not helping me here.
I am glad about every good hint.
Kind Regards
Vero