场景：

SQL> show parameter db_unique_name


NAME                                 TYPE       VALUE


------------------------------------ ----------- ------------------------------


db_unique_name                       string     racdb






SQL> show parameter db_name


NAME                                 TYPE       VALUE


------------------------------------ ----------- ------------------------------


db_name                             string     prod






SQL> alter system set db_unique_name=orcl scope=spfile sid='*';


System altered.






重启节点1节点2实例：


节点1：


SQL> shutdown immediate;


SQL> startup;






节点2：


SQL> shutdown immediate;


SQL> startup;






SQL> show parameter db_unique_name


NAME                                 TYPE       VALUE


------------------------------------ ----------- ------------------------------


db_unique_name                       string     ORCL


db_unique_name修改完毕






[grid@rac1 ~]$ crsctl status res -t


查看资源状态:


ora.racdb.db


    1       OFFLINE OFFLINE                               Instance Shutdown   


    2       OFFLINE OFFLINE                               Instance Shutdown






真实数据库实例状态：


SQL> select instance_name,status from v$instance;


INSTANCE_NAME   STATUS


---------------- ------------


racdb1           OPEN






SQL> select instance_name,status from v$instance;


INSTANCE_NAME   STATUS


---------------- ------------


racdb2           OPEN






集群数据库资源状态与真实数据库实例状态不一致。


是因为OCR中记录的db_unique_name与实际数据库的db_unique_name不一致导致的。


并且ora.racdb.db资源是按db_unqiue_name识别的ora.<db_unique_name>.db






查看数据库资源信息：


[grid@rac1 ~]$ srvctl config database -d racdb   //-d db_unique_name


Database unique name: racdb


Database name: prod


Oracle home: /oracle/app/product/11.2.0/db_1


Oracle user: oracle


Spfile: +DATA/racdb/spfileracdb.ora


Domain: 


Start options: open


Stop options: immediate


Database role: PRIMARY


Management policy: AUTOMATIC


Server pools: racdb


Database instances: racdb1,racdb2


Disk Groups: DATA


Mount point paths: 


Services: session


Type: RAC


Database is administrator managed






[grid@rac1 ~]$ crsctl status res ora.racdb.db -f


....


....


DB_UNIQUE_NAME=racdb


....


....






可以看出OCR中记录的db_unique_name皆为racdb，而数据库实际db_unique_name为orcl

解决方法：

方式一：srvctl 与 crsctl修改资源属性

首先使用srvctl进行修改


srvctl modify database -d <db_unique_name> [-n <db_name>]


[grid@rac1 ~]$ srvctl modify database -d orcl


PRCD-1120 : The resource for database prod could not be found.


PRCR-1001 : Resource ora.prod.db does not exist


提示ora.prod.db资源不存在，说明该资源是根据db_unique_name来识别的,srvctl无法修改。






使用crsctl修改OCR中记录的db_unique_name信息:


[root@rac1 ~]# /oracle/grid/crs_1/bin/crsctl modify res ora.racdb.db -attr 'DB_UNIQUE_NAME=orcl';






[grid@rac1 ~]$ crsctl status res ora.racdb.db -f


....


DB_UNIQUE_NAME=orcl


....






[grid@rac1 ~]$ srvctl config database -d racdb


Database unique name: orcl


Database name: prod


Oracle home: /oracle/app/product/11.2.0/db_1


Oracle user: oracle


Spfile: +DATA/racdb/spfileracdb.ora


Domain: 


Start options: open


Stop options: immediate


Database role: PRIMARY


Management policy: AUTOMATIC


Server pools: racdb


Database instances: racdb1,racdb2


PRCD-1120 : The resource for database orcl could not be found.


PRCR-1001 : Resource ora.orcl.db does not exist






修改成功，但是这种方式仅仅修改了OCR中记录的db_unique_name,修改后集群数据库资源状态与真实数据库实例状态仍不一致。


认为是db_unique_name变化后，资源名称也随之变化的问题

方式二：添加新数据库资源

方式二：添加一个数据库资源


