之前做的一个实验:
RAC 修改 ASM实例名 的步骤
http://blog.csdn.net/tianlesoftware/archive/2011/03/25/6275827.aspx
The following procedures do require some down time. One node at a time, we will shutdown all database instances that store their data in ASM. The other nodes will be unaffected, so these may continue to service the business.
All the following steps are assumed to be executed while logged into the server as the Oracle software owner (e.g., oracle).
1) From one of the nodes (any node), update the OCR
Stop all the db instances that store their data in the asm instance you will be doing the maintenance:
srvctl stop db -d <db name>
Stop the asm instance:
srvctl stop asm -n <node name>
Remove asm dependencies for the db instance and unregister asm from the OCR:
srvctl modify inst -d <db name> -i <db instance name> -r
srvctl remove asm -n <node name>
2) Edit /etc/oratab (on each node):
Location of oratab on some platforms:
* For AIX, HP-UX, or Linux: /etc/oratab
* For Solaris: /var/opt/oracle/oratab
Changed the ORACLE_SID for the ASM instance, to the reflect the new name for the ASM instance.
Example: Need to change +ASM1 to +ASMADC1:
Change from: +ASM1:/c1/app/oracle/product/11.1.0.6/asm_1:N
Change to: +ASMADC1:/c1/app/oracle/product/11.1.0.6/asm_1:N
3) Rename init files and orapw files (on each node):
Example for node1:
mv $ORACLE_HOME/dbs/init+ASM1.ora $ORACLE_HOME/dbs/init+ASMADC1.ora
mv $ORACLE_HOME/dbs/orapw+ASM1 $ORACLE_HOME/dbs/orapw+ASMADC1
NOTE: Where ORACLE_HOME, is the home for asm
4) Change contents of ASM's instance parameters (on each node):
If using a pfile:
Replace any references to the old asm instance names with the new asm names.
Example:
+ASM1.instance_number=1 -- change to --> +ASMADC1.instance_number=1
If using an spfile:
Connect to the ASM instance, and use SQL commands.
Example on node1 to remove the references to +ASM1:
SQL> alter system reset instance_number sid='+ASM1' scope=spfile;
Example on node1 to set the new value:
SQL> alter system set instance_number=1 sid='+ASMADC1' scope=spfile;
5) Cleanup some directories and files used by the previous ASM instances:
You may choose to back these first for historical purposes only.
If using 10g, on each node remove any directories and files for the older ASM instance under:
$ORACLE_BASE/admin
If using 11g, on each node remove any directories and files for the older ASM instance under:
$ORACLE_BASE/diag/
6) Update the OCR (from one node only. any node):
Example to register the new ASM instance that will run in node1:
srvctl add asm -nadc1-i+ASMADC1-o /c1/app/oracle/product/11.1.0.6/asm_1
Where adc1 is node_name, +ASMADC1 is the new ASM instance name, and the value given to -o is the ORACLE_HOME for the asm instance.
Register each database instance that stores their data in ASM, with the new ASM instance name.
Example:
srvctl modify inst -d <db name> -i <instance name> -s +ASMADC<n>
7) Start up theASM instance (from one node only, any node):
srvctl start asm -n <node name>
8) Start up the database instances that store their data in the ASM instance that you just completed the maintenance (from one node only -any node):
srvctl start db -d <db name>
OR
srvctl start inst -db <db name> -i <instance name>
9) If you have any scripts that have hard-coded ASM instance names, do not forget to also update those.
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
log4j:ERROR Failed to rename错误解决办法 http://www.blogjava.net/DreamAngel/archive/2011/11/10/363400.html
log4j:ERROR Failed to rename错误; 网上查找了下原因,大概意思是日志文件始终被占有,所以当log4j对日志文件进行rename时,就发生了Failed to rename错误 。要修改log4j的源码,附件是我修改好后的,方便大家...
解决log4j:ERROR Failed to rename, win系统占用文件无法改名字的问题
log4j:ERROR Failed to rename
重命名实例Sketch插件 重命名实例是一个很小的Sketch插件,可以将符号实例重命名为其主人的名字。 命令清单: 重命名所有实例-适用于整个文档中的所有实例 重命名当前页面上的所有实例-仅适用于当前页面实例 ...
以前我一直以为File#renameTo(File)方法与OS下面的 move/mv 命令是相同的,可以达到改名、移动文件的目的。不过后来经常发现问题:File#renameTo(File)方法会返回失败(false),文件没有移动,又查不出原因,再后来...
A small program that can be used to rename files AND extensions... I got tired of using DOS to rename the files.
log4j:ERROR Failed to rename错误解决办法,修改源码里的DailyRollingFileAppender类,用此jar包就不会再出现ERROR Failed to rename的错误了
包括修改后的[color=darkred]org.apache.log4j.DailyRollingFileAppender[/color]类的源代码和已编译好的文件. 请用DailyRollingFileAppender.class替换log4j-1.2.15.jar包里相应的类. 博文链接:...
Rename Master is a freeware utility designed to rename multiple files with a just few clicks. Anyone that has worked with websites, file archives, or collections of music, videos, or pictures has ...
you will learn how to delete, rename, and move files as well as how to traverse directory structures the Go way. The last part of this chapter implements a utility that creates a copy of all the ...
Rename zhuru
PHP code for rename file
base.apk.rename
Freerename是一款功能强大并且操作简便的文件改名工具,没有任何使用限制,可以对所有的文件进行快速方便的重命名。 功能介绍 支持对文件及文件夹进行更名; 可以更改文件及文件夹的属性; 可以更改...