PeopleSoft系统克隆详细说明.docx

1、PeopleSoft系统克隆详细说明管理信息系统项目人力资源系统系统复制操作说明书中国有限公司有效期至 年 月 日文档管理记录更改记录日期作者版本更改参考审核记录姓名职位分发记录姓名职位目录目录 31. 内容概述 42. 复制数据库 62.1 生成SOURCE数据库控制文件的trace文件 62.2 复制数据库数据文件 222.3 生成 init.ora 文件 232.4 执行 recreate_Target.sql 242.5 配置 LISTENER 243. 复制PS系统文件 271. 内容概述PeopleSoft在初始安装系统时，提供了两种系统，一种是system系统，即只有系统数据，没

2、有任何业务数据，另一种是demo系统，包含了部分演示业务数据。我们在项目中，使用的所有系统都是由这两种系统复制生成的。具体关系图如下： 所以，在项目中，真正的安装系统只需要进行两次，即分别安装一套system和一套demo系统，而复制（clone）系统，作为构建新系统或是系统的备份，是会经常使用到的手段。基于PeopleSoft的技术特点，复制(clone)一套系统，需要执行的操作顺序是：1复制数据库、2复制PS系统文件（可选）、3新建各种服务，而其中最重要的工作是复制数据库。2. 复制数据库这里，我们为了方便说明，特假设源数据库的数据库SID为：SOURCE，而新建的目标数据库SID为：TA

3、RGET; oracle 用户为数据库的DBA，并且oracle 数据文件的目录为 /app/oracle/oradata/2.1 生成SOURCE数据库控制文件的trace文件 以DBA的身份登录SOURCE数据库并启动该数据库 Login as oracle/oracle ORACLE_SID=SOURCE;export ORACLE_SID sqlplus “/as sysdba” startup 执行备份命令 alter database backup controlfile to trace; 关闭数据库 shutdown immediate 注意：一定要确保数据库完全关闭，才能执行

4、后续的步骤。可以通过命令：ps ef|grep source 来检查是否仍然有进程未关闭 生成复制数据库脚本 进入 source 数据库的udump目录，找到那个最新的文件。 打开该文件后，找到如下的段落:STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE SOURCE RESETLOGS NOARCHIVELOG MAXLOGFILES 8 MAXLOGMEMBERS 4 MAXDATAFILES 1021 MAXINSTANCES 1 MAXLOGHISTORY 292LOGFILE GROUP 1 /app/oracle/oradata/ S

5、OURCE /redo01.log SIZE 100M, GROUP 2 /app/oracle/oradata/ SOURCE /redo02.log SIZE 100M, GROUP 3 /app/oracle/oradata/ SOURCE /redo03.log SIZE 100M- STANDBY LOGFILEDATAFILE /app/oracle/oradata/ SOURCE /system01.dbf, /app/oracle/oradata/ SOURCE /psundots01.dbf, /app/oracle/oradata/ SOURCE /sysaux01.dbf

6、, /app/oracle/oradata/ SOURCE /psdefault.dbf, /app/oracle/oradata/ SOURCE /aaapp.dbf, /app/oracle/oradata/ SOURCE /aalarge.dbf, /app/oracle/oradata/ SOURCE /adapp.dbf, /app/oracle/oradata/ SOURCE /amapp.dbf, /app/oracle/oradata/ SOURCE /avapp.dbf, /app/oracle/oradata/ SOURCE /bdapp.dbf, /app/oracle/

7、oradata/ SOURCE /bnapp.dbf, /app/oracle/oradata/ SOURCE /bnlarge.dbf, /app/oracle/oradata/ SOURCE /ccapp.dbf, /app/oracle/oradata/ SOURCE /coapp.dbf, /app/oracle/oradata/ SOURCE /cuaudit.dbf, /app/oracle/oradata/ SOURCE /cularg1.dbf, /app/oracle/oradata/ SOURCE /cularg2.dbf, /app/oracle/oradata/ SOU

