PeopleSoft系统克隆详细说明.docx
《PeopleSoft系统克隆详细说明.docx》由会员分享,可在线阅读,更多相关《PeopleSoft系统克隆详细说明.docx(16页珍藏版)》请在冰豆网上搜索。
PeopleSoft系统克隆详细说明
管理信息系统项目
-人力资源系统
系统复制操作说明书
中国有限公司
有效期至年月日
文档管理记录
更改记录
日期
作者
版本
更改参考
审核记录
姓名
职位
分发记录
姓名
职位
目录
目录3
1.内容概述4
2.复制数据库6
2.1生成SOURCE数据库控制文件的trace文件6
2.2复制数据库数据文件22
2.3生成init.ora文件23
2.4执行recreate_Target.sql24
2.5配置LISTENER24
3.复制PS系统文件27
1.内容概述
PeopleSoft在初始安装系统时,提供了两种系统,一种是system系统,即只有系统数据,没有任何业务数据,另一种是demo系统,包含了部分演示业务数据。
我们在项目中,使用的所有系统都是由这两种系统复制生成的。
具体关系图如下:
所以,在项目中,真正的安装系统只需要进行两次,即分别安装一套system和一套demo系统,而复制(clone)系统,作为构建新系统或是系统的备份,是会经常使用到的手段。
基于PeopleSoft的技术特点,复制(clone)一套系统,需要执行的操作顺序是:
1复制数据库、2复制PS系统文件(可选)、3新建各种服务,而其中最重要的工作是复制数据库。
2.复制数据库
这里,我们为了方便说明,特假设源数据库的数据库SID为:
SOURCE,而新建的目标数据库SID为:
TARGET;oracle用户为数据库的DBA,并且oracle数据文件的目录为/app/oracle/oradata/
2.1生成SOURCE数据库控制文件的trace文件
以DBA的身份登录SOURCE数据库并启动该数据库
Loginasoracle/oracle
ORACLE_SID=SOURCE;exportORACLE_SID
sqlplus“/assysdba”
startup
执行备份命令
alterdatabasebackupcontrolfiletotrace;
关闭数据库
shutdownimmediate
注意:
一定要确保数据库完全关闭,才能执行后续的步骤。
可以通过命令:
ps–ef|grepsource来检查是否仍然有进程未关闭
生成复制数据库脚本
进入source数据库的udump目录,找到那个最新的文件。
打开该文件后,找到如下的段落:
STARTUPNOMOUNT
CREATECONTROLFILEREUSEDATABASE"SOURCE"RESETLOGSNOARCHIVELOG
MAXLOGFILES8
MAXLOGMEMBERS4
MAXDATAFILES1021
MAXINSTANCES1
MAXLOGHISTORY292
LOGFILE
GROUP1'/app/oracle/oradata/SOURCE/redo01.log'SIZE100M,
GROUP2'/app/oracle/oradata/SOURCE/redo02.log'SIZE100M,
GROUP3'/app/oracle/oradata/SOURCE/redo03.log'SIZE100M
--STANDBYLOGFILE
DATAFILE
'/app/oracle/oradata/SOURCE/system01.dbf',
'/app/oracle/oradata/SOURCE/psundots01.dbf',
'/app/oracle/oradata/SOURCE/sysaux01.dbf',
'/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/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/SOURCE/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.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',
'/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/oracle/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/oradata/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/SOURCE/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',
'/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/oradata/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/SOURCE/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.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/oracle/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/oradata/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/pvapp.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',
'/app/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/oradata/SOURCE/waapp.dbf'
CHARACTERSETUTF8
;
复制该段落,并编辑
将REUSE改为SET
将所有SOURCE替换为TARGET
在段落的最后加上
ALTERDATABASEOPENRESETLOGS;
ALTERTABLESPACEPSTEMPADDTEMPFILE'/app/oracle/oradata/TARGET/pstemp01.dbf'reuse;
该段脚本类似于:
STARTUPNOMOUNT
CREATECONTROLFILESETDATABASE"TARGET"RESETLOGSNOARCHIVELOG
MAXLOGFILES8
MAXLOGMEMBERS4
MAXDATAFILES1021
MAXINSTANCES1
MAXLOGHISTORY292
LOGFILE
GROUP1'/app/oracle/oradata/TARGET/redo01.log'SIZE100M,
GROUP2'/app/oracle/oradata/TARGET/redo02.log'SIZE100M,
GROUP3'/app/oracle/oradata/TARGET/redo03.log'SIZE100M
--STANDBYLOGFILE
DATAFILE
'/app/oracle/oradata/TARGET/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/TARGET/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',
'/app/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/oradata/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/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/TARGET/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/eoltapp.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