ORACLE数据库xtts跨平台迁移DB

rman_xttconvert_VER4.3.zip

xtts:
1.
源：
execute dbms_tts.transport_set_check('DC',true,true);

select * from TRANSPORT_SET_VIOLATIONS

全备

export TMPDIR=/home/db/oracle/xtts
perl xttdriver.pl --backup
传输全备
scp  backup/* root@192.168.66.144:/home/db/oracle/backup
scp xtts/res.txt root@192.168.66.144:/home/db/oracle/xtts

目：
export TMPDIR=/home/db/oracle/xtts
全备恢复
oracle@node1:/home/db/oracle/xtts$ perl xttdriver.pl --restore

2.
源：
增备
perl xttdriver.pl --backup

传输增备
scp `cat incrbackups.txt` root@192.168.66.144:/home/db/oracle/backup
scp res.txt root@192.168.66.144:/home/db/oracle/xtts

目：
增量恢复
perl xttdriver.pl --restore

3. final incr
源：
alter tablespace DC                         read only ;
 

增备
perl xttdriver.pl --backup

传输增备
scp `cat incrbackups.txt` root@192.168.66.144:/home/db/oracle/backup
scp res.txt root@192.168.66.144:/home/db/oracle/xtts

目：
增量恢复
perl xttdriver.pl --restore

4.
源：
[oracle@source]$ cat exp.par

dumpfile=xttdump.dmp
directory=MY_DMP
statistics=NONE
transport_tablespaces=DC
transport_full_check=y
logfile=tts_export.log
 
[oracle@source]$ expdp system/manager parfile=exp.par

scp xttdump.dmp root@192.168.66.144:/home/db/oracle

 

全库的元数据，例如数据库存储过程，函数。触发器等等
full_metadata.par
expdp "'/ as sysdba'"  parfile=full_metadata.par

#full_metadata.par

directory=MY_DMP
DUMPFILE=full_metadata.dmp
logfile=full_metadata.log
full=y
CONTENT=METADATA_ONLY
EXCLUDE=TABLE,INDEX

[oracle@source]$ expdp system/manager parfile=exp.par

scp full_metadata..dmp root@192.168.66.144:/home/db/oracle

用户：
select 'create user '||name||' identified by values '''||password||''' default tablespace users temporary tablespace temp;' from user$ where  type#=1 and  CTIME>to_date('2019/08/03','YYYY/MM/DD');

在目标端执行:
create user QN identified by values '97EDC024B8966415' default tablespace users temporary tablespace temp;
 

select 'grant '||GRANTED_ROLE||' to '||grantee||';' from dba_role_privs where grantee in(select username from dba_users
where created>=to_date('2019/08/03','YYYY/MM/DD') and username not in ('SYSMAN','MGMT_VIEW','SPA','XDB','STRMADMIN'));

在目标端执行:
grant CONNECT to STAT;
grant RESOURCE to WMSYS;
grant PLUSTRACE to STAT;
grant RESOURCE to QN;

 

目：
cat manual_imp.par
dumpfile= xttdump.dmp
directory=DATAPUMP
transport_datafiles='/oracledata/TESTDB/testpdb/DC.dbf'

impdp qn/qn@testpdb parfile=manual_imp.par

impdp qn/qn@testpdb directory=DATAPUMP DUMPFILE=full_metadata.dmp exclude=tablespace

select 'alter user '||username||' default tablespace '|| DEFAULT_TABLESPACE||' temporary tablespace temp ' ||' quota unlimited on '||DEFAULT_TABLESPACE||';'
from dba_users where   CREATED>to_date('2020/04/03','YYYY/MM/DD');

alter user DC default tablespace DC temporary tablespace temp  quota unlimited on DC;
 

exec utl_recomp.recomp_parallel(32);