8、RCE /cularg3.dbf, /app/oracle/oradata/ SOURCE /cularge.dbf, /app/oracle/oradata/ SOURCE /diapp.dbf, /app/oracle/oradata/ SOURCE /dtapp.dbf, /app/oracle/oradata/ SOURCE /eoapp.dbf /app/oracle/oradata/ SOURCE /eobfapp.dbf, /app/oracle/oradata/ SOURCE /eocfapp.dbf, /app/oracle/oradata/ SOURCE /eocmapp.

9、dbf, /app/oracle/oradata/ SOURCE /eocmlrg.dbf, /app/oracle/oradata/ SOURCE /eocmwrk.dbf, /app/oracle/oradata/ SOURCE /eocuapp.dbf, /app/oracle/oradata/ SOURCE /eoculrg.dbf, /app/oracle/oradata/ SOURCE /eodsapp.dbf, /app/oracle/oradata/ SOURCE /eodslrg.dbf, /app/oracle/oradata/ SOURCE /eoecapp.dbf, /

10、app/oracle/oradata/ SOURCE /eoeclrg.dbf, /app/oracle/oradata/ SOURCE /eoecwrk.dbf, /app/oracle/oradata/ SOURCE /eoeiapp.dbf, /app/oracle/oradata/ SOURCE /eoeilrg.dbf, /app/oracle/oradata/ SOURCE /eoewapp.dbf, /app/oracle/oradata/ SOURCE /eoewlrg.dbf, /app/oracle/oradata/ SOURCE /eoewwrk.dbf, /app/or

11、acle/oradata/ SOURCE /eoiuapp.dbf, /app/oracle/oradata/ SOURCE /eoiulrg.dbf, /app/oracle/oradata/ SOURCE /eoiuwrk.dbf, /app/oracle/oradata/ SOURCE /eolarge.dbf, /app/oracle/oradata/ SOURCE /eoltapp.dbf, /app/oracle/oradata/ SOURCE /eoppapp.dbf, /app/oracle/oradata/ SOURCE /eopplrg.dbf, /app/oracle/o

12、radata/ SOURCE /eotpapp.dbf, /app/oracle/oradata/ SOURCE /eotplrg.dbf, /app/oracle/oradata/ SOURCE /epapp.dbf, /app/oracle/oradata/ SOURCE /eplarge.dbf, /app/oracle/oradata/ SOURCE /erapp.dbf, /app/oracle/oradata/ SOURCE /erlarge.dbf, /app/oracle/oradata/ SOURCE /erwork.dbf, /app/oracle/oradata/ SOU

13、RCE /faapp.dbf, /app/oracle/oradata/ SOURCE /falarge.dbf, /app/oracle/oradata/ SOURCE /fgapp.dbf, /app/oracle/oradata/ SOURCE /fglarge.dbf, /app/oracle/oradata/ SOURCE /fsapp.dbf, /app/oracle/oradata/ SOURCE /giapp.dbf, /app/oracle/oradata/ SOURCE /gpapp.dbf, /app/oracle/oradata/ SOURCE /gpdeapp.dbf

14、, /app/oracle/oradata/ SOURCE /hpapp.dbf, /app/oracle/oradata/ SOURCE /hrapp.dbf, /app/oracle/oradata/ SOURCE /hrapp1.dbf, /app/oracle/oradata/ SOURCE /hrapp2.dbf, /app/oracle/oradata/ SOURCE /hrapp3.dbf, /app/oracle/oradata/ SOURCE /hrapp4.dbf, /app/oracle/oradata/ SOURCE /hrapp5.dbf, /app/oracle/o

15、radata/ SOURCE /hrapp6.dbf, /app/oracle/oradata/ SOURCE /hrapp7.dbf, /app/oracle/oradata/ SOURCE /hrimage.dbf, /app/oracle/oradata/ SOURCE /hrlarg1.dbf, /app/oracle/oradata/ SOURCE /hrlarge.dbf, /app/oracle/oradata/ SOURCE /hrsapp.dbf, /app/oracle/oradata/ SOURCE /hrsarch.dbf, /app/oracle/oradata/ S

