环境:
OS:Centos 6.9
DB:11.2.0.4
前提条件:
1.新库的ORACLE_HOME、ORACLE_BASE环境变量跟原库保持一致
2.新库需要创建好oralce账号和相应的组
3.新库安装好相应的系统补丁和环境
1.检查Oracle补丁状态
[oracle@localhost 19023822]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-10-10_15-59-31PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2022-10-10_15-59-31PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (1) : Patch (online) 19023822: applied on Mon Oct 10 15:51:11 CST 2022 Unique Patch ID: 17884511 Created on 28 Jul 2014, 20:54:00 hrs PST8PDT Bugs fixed: 19023822 -------------------------------------------------------------------------------- OPatch succeeded.
2.停止数据库进程
好像不需要停掉数据库的,我这里是在没有停掉数据库的情况下操作的
3.打包ORACLE HOME
[root@localhost oracle]# su - root
[root@localhost oracle]# cd /home/oracle
[root@localhost oracle]# tar -cvf Oracle.tar /u01/app/oracle/product/11.2.0.4/db_1
4.将tar包拷贝到B机
B机环境变量设置成和A机一样
都需要安装scp软件
yum install openssh-clients -y
scp Oracle.tar [email protected]:/home/oracle/
5.目标机器上进行解压
[root@localhost oracle]# pwd
/home/oracle
[root@localhost oracle]# mv Oracle.tar /
[root@localhost /]# cd /
[root@localhost /]# tar -xvf Oracle.tar
修改属主:
[root@localhost /]# chown -R oracle:oinstall /u01
6.现在查看补丁情况
[oracle@localhost bin]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-10-10_16-38-46PM_1.log OPatch failed to locate Central Inventory. Possible causes are: The Central Inventory is corrupted The oraInst.loc file specified is not valid. LsInventorySession failed: OPatch failed to locate Central Inventory. Possible causes are: The Central Inventory is corrupted The oraInst.loc file specified is not valid. OPatch failed with error code 73
6.克隆
[oracle@localhost bin]$ cd /u01/app/oracle/product/11.2.0.4/db_1/clone/bin [oracle@localhost bin]$ /u01/app/oracle/product/11.2.0.4/db_1/perl/bin/perl clone.pl ORACLE_BASE="/u01/app/oracle" ORACLE_HOME="/u01/app/oracle/product/11.2.0.4/db_1" OSDBA_GROUP=dba ./runInstaller -clone -waitForCompletion "ORACLE_BASE=/u01/app/oracle" "ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1" "oracle_install_OSDBA=dba" -defaultHomeName -silent -noConfig -nowait Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 2047 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-10-10_04-41-57PM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production Copyright (C) 1999, 2013, Oracle. All rights reserved. You can find the log of this install session at: /u01/app/oraInventory/logs/cloneActions2022-10-10_04-41-57PM.log .................................................................................................... 100% Done. Installation in progress (Monday, October 10, 2022 4:42:06 PM CST) .............................................................................. 78% Done. Install successful Linking in progress (Monday, October 10, 2022 4:42:12 PM CST) Link successful Setup in progress (Monday, October 10, 2022 4:42:41 PM CST) Setup successful End of install phases.(Monday, October 10, 2022 4:43:04 PM CST) WARNING:A new inventory has been created in this session. However, it has not yet been registered as the central inventory of this system. To register the new inventory please run the script '/u01/app/oraInventory/orainstRoot.sh' with root privileges. If you do not register the inventory, you may not be able to update or patch the products you installed. The following configuration scripts need to be executed as the "root" user. /u01/app/oraInventory/orainstRoot.sh /u01/app/oracle/product/11.2.0.4/db_1/root.sh To execute the configuration scripts: 1. Open a terminal window 2. Log in as "root" 3. Run the scripts The cloning of OraHome1 was successful. Please check '/u01/app/oraInventory/logs/cloneActions2022-10-10_04-41-57PM.log' for more details. 按照提示执行如下脚本(root账号运行) /u01/app/oraInventory/orainstRoot.sh /u01/app/oracle/product/11.2.0.4/db_1/root.sh
这个时候查看补丁情况
[oracle@localhost bin]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-10-10_16-44-53PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2022-10-10_16-44-53PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (1) : Patch (online) 19023822: applied on Mon Oct 10 15:51:11 CST 2022 Unique Patch ID: 17884511 Created on 28 Jul 2014, 20:54:00 hrs PST8PDT Bugs fixed: 19023822 -------------------------------------------------------------------------------- OPatch succeeded.
后面就可以使用dbca创建新的实例了
标签:clone,原库,0.4,11.2,Oracle,oracle,app,pl,u01 From: https://www.cnblogs.com/hxlasky/p/16776328.html