数据库|mysql教程
How,move,RAC,Database,ORACLE,t
数据库-mysql教程
oa流程审核源码,ubuntu 开启工作区,爬虫 深度优先 算法,用php创建表单计算两数的乘积,seo外包总部lzw
In this Document Goal Solution Applies to: Oracle Database – Enterprise Edition – Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2] Information in this document applies to any platform. Goal What are the steps to move the RAC database OR
discuz 搜索源码,vscode错误怎么解决,ubuntu关闭限制,tomcat漏洞新闻,sqlite 判断某列为空,四个角的骷髅爬虫,点卡 php,大连seo优化效果,儿童服装网站模板,网页实现平滑滚动效果,交互式后台管理模板lzw
spring mvc 后台源码,ubuntu 挂接的硬盘,爬虫案例分析图,php yied,杭州seo工作lzw
In this Document
Applies to: Oracle Database – Enterprise Edition – Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Goal
What are the steps to move the RAC database ORACLE_HOME from one location(filesystem) to another one?
This note is for database home only and does not apply to CRS or GI home.
Solution
Execute all the following as database user:
Solution 1:
1. Install a new set of RAC binaries with OUI into a new home
2. Apply all patches that have been installed in the old home, use “opatch lsinventory” to compare the old and new home once all patches are applied.
3. Copy over init{ORACLE_SID}.ora in dbs directory from the old home to the new home on all nodes
4. Copy over network files (listener.ora, tnsnames.ora, and sqlnet.ora) in network/admin directory from the old home to the new home on all nodes
5. Shutdown the database with srvctl from the old database home: srvctl stop database -d
6. Modify the database resource as with srvctl from the old database home: srvctl modify database -d -o
7. Start the database with srvctl from the new database home: srvctl start database -d
Solution 2: (Clone)
1. Copy existing RAC binaries to a new location and keep the same ownership/permission on any node: cp -rp
2. Execute: /oui/bin/runInstaller -clone -silent ORACLE_HOME=”” ORACLE_HOME_NAME=””
3. Extend the new home to other nodes: /oui/bin/addNode.sh
4. Go to Step3 of “Solution 1”