16、OURCE /hrslarge.dbf, /app/oracle/oradata/ SOURCE /hrswork.dbf, /app/oracle/oradata/ SOURCE /hrwork.dbf, /app/oracle/oradata/ SOURCE /htapp.dbf, /app/oracle/oradata/ SOURCE /inapp.dbf, /app/oracle/oradata/ SOURCE /paapp.dbf, /app/oracle/oradata/ SOURCE /palarge.dbf, /app/oracle/oradata/ SOURCE /pcapp

17、.dbf, /app/oracle/oradata/ SOURCE /pclarge.dbf, /app/oracle/oradata/ SOURCE /piapp.dbf, /app/oracle/oradata/ SOURCE /pilarge.dbf, /app/oracle/oradata/ SOURCE /piwork.dbf, /app/oracle/oradata/ SOURCE /poapp.dbf, /app/oracle/oradata/ SOURCE /psimage.dbf, /app/oracle/oradata/ SOURCE /psimgr.dbf, /app/o

18、racle/oradata/ SOURCE /psindex.dbf, /app/oracle/oradata/ SOURCE /ptamsg.dbf, /app/oracle/oradata/ SOURCE /ptapp.dbf, /app/oracle/oradata/ SOURCE /ptappe.dbf, /app/oracle/oradata/ SOURCE /ptaudit.dbf, /app/oracle/oradata/ SOURCE /ptcmstar.dbf, /app/oracle/oradata/ SOURCE /ptlock.dbf, /app/oracle/orad

19、ata/ SOURCE /ptprc.dbf, /app/oracle/oradata/ SOURCE /ptprjwk.dbf, /app/oracle/oradata/ SOURCE /ptrpts.dbf, /app/oracle/oradata/ SOURCE /pttbl.dbf, /app/oracle/oradata/ SOURCE /pttlrg.dbf, /app/oracle/oradata/ SOURCE /pttree.dbf, /app/oracle/oradata/ SOURCE /ptwork.dbf, /app/oracle/oradata/ SOURCE /p

20、vapp.dbf, /app/oracle/oradata/ SOURCE /py0lrg.dbf, /app/oracle/oradata/ SOURCE /pyapp.dbf, /app/oracle/oradata/ SOURCE /pylarge.dbf, /app/oracle/oradata/ SOURCE /pywork.dbf, /app/oracle/oradata/ SOURCE /saapp.dbf, /app/oracle/oradata/ SOURCE /sacapp.dbf, /app/oracle/oradata/ SOURCE /salarge.dbf, /ap

21、p/oracle/oradata/ SOURCE /srapp.dbf, /app/oracle/oradata/ SOURCE /stapp.dbf, /app/oracle/oradata/ SOURCE /stlarge.dbf, /app/oracle/oradata/ SOURCE /stwork.dbf, /app/oracle/oradata/ SOURCE /tlapp.dbf, /app/oracle/oradata/ SOURCE /tllarge.dbf, /app/oracle/oradata/ SOURCE /tlwork.dbf, /app/oracle/orada

22、ta/ SOURCE /waapp.dbfCHARACTER SET UTF8; 复制该段落，并编辑将 REUSE 改为 SET将所有 SOURCE 替换为 TARGET 在段落的最后加上 ALTER DATABASE OPEN RESETLOGS;ALTER TABLESPACE PSTEMP ADD TEMPFILE /app/oracle/oradata/ TARGET/pstemp01.dbf reuse;该段脚本类似于：STARTUP NOMOUNTCREATE CONTROLFILE SET DATABASE TARGET RESETLOGS NOARCHIVELOG MAXLOG

23、FILES 8 MAXLOGMEMBERS 4 MAXDATAFILES 1021 MAXINSTANCES 1 MAXLOGHISTORY 292LOGFILE GROUP 1 /app/oracle/oradata/TARGET/redo01.log SIZE 100M, GROUP 2 /app/oracle/oradata/TARGET/redo02.log SIZE 100M, GROUP 3 /app/oracle/oradata/TARGET/redo03.log SIZE 100M- STANDBY LOGFILEDATAFILE /app/oracle/oradata/ TA

24、RGET /system01.dbf, /app/oracle/oradata/ TARGET /psundots01.dbf, /app/oracle/oradata/ TARGET /sysaux01.dbf, /app/oracle/oradata/ TARGET /psdefault.dbf, /app/oracle/oradata/ TARGET /aaapp.dbf, /app/oracle/oradata/ TARGET /aalarge.dbf, /app/oracle/oradata/ TARGET /adapp.dbf, /app/oracle/oradata/ TARGE

25、T /amapp.dbf, /app/oracle/oradata/ TARGET /avapp.dbf, /app/oracle/oradata/ TARGET /bdapp.dbf, /app/oracle/oradata/ TARGET /bnapp.dbf, /app/oracle/oradata/ TARGET /bnlarge.dbf, /app/oracle/oradata/ TARGET /ccapp.dbf, /app/oracle/oradata/ TARGET /coapp.dbf, /app/oracle/oradata/ TARGET /cuaudit.dbf, /a

26、pp/oracle/oradata/ TARGET /cularg1.dbf, /app/oracle/oradata/ TARGET /cularg2.dbf, /app/oracle/oradata/ TARGET /cularg3.dbf, /app/oracle/oradata/ TARGET /cularge.dbf, /app/oracle/oradata/ TARGET /diapp.dbf, /app/oracle/oradata/ TARGET /dtapp.dbf, /app/oracle/oradata/ TARGET /eoapp.dbf, /app/oracle/or

27、adata/ TARGET /eobfapp.dbf, /app/oracle/oradata/ TARGET /eocfapp.dbf, /app/oracle/oradata/ TARGET /eocmapp.dbf, /app/oracle/oradata/ TARGET /eocmlrg.dbf, /app/oracle/oradata/ TARGET /eocmwrk.dbf, /app/oracle/oradata/ TARGET /eocuapp.dbf, /app/oracle/oradata/ TARGET /eoculrg.dbf, /app/oracle/oradata/

28、 TARGET /eodsapp.dbf, /app/oracle/oradata/ TARGET /eodslrg.dbf, /app/oracle/oradata/ TARGET /eoecapp.dbf, /app/oracle/oradata/ TARGET /eoeclrg.dbf, /app/oracle/oradata/ TARGET /eoecwrk.dbf, /app/oracle/oradata/ TARGET /eoeiapp.dbf, /app/oracle/oradata/ TARGET /eoeilrg.dbf, /app/oracle/oradata/ TARGE

29、T /eoewapp.dbf, /app/oracle/oradata/ TARGET /eoewlrg.dbf, /app/oracle/oradata/ TARGET /eoewwrk.dbf, /app/oracle/oradata/ TARGET /eoiuapp.dbf, /app/oracle/oradata/ TARGET /eoiulrg.dbf, /app/oracle/oradata/ TARGET /eoiuwrk.dbf, /app/oracle/oradata/ TARGET /eolarge.dbf, /app/oracle/oradata/ TARGET /eol

30、tapp.dbf, /app/oracle/oradata/ TARGET /eoppapp.dbf, /app/oracle/oradata/ TARGET /eopplrg.dbf, /app/oracle/oradata/ TARGET /eotpapp.dbf, /app/oracle/oradata/ TARGET /eotplrg.dbf, /app/oracle/oradata/ TARGET /epapp.dbf, /app/oracle/oradata/ TARGET /eplarge.dbf, /app/oracle/oradata/ TARGET /erapp.dbf, /app/oracle/oradata/ TA