I just restore a database through active duplicate and then converted the database to RAC. The db is currently RAC and srvctl shows it as RAC but within the db, when i query the v$instance view, it is showing unknown instead of RAC. Please can i get some help resolving this?
SQL> select INSTANCE_NAME, DATABASE_TYPE from gv$instance;
INSTANCE_NAME
---------------- ---------------
liteseed1 UNKNOWN
liteseed2 UNKNOWN
**********************
srvctl config database -d liteseed
Database unique name: LITESEED
Database name:
Oracle home: /u01/app/oracle/product/19.0.0.0/dbhome_2
Oracle user: oracle
Spfile: +DATAC2/LITESEED_TN/spfileliteseed.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups:
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: liteseed1,liteseed2
Configured nodes: tnexap01dbadm01,tnexap01dbadm02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed