华联oracle ebs系统clone方案rac到非

1、华联 Oracle EBS 系统CLONE 方案（RAC 到非 RAC）文档作者:创建日期:更新日期:2014/6/62014/6/6当前版本:人：华联项目经理IBM项目经理文档控制更改传阅分发Copy名称地点No.1234职位日期作者版本更改备注2014/6/6V1.0目录文档控制ii更改 ii传阅ii分发iiPreclone4数据库(ebsdb1 和 ebsdb2)4应用(ebsapp1 或 ebsapp2)4CLONE5数据库5应用14其他工作15登录修改15附件16附件 116附件 217附件 319附件 421Preclone数据库(ebsdb1)su - oraprodcd /u0

2、1/prod/db/11.2.0/appsutil/scripts/ PROD1_ebsdb1perl ./reclone.pl dbTier应用(ebsapp1)su - applprodcd /u01/prod/inst/apps/PROD_ebsapp1/admin/scriptsperl ./reclone.pl appsTierCLONE数据库1.备份生产数据库(ebsdb1)用 root 用户运行/home/oraprod/backupdb.sh内容见附录 12.将/backup/data 中的文件拷贝到目的数据库节点同样目录下如拷贝到其他目录，则需要建立符号修改权限n R ora

3、dev:dba/backup/data3.将生产环境tech_st 拷贝到数据库节点同样目录下,如拷贝到其他目录，则需要建立符号修改权限n -R oradev:dba /u01/prod/export ORACLE_HOME=/u01/prod/db/11.2.0export PATH=$ORACLE_HOME/bin:$PATH4.生成新的控制文件运行环境变量切换到 db 用户# su -oradevexportORACLE_SID=PROD1exportORACLE_HOME=/u01/prod/db/11.2.0exportPATH=$ORACLE_HOME/bin:$PATHexpor

4、tLD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH/u02/dev/db/tech_st/11.2.0重新编译 rdbms，关闭其 RAC 选项cd $ORACLE_HOME/rdbms/libcp $ORACLE_HOME/rdbms/lib/libskgxns.a $ORACLE_HOME/libmake -f ins_rdbms.mk rac_offmake -f ins_rdbms.mk ioracle编辑 initPROD1.oracd /u01/prod/db/11.2.0/dbs编辑 initPROD1.ora内容见附件 2建立/

5、u01/prod/db/apps_st/data 目录并修改权限n R oradev:dba /oradb/db/apps_st/data将生产环境下 /u01/backup/同样目录trol/下的的备份的控制文件拷贝到新环境的恢复控制文件oradev 用户sqlplus / as sysdbasqlstartup nomountsqlexitrman/rmanrestore*-*trolfile from /backup/trol/f_c-*-SQL alter database mount;恢复数据库alter database rename file +PRODDATA/prod/onl

6、inelog/group_5.300.843009221to /u01/prod/db/apps_st/data/group_5.300.843009221;alter database rename file +PRODDATA/prod/onlinelog/group_4.299.843009221 /u01/prod/db/apps_st/data/group_4.299.843009221;toalter database rename file +PRODDATA/prod/onlinelog/group_3.298.843009219to /u01/prod/db/apps_st/

7、data/group_3.298.843009219;alter database rename file +PRODDATA/prod/onlinelog/group_6.307.843051491 /u01/prod/db/apps_st/data/group_6.307.843051491;toalter database rename file +PRODDATA/prod/onlinelog/group_2.297.843009219 /u01/prod/db/apps_st/data/group_2.297.843009219;toalter database rename fil

8、e +PRODDATA/prod/onlinelog/group_7.308.843051491 /u01/prod/db/apps_st/data/group_7.308.843051491;toalter database rename file +PRODDATA/prod/onlinelog/group_1.296.843009217 /u01/prod/db/apps_st/data/group_1.296.843009217;toalter database rename file +PRODDATA/prod/onlinelog/group_8.309.843051493 /u0

9、1/prod/db/apps_st/data/group_8.309.843051493;toalter database rename file +PRODDATA/prod/onlinelog/group_9.310.843051493 /u01/prod/db/apps_st/data/group_9.310.843051493;toalter database rename file +PRODDATA/prod/onlinelog/group_10.311.843051495 to /u01/prod/db/apps_st/data/group_10.311.843051495;不能

