复制正式区至测试区

1.复制程序(覆盖后需将$TOP/bin目录还原,因其下面有xxx)
su -
cd /u1/topprod
tar czvf /data/prod.tgz tiptop topcust
cd /u1/toptest
tar czvf /data/test.tgz tiptop topcust
cd /u1/toptest/tiptop
tar czvf bin.tgz bin
cd /u1/toptest
tar xzvf /data/prod.tgz
cd tiptop
tar xzvf bin.tgz


2.复制数据
正式区: exp system/manager@topprod file=ds1.dmp user=ds1


测试区:
SQLPLUS system/password@toptest
drop user ds1 cascade;
create user ds1 identified by ds1 default tablespace dbs1 temporary tablespace temp;
grant create session,create table to ds1;
grant resource to ds1;
grant create synonym to ds1;
grant select on sys.v_$session to ds1;
exit


imp system/manager@toptest file=ds1.dmp fromuser=ds1 touser=ds1 buffer=640000 ignore=y log=imp_ds1.log


其他DB同理




3.复制CR报表模板
mv d:\Tiptop_CR\toptest d:\Tiptop_CR\toptest_bak20xxxx
cp d:\Tiptop_CR\topprod d:\Tiptop_CR\toptest