[oracle@rac1 ~]$ srvctl add database -d orcl -o /oracle/app/product/11.2.0/db_1 -n prod -p +DATA/racdb/spfileracdb.ora -r PRIMARY -s open -t immediate -y AUTOMATIC 


选项列表：


  -d <db_unique_name>     Unique name for the database


  -o <oracle_home>         ORACLE_HOME path


  -c <type>               Type of database: RAC One Node, RAC, or Single Instance


  -e <server_list>         Candidate server list for RAC One Node database


  -i <inst_name>           Instance name prefix for administrator-managed RAC One Node database 


  -w <timeout>             Online relocation timeout in minutes


  -x <node_name>           Node name. -x option is specified for single-instance databases


  -m <domain>             Domain for database. Must be set if database has DB_DOMAIN set.


  -p <spfile>             Server parameter file path


  -r <role>               Role of the database (primary, physical_standby, logical_standby, snapshot_standby)


  -s <start_options>       Startup options for the database. Examples of startup options are OPEN, MOUNT, or 'READ ONLY'.


  -t <stop_options>       Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.


  -n <db_name>             Database name (DB_NAME), if different from the unique name given by the -d option


  -y <dbpolicy>           Management policy for the database (AUTOMATIC, MANUAL, or NORESTART)


  -g "<serverpool_list>"   Comma separated list of database server pool names


  -a "<diskgroup_list>"   Comma separated list of disk groups


  -j "<acfs_path_list>"   Comma separated list of ACFS paths where database's dependency will be set


  -h                       Print usage






尝试启动新添加数据库资源：


[grid@rac1 ~]$ srvctl start database -d orcl


PRKO-3119 : Database orcl cannot be started since it has no configured instances






[grid@rac1 ~]$ srvctl config database -d orcl


Database unique name: orcl


Database name: prod


Oracle home: /oracle/app/product/11.2.0/db_1


Oracle user: oracle


Spfile: +DATA/racdb/spfileracdb.ora


Domain: 


Start options: open


Stop options: immediate


Database role: PRIMARY


Management policy: AUTOMATIC


Server pools: orcl


Database instances: 


Disk Groups: 


Mount point paths: 


Services: 


Type: RAC


Database is administrator managed






向数据库资源添加实例：//添加实例该方式添加


[oracle@rac1 ~]$ srvctl add instance -d orcl -i racdb1 -n rac1


[oracle@rac1 ~]$ srvctl add instance -d orcl -i racdb2 -n rac2






[grid@rac1 ~]$ srvctl config database -d orcl


Database unique name: orcl


Database name: prod


Oracle home: /oracle/app/product/11.2.0/db_1


Oracle user: oracle


Spfile: +DATA/racdb/spfileracdb.ora


Domain: 


Start options: open


Stop options: immediate


Database role: PRIMARY


Management policy: AUTOMATIC


Server pools: orcl


Database instances: racdb1,racdb2


Disk Groups: 


Mount point paths: 


Services: 


Type: RAC


Database is administrator managed






再次启动：


[grid@rac1 ~]$ srvctl start database -d orcl






ora.orcl.db


    1       ONLINE ONLINE       rac1                     Open                


    2       ONLINE ONLINE       rac2                     Open










此时集群数据库资源状态与真实数据库实例状态保持一致。






待实例关闭后，删除旧数据库资源


[root@rac1 ~]#crsctl delete res ora.racdb.db

附加： 修改OCR中的DB_NAME

修改OCR中的DB_NAME


[root@rac1 ~]# /oracle/grid/crs_1/bin/srvctl modify database -d racdb -n prod     // -n代表修改后的名字






[grid@rac1 ~]$ srvctl config database -d racdb 


Database unique name: racdb


Database name: prod


Oracle home: /oracle/app/product/11.2.0/db_1


Oracle user: oracle


Spfile: +DATA/racdb/spfileracdb.ora


Domain: 


Start options: open


Stop options: immediate


Database role: PRIMARY


Management policy: AUTOMATIC


Server pools: racdb


Database instances: racdb1,racdb2


Disk Groups: DATA


Mount point paths: 


Services: session


Type: RAC


Database is administrator managed