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);