R12详细克隆步骤

资料来源:http://blog.chinaunix.net/uid-15866552-id-3579958.html

                                              R12克隆详细步骤
Total: 16 hours(10M bankwidth)
###################  Clone and backup  ####################
＃＃＃＃＃＃  前期准备  ＃＃＃＃＃＃＃＃＃＃＃＃＃
过程需要8 0分钟
1。 APP 层autoconfig
切换到app用户： [appcrp12@dlhs1201 scripts]$ su - appcrp12
cd  /d01/oracle/crp12/inst/apps/crp12_dlhs1201/admin/scripts
[appcrp12@dlhs1201 scripts]$ sh adautocfg.sh
2 。对appsutil 进行同步化
[appcrp12@dlhs1201 scripts]$ perl /d01/oracle/crp12/apps/apps_st/appl/ad/12.0.0/bin/admkappsutil.pl  

以上命令会在/d01/oracle/crp12/inst/apps/crp12_ebs12/admin/out生成一个appsutil.zip文件。把这个文件复制到/d01/oracle/PROD/apps/tech_st/10.1.2目录。

在终端执行如下命令：
切换到app用户： [appcrp12@dlhs1201 scripts]$ su - appcrp12
＃＃＃原文章说要加在环境变量： . /d01/oracle/PROD/db/tech_st/10.2.0/PROD_ebs12.env  ( I don't think so )
切换到目标目录： [oracrp12@dlhs1201 ~]$ cd /d01/oracle/crp12/apps/tech_st/10.1.2/
复制文件：
cp -rap /d01/oracle/crp12/inst/apps/crp12_dlhs1201/admin/out/appsutil.zip /d01/oracle/crp12/apps/tech_st/10.1.2/
切换目录：
[appcrp12@dlhs1201 scripts]$ cd /d01/oracle/crp12/apps/tech_st/10.1.2/
备份目录：
[appcrp12@dlhs1201 10.1.2]$ cp -rap appsutil appsutil.bak
[applcrp@ebs36 10.1.2]$ rm -rf appsutil
解压缩：
 unzip -o appsutil.zip
3。 数据库层autoconfig
切换到DB用户：
[appcrp12@dlhs1201 10.1.2]$ su - oracrp12
切换目录：
[oracrp12@dlhs1201 ~]$ cd /d01/oracle/crp12/db/tech_st/11.1.0/appsutil/scripts/crp12_dlhs1201/
执行autoconfig
[oracrp12@dlhs1201 crp12_dlhs1201]$ sh adautocfg.sh
4。 维护快照：
切换到app用户：
[oracrp12@dlhs1201 crp12_dlhs1201]$ su - appcrp12
启动adadmin工具
[appcrp12@dlhs1201 ~]$ adadmin

2）按照如下顺序进行快照（Snapshop）＃＃以后不做这一步了，太浪费时间了（60分钟）

[2.Maintain Applications Files menu] → [4.Maintain snapshot information] → [2.Update current view snapshot] → [ 1.Update Complete APPL_TOP]

3）关闭维护模式

4）退出adadmin。

＃＃＃＃＃＃＃克隆文件复制 ＃＃＃＃＃＃＃＃

About 3 hours

Adpreclone实行

DB层adpreclone：
切换到DB用户：[appcrp12@dlhs1201 10.1.2]$ su - oracrp12
切换到相应目录： cd /d01/oracle/PROD/db/tech_st/10.2.0/appsutil/scripts/PROD_ebs12
执行预克隆： perl adpreclone.pl dbTier


App层adpreclone：
切换到app用户： [oracrp12@dlhs1201 crp12_dlhs1201]$ su - appcrp12
切换到相应目录： cd /d01/oracle/PROD/inst/apps/PROD_ebs12/admin/scripts
执行预克隆：      perl adpreclone.pl appsTier

停止app层
切换到app用户[oracrp12@dlhs1201 crp12_dlhs1201]$ su - appcrp12
切换到相应目录： cd /d01/oracle/PROD/inst/apps/PROD_ebs12/admin/scripts
执行停止app层命令： ./adstpall.sh apps/apps

停止db层
切换到DB层用户： [appcrp12@dlhs1201 10.1.2]$ su - oracrp12
切换到相应目录：  cd /d01/oracle/PROD/db/tech_st/10.2.0/appsutil/scripts/PROD_ebs12
执行停止服务：     ./addbctl.sh stop immediate
注意： 一定要保证DB和APP层的服务是正常关闭的，并且反复检查进程是否都结束了在执行下一步。


停止listener：
./addlnctl.sh stop PROD

复制文件即可：
( Don't replicate inst directory, Because It can be automatical generate )

cp –RH /d01/oracle/PROD/db/* /db的目标文件夹

cp –RH /d01/oracle/PROD/apps/* /apps 的目标文件夹
inst文件夹不需要复制，利用以上两个文件夹可以，通过恢复操作可以生成inst文件夹。

######  Clone file transfer  ########
About 4 hours

###################  Recover clone  #####################
######  Prepare for recover  ##########
About 3 hours
1. [root@testone u01]# mkdir /u01
2. tar zxvf apps.tgz -C /u01/
3. tar zxvf db.tgz -C /u01/
4. [root@testone u01]# chown -R oracrp.dba db
5. [root@testone u01]# chown -R applcrp.dba apps/
6. [root@testone u01]# chmod -R 775 /u01/

######   Recover processing  #########
About 3 hours
0. chmod -R 777 /tmp/
1. [root@testone u01]# su - oracrp
2. [oracrp@testone /]$ cd /u01/db/tech_st/11.1.0/appsutil/clone/bin/

####   DB Tier  ######
3. [oracrp@testone bin]$ perl adcfgclone.pl dbTier
Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [testone] :

Target Instance is RAC (y/n) [n] :

Target System Database SID : crp12bak

Target System Base Directory : /u01

Target System utl_file_dir Directory List : /usr/tmp/crp12bak

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/d01/oracle/crp12/db/apps_st/data] : /u01/db/apps_st/data

Do you want to preserve the Display [null] (y/n) ? :

Target System Display [testone:0.0] :

Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 4

######  App Tier   ######
 
1. [oracrp@testone bin]$ su - applcrp

2. [applcrp@testone ~]$ cd /u01/apps/apps_st/comn/clone/bin/

3. [applcrp@testone bin]$ perl adcfgclone.pl appsTier
注释：所涉及到的参数包括端口号，都必须和DB层的一样即可，参考DB层来操作。

Enter the APPS password :
Target System Hostname (virtual or normal) [testone] :
Target System Database SID : crp12bak

Target System Database Server Node [testone] :
Target System Base Directory : /u01
Target System Tools ORACLE_HOME Directory [/u01/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/u01/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/u01/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/u01/apps/apps_st/comn] :

Target System Instance Home Directory [/u01/inst] :
Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :
Do you want to preserve the Display [dlhs1201:0.0] (y/n) ? : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 4

Choose a value which will be set as APPLPTMP value on the target node [1] : 3

### ######   Restart new EBS instance    ######## ##

####   user environment variable file   #######
[root@dlhs1201 appcrp02]# vim /home/ appcrp02/.bash_profile
. /u01/apps/apps_st/appl/APPSebsr12_dlhs1201.env
Save and quit
[root@dlhs1201 appcrp02]# vim /home/ oracrp02/.bash_profile
. /u01/db/tech_st/11.1.0/ebsr12_dlhs1201.env
Save and quit

####  Start and Stop script  #######
###  DB Tier  ###
[appcrp02@dlhs1201 ~]$ cat startappTier.sh
#!/bin/bash
source /home/appcrp02/.bash_profile
$INST_TOP/admin/scripts/adstrtal.sh apps/apps
echo "Wait 120S, It will start successful"

[appcrp02@dlhs1201 ~]$ cat stopappTier.sh
#!/bin/bash
source /home/appcrp02/.bash_profile
date=`date +%Y%m%d%H%M`
firsttime=1
lasttime=40
$INST_TOP/admin/scripts/adstpall.sh apps/apps
sleep 300s
aaa=12
while [ "$aaa" -ge 2 ]
do
echo "It's running, for a moment."
aaa=`ps -ef | grep FND* | wc -l | awk '{print $1}'`
sleep 60s
if [ $firsttime -lt $lasttime ];then
echo "Wait ten second, It's stopping"
else
break;
fi
let "firsttime++"
done
#Kill process of unfinished
echo "Wait for a moment, It's running kill script"
ps -ef | grep FND* | awk '{print $2}'>/home/appcrp02/FNDpid.txt
for FNDpid in `cat /home/appcrp02/FNDpid.txt`;
do
kill -9 "$FNDpid"
done
echo "It's stopping successful"
sleep 20s
rm -rf /home/appcrp02/FNDpid.txt
echo -e "Yeah  \nIt's ok"

###  DB Tier  ###
[oracrp02@dlhs1201 ~]$ cat startDBTier.sh
#!/bin/bash
$ORACLE_HOME/appsutil/scripts/ebsr12_ebs36/addlnctl.sh start ebsr12
$ORACLE_HOME/appsutil/scripts/ebsr12_ebs36/addbctl.sh start ebsr12

[oracrp02@dlhs1201 ~]$ cat stopDBTier.sh
#!/bin/bash
$ORACLE_HOME/appsutil/scripts/ebsr12_ebs36/addbctl.sh stop immediate ebsr12
PSline=12
while [ "$PSline" -ge 2 ]
do
echo "It's running, for a moment."
PSline=`ps -ef | grep ora_ | wc -l | awk '{print $1}'`
sleep 5s
done
$ORACLE_HOME/appsutil/scripts/ebsr12_ebs36/addlnctl.sh stop ebsr12
echo -e "Yeah  \nIt's ok"


####   Stop EBS service  ####

0. [root@testone u01]# chmod -R 775 /u01/

1. [root@testone 10.1.2]# cd /u01/apps/apps_st/appl/
2. [root@testone appl]# source /home/applcrp/.bash_profile
3. [root@testone crp12bak_testone]# cd /u01/inst/apps/crp12bak_testone/admin/scripts/

4. [root@testone scripts]# sh adstpall.sh apps/apps

5. [oracrp@testone bin]$ su - oracrp

6. [oracrp@testone 11.1.0]$ cd /u01/db/tech_st/11.1.0

7. [oracrp@testone 11.1.0]$ vim /home/oracrp/.bash_profile
. /u01/db/tech_st/11.1.0/crp12bak_testone.env
save and quit

8. [oracrp@testone 11.1.0]$ source /home/oracrp/.bash_profile

9. [oracrp@testone 11.1.0]$ cd /u01/db/tech_st/11.1.0/appsutil/scripts/crp12bak_testone/

10. [oracrp@testone crp12bak_testone]$ sh addlnctl.sh stop crp12bak

11. [oracrp@testone crp12bak_testone]$ sh addlnctl.sh status crp12bak

12. [oracrp@testone crp12bak_testone]$ set ORACLE_SID=crp12bak

13. [oracrp@testone crp12bak_testone]$ echo $ORACLE_SID

14. [oracrp@testone crp12bak_testone]$ sh addbctl.sh stop immediate

####   Start EBS service  ####

15. [oracrp@testone crp12bak_testone]$ sh addlnctl.sh start crp12bak

16. [oracrp@testone crp12bak_testone]$ sh addlnctl.sh status crp12bak

17. [oracrp@testone crp12bak_testone]$ sh addbctl.sh start

18. [oracrp@testone crp12bak_testone]$ su - applcrp

19. cd $INST_TOP/admin/scripts/

20. [applcrp@testone scripts]$ sh adstrtal.sh apps/apps

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15187685/viewspace-759727/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15187685/viewspace-759727/