How to move RAC Database ORACLE_HOME from one location to another one (Doc ID 1438719.1)
来源:互联网 发布:vb断点调试 编辑:程序博客网 时间:2024/05/17 07:24
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 <dbname>
6. Modify the database resource as with srvctl from the old database home: srvctl modify database -d -o <new-database-home>
7. Start the database with srvctl from the new database home: srvctl start database -d <dbname>
Solution 2: (Clone)
1. Copy existing RAC binaries to a new location and keep the same ownership/permission on any node: cp -rp <old-database-home> <new-database-home>
2. Execute: <new-database-home>/oui/bin/runInstaller -clone -silent ORACLE_HOME="<new-oracle-home>" ORACLE_HOME_NAME="<unique-new-home-name>"
3. Extend the new home to other nodes: <new-database-home>/oui/bin/addNode.sh
4. Go to Step3 of "Solution 1"
- How to move RAC Database ORACLE_HOME from one location to another one (Doc ID 1438719.1)
- How to move ASM database files from one diskgroup to another
- How to move ASM database files from one diskgroup to another
- How to move Oracle data from one machine to another
- Move all database objects from one tablespace to another
- How to Export and Import the AWR Repository From One Database to Another (文档 ID 785730.1)
- Transfer Statistics from one Database to Another
- Move an installed (Open)Solars from one disk to another
- How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1)
- How Can One Transfer Xcode 4 Code Snippets from One Machine to Another
- another one: how to do research?
- Transferring Data from One Table to Another
- Migrating Queries from One User To Another
- copy from one array to another
- How to move a datafile from a file system to ASM (Doc ID 390274.1)
- How to move a datafile from a file system to ASM (Doc ID 390274.1)
- STEP BY STEP RMAN DUPLICATE Database From RAC ASM To RAC ASM (Doc ID 1913937.1)
- How to export/import data with LOB type from one user/schema to another
- 分布式中 CAP BASE ACID 理解
- 单例模式随记
- C++实现二分查找(递归方法和非递归方法)
- mysql导出select结果到文件
- 安卓应用+服务端应用 开发
- How to move RAC Database ORACLE_HOME from one location to another one (Doc ID 1438719.1)
- Ubuntu由于修改etc/profile文件导致开机无法登陆问题解决办法(仅供参考)
- 图片压缩
- 杂志征订的业务设计
- Eclipse中如何恢复已删除文件
- zabbix2.4安装笔记
- Ubuntu-几个命令
- java项目分以及各个层的作用
- 点击按钮显示/隐藏答案