oracle基于相同配置对数据库Home克隆
“Oracle home”（简称"$ORACLE_HOME"）是一个重要的概念，它指的是Oracle软件安装的根目录,包含了数据库软件的所有组件，包括二进制文件、库文件、脚本和配置文件等
env
- centos6.5
这个对home目录克隆及迁移部署，我怎么感觉没有太多方便的后面还是需要建立实例及监听信息，目标库应该也要安装依赖的…
1.关闭原数据库
sqlplus / as sysdba
shutdown immediate
lsnrctl stop
# 查看oracle进程
ps –ef|grep ora_
2.对$ORACLE_BASE目录下的product进行备份
zip –r product.zip product
3.移动到目标机器或目标目录解压
unzip –d target_path product.zip # 或者在目标目录下 unzip product.zip
4.删除解压后的product/network/admin下面的ora文件
rm *.ora ###清理监听文件
5.运行runinstaller
$ORACLE_HOME/oui/bin/runinstaller –silent –clone ORACLE_BASE='productd的当前目录' ORACLE_HOME='oracle_home目录' ORACLE_HOME_NAME='这个名字随便取一个'
注：运行以上命令会出现一个字符界面的进度条，全部运行完后你运行一个脚本root.sh,以root 运行一路回车就ok了
cd product/11.2.0/dbhome_1/oui/bin
[oracle@oracle-111 bin]$ ./runInstaller -silent -clone ORACLE_HOME='/data/clone_oracle/product/11.
2.0/dbhome_1' ORACLE_HOME_NAME='clone' Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1535 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-02-27_06-41-44AM. Please w
ait ...[oracle@oracle-111 bin]$ Oracle Universal Installer, Version 11.2.0.4.0 ProductionCopyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/data/oraInventory/logs/cloneActions2017-02-27_06-41-44AM.log
Values for the following variables could not be obtained from the command line or response file(s)
: ORACLE_BASE
Cloning cannot continue. ###第一次没指定ORACLE_BASE目录导致的错误
[oracle@oracle-111 bin]$ ./runInstaller -silent -clone ORACLE_BASE='/data/clone_oracle' ORACLE_H
OME='/data/clone_oracle/product/11.2.0/dbhome_1' ORACLE_HOME_NAME='clone' -noConfig -nowaitStarting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 1535 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-02-27_06-43-34AM. Please w
ait ...[oracle@oracle-111 bin]$ Oracle Universal Installer, Version 11.2.0.4.0 ProductionCopyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/data/oraInventory/logs/cloneActions2017-02-27_06-43-34AM.log
..................................................................................................
.. 100% Done.
Installation in progress (Monday, February 27, 2017 6:43:59 AM CST)
..............................................................................
78% Done.Install successful
Linking in progress (Monday, February 27, 2017 6:44:08 AM CST)
Link successful
Setup in progress (Monday, February 27, 2017 6:46:56 AM CST)
Setup successful
End of install phases.(Monday, February 27, 2017 6:47:47 AM CST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
/data/clone_oracle/product/11.2.0/dbhome_1/root.sh ###以root身份运行root.sh文件
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The cloning of clone was successful.
Please check '/data/oraInventory/logs/cloneActions2017-02-27_06-43-34AM.log' for more details.
[oracle@oracle-111 bin]$ cd ..
6.设置oracle环境变量
cd ~
vim .bash_profile
#export ORACLE_SID=mvp
export ORACLE_BASE=/data/clone_oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
export PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:$HOME/bin
7.建立数据库实例及监听
netca ###监听
dbca ###实例
启动新建的实例
sqlplus / as sysdba startup exit