10、硬抄RMANrunallocate channeld1 type disk;allocate channeld2 typedisk;allocate channeld3 typedisk;allocate channeld4 typedisk;allocate channeld5 typedisk;allocate channeld6 typedisk;set newname for datafile11 to/u01/prod/db/apps_st/data/system.269.843008689;set newname for datafile 10 to /u01/prod/db/ap

11、ps_st/data/system.268.843008685;set newname for datafile 9 to /u01/prod/db/apps_st/data/system.267.843008679;set newname for datafile 8 to /u01/prod/db/apps_st/data/system.266.843008675;set newname for datafile 7 to /u01/prod/db/apps_st/data/system.265.843008669;set newname for datafile 6 to /u01/pr

12、od/db/apps_st/data/system.264.843008665;set newname for datafile 5 to /u01/prod/db/apps_st/data/system.263.843008659;set newname for datafile 4 to /u01/prod/db/apps_st/data/system.262.843008655;set newname for datafile 3 to /u01/prod/db/apps_st/data/system.261.843008645;set newname for datafile 2 to

13、 /u01/prod/db/apps_st/data/system.260.843008639;set newname for datafile 1 to /u01/prod/db/apps_st/data/system.259.843008633;set newname for datafile 12 to /u01/prod/db/apps_st/data/apps_undots1.270.843008693;set newname for datafile 13 to /u01/prod/db/apps_st/data/apps_ts_archive.271.843008717;set

14、newname for datafile 14 to /u01/prod/db/apps_st/data/apps_ts_erface.272.843008733;set newname for datafile 15 to /u01/prod/db/apps_st/data/apps_ts_media.273.843008753;set newname for datafile 16 to /u01/prod/db/apps_st/data/apps_ts_nologging.274.843008781;set newname for datafile 17 to /u01/prod/db/

15、apps_st/data/apps_ts_queues.275.843008783;set newname for datafile 18 to /u01/prod/db/apps_st/data/apps_ts_queues.276.843008793;set newname for datafile 19 to /u01/prod/db/apps_st/data/apps_ts_seed.277.843008803;set newname for datafile 20 to /u01/prod/db/apps_st/data/apps_ts_seed.278.843008825;set

16、newname for datafile 21 to /u01/prod/db/apps_st/data/apps_ts_summary.279.843008859;set newname for datafile 22 to /u01/prod/db/apps_st/data/apps_ts_tx_data.280.843008881;set newname for datafile 23 to /u01/prod/db/apps_st/data/apps_ts_tx_data.281.843008925;set newname for datafile 24 to /u01/prod/db

17、/apps_st/data/apps_ts_tx_data.282.843008969;set newname for datafile 37 to /u01/prod/db/apps_st/data/apps_ts_tx_data.295.843009173;set newname for datafile 25 to /u01/prod/db/apps_st/data/apps_ts_tx_idx.283.843009011;set newname for datafile 26 to /u01/prod/db/apps_st/data/apps_ts_tx_idx.284.8430090

18、37;set newname for datafile 27 to /u01/prod/db/apps_st/data/apps_ts_tx_idx.285.843009067;set newname for datafile 28 to /u01/prod/db/apps_st/data/apps_ts_tx_idx.286.843009103;set newname for datafile 29 to /u01/prod/db/apps_st/data/apps_ts_tx_idx.287.843009129;set newname for datafile /u01/prod/db/a

19、pps_st/d30to txd.288.843009157;set newname for datafile31to/u01/prod/db/apps_st/data/odm.289.843009157;set newname for datafile 32 to /u01/prod/db/apps_st/data/olap.290.843009157;set newname for datafile 33 to /u01/prod/db/apps_st/data/owapub.291.843009159;set newname for datafile 34 to /u01/prod/db

20、/apps_st/data/portal.292.843009159;set newname for datafile 35 to /u01/prod/db/apps_st/data/sysaux.293.843009161;set newname for datafile 36 to /u01/prod/db/apps_st/data/apps_ts_tools.294.843009163;set newname for datafile 38 to /u01/prod/db/apps_st/data/undotbs2.313.843051635;restore database;switc

21、h datafileall;release channeld1;release channeld2;release channeld3;release channeld4;release channeld5;release channeld6;文件生成方法见附录 4cd /homen -R oradev:dba archRMANrecover database;SQLalter database open resetlogs;5.加tempspaceSQL alter tablespace TEMP1 /u01/prod/db/apps_st/daadd tempfileemp01.dbf s

