Oracle RAC 更改DB_UNIQUE_NAME

1,288次阅读
没有评论

共计 1557 个字符,预计需要花费 4 分钟才能阅读完成。

背景

遇到一个场景是更改 RAC 架构下的 Oracle DB_UNIQUE_NAME , 使得跟 DB_NAME 不一致,尝试了网上的方法,都没能成功,最后是看了官方 support 的 solution,下面是主要操作步骤,11g203 版本,已经验证是没问题的。

具体操作步骤

For example, a database that was originally created with Global Database Name "<database>" would have a db_name and db_unique_name of "<database>" and its corresponding CRS database resource would be named "ora.<database>.db". Changing the db_unique_name requires a complete restart of the database.

  1. Remove the database, instance and service resources from CRS, this does NOT affect database itself.
    $ srvctl stop database -d <database>
    $ srvctl remove database -d <database>

  2. Start the database and change the db_unique_name at database level.
    SQL> Startup;
    SQL> alter system set db_unique_name=<database>_test scope=spfile sid='';
    SQL> alter system set db_domain=<domain> scope=spfile sid='
    '; << only required when db_domain needs to be changed.
    SQL> alter database rename global_name to <database>_test.<domain>;

  3. Now add the database resource to cluster-level.
    $ srvctl add database -d <database>_test -n <node> -o <ORACLE_HOME>
    $ srvctl add instance -d <database>_test -i <instance1> -n <node1>
    $ srvctl add instance -d <database>_test -i <instance2> -n <node2>

  4. Create dependency between database and ASM instance so that database starts after ASM instance starts.
    $ srvctl modify instance -d <database>_test -i <instance1> -s +ASM1
    $ srvctl modify instance -d <database>_test -i <instance2> -s +ASM2Please
    note that, for 11.2, it is no longer required to modify at instance level, it should be done at database level:
    srvctl modify database -d <db_unique_name> -a "<diskgroup_list>
    "5) Create database service, the following example add service with both instances as preferred
    $ srvctl add service -d <database>_test -s <service> -r "<instance1>,<instance2>"


IT 内容具有时效性,未避免更新后未同步,请点击查看最新内容:Oracle RAC 更改 DB_UNIQUE_NAME
文章首发于:http://nebofeng.com/2023/04/21/oracle-rac-%e6%9b%b4%e6%94%b9db_unique_name/
正文完
欢迎关注个人公众号
post-qrcode
 
HTML文本

本文链接:

nebofeng
版权声明:本站原创文章,由 nebofeng 2023-04-21发表,共计1557字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
评论(没有评论)
验证码