-----------------------------------------------
ora.BACKUP.dg
ONLINE ONLINE suq1
ONLINE ONLINE suq2
ora.DATADG.dg
ONLINE ONLINE suq1
ONLINE ONLINE suq2
ora.LISTENER.lsnr
ONLINE ONLINE suq1
ONLINE ONLINE suq2
ora.SYSTEMDG.dg
ONLINE ONLINE suq1
ONLINE ONLINE suq2
ora.asm
ONLINE ONLINE suq1 Started
ONLINE ONLINE suq2 Started
ora.gsd
OFFLINE OFFLINE suq1
OFFLINE OFFLINE suq2
ora.net1.network
ONLINE ONLINE suq1
ONLINE ONLINE suq2
ora.ons
ONLINE ONLINE suq1
ONLINE ONLINE suq2
ora.registry.acfs
ONLINE ONLINE suq1
ONLINE ONLINE suq2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE suq2
ora.cvu
1 ONLINE ONLINE suq2
ora.oc4j
1 ONLINE ONLINE suq2
ora.scan1.vip
1 ONLINE ONLINE suq2
ora.suq1.vip
1 ONLINE ONLINE suq1
ora.suq2.vip
1 ONLINE ONLINE suq2
[oracle@suq1 ~]$ srvctl add database -d suq -o /u01/app/oracle/product/11.2.0/db_1
[oracle@suq1 ~]$ srvctl config database
suq
[oracle@suq1 ~]$ srvctl add instance -d suq -n suq1 -i suq1
[oracle@suq1 ~]$ srvctl add instance -d suq -n suq2 -i suq2
SQL> create spfile='+datadg' from pfile;
File created.
[root@suq1 cssd]# srvctl modify database -d suq -p '+datadg/suq1/parameterfile/spfile.325.886161615'
?
?
[oracle@suq1 dbs]$ srvctl config database -d suq -a
Database unique name: suq
Database name:
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +datadg/suq1/parameterfile/spfile.325.886161615
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: suq
Database instances: suq1,suq2
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is enabled
Database is administrator managed
查看一下监听,有可能还需要修改services_name参数:
?
?
SQL> alter system set service_names=suq scope=both;
到此,单实例已经转换完成了rac数据库。可以重启一下机器,看看数据库能否自动启动,资源是否正常。
?