22、ize 2000m reuse;SQL alter tablespace TEMP2 /u01/prod/db/apps_st/daadd tempfileemp02.dbf size 2000m reuse;6.Tablespace altered.sqlplus apps/appsSQLDelete from fnd_nodes;SQLcommit;7.做数据库clone（会失败，主要目的生成xml 配置文件和initdev.ora）停数据库sqlplus /as sysdbaSQL shutdown immediateCloneoradev 用户export PATH=/u02/dev/

23、db/tech_st/11.2.0/perl/bin:$PATHcd /u02/dev/db/tech_st/11.2.0/appsutil/clone/binexportERLPRG=/u02/dev/db/tech_st/11.2.0/perl/bin/perlexport PERL5LIB=/u02/dev/db/tech_st/11.2.0/perl/lib/5.10.0:/u02/dev/db/tech_st/ 11.2.0/perl/lib/site_perl/5.10.0:/u02/dev/db/tech_st/11.2.0/appsutil/per lexport PATH=/

24、usr/local/bin:/usr/vac/bin:/usr/vacpp/bin:$PATHperl ./adcfgclone.pl dbTierEnter the APPS password :System Hostname(virtual or normal) ebsuatdb :Instance is RAC(y/n)y : nSystem DatabaseSID :devSystem Base Directory: /u02/devSystem utl_file_dir Directory List : /usr/tmp/devNumberof DATA_TOPs on theSys

25、tem 3 : 1System DATA_TOP Directory 1 : /u02/dev/db/apps_st/dataSystem RDBMS ORACLE_HOME Directory /u02/dev/db/tech_st/11.2.0:System Archive Log Directory /u02/dev/db/apps_st/data/archive:Do youwant to preserve the Display ebsdb1:1.0 (y/n) : nSystem Display ebsuatdb:0.0:Do you want the the sourystem

26、(y/n) ysystem to? : nhavethesameportvalues astheSystem Port Pool 0-99: 50会失败+8.重建控制文件运行环境变量切换到db 用户# su oradevexportORACLE_HOME=/u02/dev/db/tech_st/11.2.0exportORACLE_SID=devexportPATH=$ORACLE_HOME/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH修改生成好的 initdev.ora删除 local_listener =

27、dev_LOCAL修改compatible = SQL trol.sql见附录 39.加入thread 2 logALTER DATABASE ADD LOGFILE THREAD 2GROUP 4 (/u02/dev/db/apps_st/data/log04a.dbf,/u02/dev/db/apps_st/data/log04b.dbf) SIZE 50M,GROUP 5 (/u02/dev/db/apps_st/data/log05a.dbf,/u02/dev/db/apps_st/data/log05b.dbf) SIZE 50M,GROUP 6 (/u02/dev/db/apps_

28、st/data/log06a.dbf,/u02/dev/db/apps_st/data/log06b.dbf) SIZE 50M;10. 启动数据库SQLalter database open resetlogs;11. 加tempspaceSQLalter tablespace TEMP1 add tempfile/u02/dev/db/apps_st/daemp01.dbf size 2000m reuse;SQLalter tablespace TEMP2 add tempfile/u02/dev/db/apps_st/daemp02.dbf size 2000m reuse;SQLAl

29、ter database disable thread 2;12. Autufig运行autofig运行cd /u02/dev/db/tech_st/11.2.0/appsutil/scripts/dev_ebsuatdb./adautocfg.sh运行新环境变量cd /u02/dev/db/tech_st/11.2.0. ./dev_ebsuatdb.env启动lsnrctl start dev启数据库sqlplus / as sysdbaSQLstartup应用su - appldevcd /u01/den/clone/binperl ./adcfgclone.pl appsTier跟随提

30、示完成应用clone附件附件 1su - oraprod -c “rman/” EOFrun allocate channelt1 typedisk;allocate channelt2 typedisk;allocate channelt3 typedisk;allocate channelt4 typedisk;allocate channelt5 typedisk;allocate channelt6 typedisk;BACKUP INCREMENTAL LEVEL 0 FILESPERSET 10 FORMAT/backup/data/full_%T_%s_%p_%U DATABAS

31、E;sql alter system archive log current;BACKUP FILESPERSET 10 MAXSETSIZE 10GFORMAT /backup/data/arch_%T_%s_%p_%USKIP INACSIBLEARCHIVELOG ALL DELETE INPUT;releasechannelt1;releasechannelt2;releasechannelt3;releasechannelt4;releasechannelt5;releasechannelt6;exit;EOF附件 2PROD1. db_cache_size=687865856PRO

32、D1. java_pool_size=33554432PROD1. large_pool_size=16777216PROD1. oracle_base=/u01/prod/db#ORACLE_BASEset fromenvironmentPROD1. pga_aggregate_=1073741824PROD1. sga_=2147483648PROD1. shared_io_pool_size=0PROD1. shared_pool_size=1358954496PROD1. streams_pool_size=16777216*._b_tree_bitmap_plans=false*._

33、fast_full_scan_enabled=false*mit_propagation=TRUE*._like_with_bind_as_equality=true*._lm_global_ts=TRUE*._optimizer_autoss_job=false#Turn outomatic sistics.*._sort_elimination_cost_ratio=5*._sqlexec_progres_cost=2147483647*._system_trig_enabled=true*._trace_files_public=TRUE*.aq_tm_proses=4PROD1.clu

34、ster_database=false*.compatible=*. storetrol_files=/u01/prod/db/apps_st/d-trolfileurrent.296.739807121#Re*.cursor_sharing=EXACT*.db_block_checking=FALSE*.db_block_checksum=TRUE*.db_block_size=8192*.db_files=512# Max. no. of database files.*.db_name=prod*.diagnostic_dest=/u01/prod/db/11.2.0*.dml_lock

35、s=10000# Database locks.PROD1.instance_number=1*.job_queue_proses=10*.log_archive_dest_1=location=/home/arch*.log_buffer=10485760*.log_checkpo_erval=100000*.log_checkpo_timeout=1200# Checkpoeast every 20 mins.*.log_checkpos_to_alert=TRUE*.max_dump_file_size=20480#Limit defaulttracefilesizeto10MB.*p=

36、binary*.nls_date_format=DD-MON-RR*.nls_language=american*.nls_length_sems=BYTE*.nls_numeric_characters=.,*.nls_sort=binary*.nls_territory=america*.o7_dictionary_acsibility=FALSE*.olap_page_pool_size=4194304*.open_cursors=3600*.optimizer_secure_view_merging=false*.parallel_max_servers=8# Max. value s

37、houldbe 2x no. of CPUs.*.parallel_min_servers=0*.pga_aggregate_=1G*.proses=1200# Max. no. of users.*.sec_case_sensitive_logon=false*.ses_cached_cursors=500*.sess=2400# 2 x no. of proses.*.sga_=2G*.shared_pool_size=60M*.shared_pool_size=600MPROD1.thread=1PROD2.thread=2*.timed_sistics=true*.undo_manag

38、ement=AUTOPROD1.undo_tablespace=APPS_UNDOTS1PROD2.undo_tablespace=UNDOTBS2*.utl_file_dir=/usr/tmp*.workarea_size_policy=AUTO附件 3STARTUP NOMOUNTCREATETROLFILE set DATABASE dev RESETLOGSNOARCHIVELOG- SET STANDBY TOIZE PERFORMANCEMAXLOGFILES 32MAXLOGMEMBERS 5MAXDATAFILES 1024MAXINSTAN8MAXLOGHISTORY 726

39、0LOGFILEGROUP 1 (/u02/dev/db/apps_st/data/log01a.dbf,/u02/dev/db/apps_st/data/log01b.dbf) SIZE 150M,GROUP 2 (/u02/dev/db/apps_st/data/log02a.dbf,/u02/dev/db/apps_st/data/log02b.dbf) SIZE 150M,GROUP 3 (/u02/dev/db/apps_st/data/log03a.dbf,/u02/dev/db/apps_st/data/log03b.dbf) SIZE 150MDATAFILE/u02/dev/

40、db/apps_st/data/system.269.843008689,/u02/dev/db/apps_st/data/system.268.843008685,/u02/dev/db/apps_st/data/system.267.843008679,/u02/dev/db/apps_st/data/system.266.843008675,/u02/dev/db/apps_st/data/system.265.843008669,/u02/dev/db/apps_st/data/system.264.843008665,/u02/dev/db/apps_st/data/system.2

41、63.843008659,/u02/dev/db/apps_st/data/system.262.843008655,/u02/dev/db/apps_st/data/system.261.843008645,/u02/dev/db/apps_st/data/system.260.843008639,/u02/dev/db/apps_st/data/system.259.843008633,/u02/dev/db/apps_st/data/apps_undots1.270.843008693,/u02/dev/db/apps_st/data/apps_ts_archive.271.843008717,/u02/dev/db/apps_st/data/apps_ts_erface.272.843008