使用 dbms_file_transfer 方式测试增量传输表空间XTTS

最新推荐文章于 2021-04-16 00:44:45 发布
最新推荐文章于 2021-04-16 00:44:45 发布
阅读量1.7k 收藏 2
点赞数
分类专栏： oracle基础
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wll_1017/article/details/62233230
版权

使用 dbms_file_transfer 方式测试增量传输表空间XTTS


 dbms_file_transfer ：
  For large number of files, using dbms_file_transfer has been found to be the fastest method for transferring datafiles to destination.   


1、测试环境

ip地址 
10.10.6.86 dg
10.10.6.87 dg2


源端数据库版本：
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
目标端数据库版本：
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


 使用此方法目标端的数据库必须是11.2.0.4版本的
 
 【准备工作】
 1、源端数据库创建目录，此目录是源端数据文件拷贝的目录
 ---本地磁盘的如下格式
  create  directory sourcedir as '/u01/app/oracle/oradata/test';
 --如果是asm可以是如下格式
  create directory sourcedir as '+DATA/prod/datafile';
  
  
 2、目标端数据库创建目录，此目录是目标端数据库存放传输表空间数据文件的目录
  ---本地磁盘的如下格式
    create  directory destdir as '/u01/app/oracle/oradata/test';


 --如果是asm可以是如下格式
  create directory destdir as '+DATA/prod/datafile';
 
 
 3、 database link 创建，用于目标端数据库连接源端数据库的link
  create public database link ttslink connect to system identified by <password> using '<tns_to_source>';
  
  create public database link tts connect to scott identified by  tiger using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.86)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )';
  
  
  
  create public database link tts connect to boswll identified by  boswll using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.87)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )';
  
  
  select * from dba_directories;
  
  在目标端测试连接源端数据库
   select * from dual@tts;
   
   
 解压缩软件
  unzip rman-xttconvert_2.0.zip


编辑 xtt.properties
[oracle@dg tts]$ cat xtt.properties
srcdir=SOURCEDIR    //必须大写 DIRECTORY_NAME 一致  select * from dba_directories;
dstdir=DESTDIR      //必须大写 
srclink=TTS
parallel=3
rollparallel=2
getfileparallel=4
tablespaces=TEST   //此处表空间必须大写，否则输出文件是空的     
platformid=13
dfcopydir=/backup/full
backupformat=/backup/inc       
stageondest=/backup/full 
backupondest=/backup/inc
storageondest=/u01/app/oracle/oradata/test
desttmpdir=/backup/tmp
cnvinst_home=/u01/app/oracle/11.2.0.4/product
cnvinst_sid=test


注意：1、此处需要注意的是表空间名称必须大写
      2、注意每个参数的结束后面不能有空格
      3、注意选中传输的表空间必须online + READ WRITE，并且表空间中的数据文件也必须是online

拷贝软件到目标端
scp -r /home/oracle/xtt 10.10.6.87:/home/oracle/xtt

【源端】传输表空间
 export TMPDIR=/home/oracle/xtt
$ORACLE_HOME/perl/bin/perl xttdriver.pl -S

[oracle@dg xtt]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -S
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Starting prepare phase
--------------------------------------------------------------------
sh: line 6: warning: here-document at line 0 delimited by end-of-file (wanted `EOF')
Prepare source for Tablespaces:
                  'TEST'  /backup/full
xttpreparesrc.sql for 'TEST' started at Wed Mar 15 11:27:39 2017
xttpreparesrc.sql for  ended at Wed Mar 15 11:27:39 2017
Prepare source for Tablespaces:
                  ''  /backup/full
xttpreparesrc.sql for '' started at Wed Mar 15 11:27:39 2017
xttpreparesrc.sql for  ended at Wed Mar 15 11:27:40 2017
Prepare source for Tablespaces:
                  ''  /backup/full
xttpreparesrc.sql for '' started at Wed Mar 15 11:27:40 2017
xttpreparesrc.sql for  ended at Wed Mar 15 11:27:40 2017
--------------------------------------------------------------------
Done with prepare phase
--------------------------------------------------------------------

[oracle@dg xtt]$ ls -lrt
total 184
-rwxrwxr-x 1 oracle oinstall    52 May 22  2015 xttstartupnomount.sql
-rwxrwxr-x 1 oracle oinstall  7789 May 22  2015 xtt.properties_bak
-rwxrwxr-x 1 oracle oinstall 11549 May 22  2015 xttprep.tmpl
-rwxrwxr-x 1 oracle oinstall 91722 May 22  2015 xttdriver.pl
-rwxrwxr-x 1 oracle oinstall    71 May 22  2015 xttdbopen.sql
-rwxrwxr-x 1 oracle oinstall  1390 May 22  2015 xttcnvrtbkupdest.sql
-rw-r--r-- 1 root   root     26975 Mar 14 18:59 rman-xttconvert_2.0.zip
-rw-r--r-- 1 oracle oinstall    18 Mar 15 11:27 xttplan.txt
-rw-r--r-- 1 oracle oinstall 11531 Mar 15 11:27 xttpreparesrc.sql
-rw-r--r-- 1 oracle oinstall     0 Mar 15 11:27 xttprepare.cmd
-rw-r--r-- 1 oracle oinstall    29 Mar 15 11:27 xttnewdatafiles.txttemp
-rw-r--r-- 1 oracle oinstall    29 Mar 15 11:27 xttnewdatafiles.txt
-rw-r--r-- 1 oracle oinstall    42 Mar 15 11:27 getfile.sql
-rw-r--r-- 1 oracle oinstall   346 Mar 15 11:30 xtt.properties

[oracle@dg xtt]$ cat xttnewdatafiles.txt
::TEST
5,destdir:/test01.dbf

[oracle@dg xtt]$ cat getfile.sql
0,SOURCEDIR,test01.dbf,destdir,test01.dbf


scp    xttnewdatafiles.txt  10.10.6.87:/home/oracle/xtt
scp    getfile.sql 10.10.6.87:/home/oracle/xtt


【目标端】传输数据文件到目标端
 export TMPDIR=/home/oracle/xtt
$ORACLE_HOME/perl/bin/perl xttdriver.pl -G
[oracle@dg2 xtt]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -G
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Getting datafiles from source
--------------------------------------------------------------------
sh: line 5: warning: here-document at line 0 delimited by end-of-file (wanted `EOF')
fetchCheckDirObjectsDST: Check dir path 
fetchDirEntry: remotelink not present
sh: line 6: warning: here-document at line 0 delimited by end-of-file (wanted `EOF')

--------------------------------------------------------------------
Executing getfile for getfile_sourcedir_test01.dbf_0.sql
--------------------------------------------------------------------
PL/SQL procedure successfully completed.
--------------------------------------------------------------------
Completed getting datafiles from source
--------------------------------------------------------------------

---数据文件test01.dbf已经传输到目标端，并且完成t endian conversion
[oracle@dg2 test]$ ls -lrt
total 2550596
-rw-r----- 1 oracle oinstall  52429312 Mar 14 22:01 redo03.log
-rw-r----- 1 oracle oinstall  52429312 Mar 15 00:44 redo01.log
-rw-r----- 1 oracle oinstall   5251072 Mar 15 00:49 users01.dbf
-rw-r----- 1 oracle oinstall  69214208 Mar 15 07:26 temp01.dbf
-rw-r----- 1 oracle oinstall 104865792 Mar 15 11:43 test01.dbf
-rw-r----- 1 oracle oinstall 629153792 Mar 15 11:43 sysaux01.dbf
-rw-r----- 1 oracle oinstall 875569152 Mar 15 11:43 undotbs01.dbf
-rw-r----- 1 oracle oinstall 796925952 Mar 15 11:43 system01.dbf
-rw-r----- 1 oracle oinstall  52429312 Mar 15 11:43 redo02.log
-rw-r----- 1 oracle oinstall   9748480 Mar 15 11:44 control01.ctl
-rw-r----- 1 oracle oinstall   9748480 Mar 15 11:44 control02.ctl


 insert into test select * From scott.emp;
insert into t1 values(3,'cc');
insert into t1 values(3,'cc');
insert into t1 values(3,'cc');
commit;
SQL> select * From t1;


ID NAME
---------- --------------------
1 a
3 cc
3 cc

3 cc


【源端】进行第一次增量备份
export TMPDIR=/home/oracle/xtt
$ORACLE_HOME/perl/bin/perl xttdriver.pl -i

[oracle@dg xtt]$ export TMPDIR=/home/oracle/xtt
[oracle@dg xtt]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -i

--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
Prepare newscn for Tablespaces: 'TEST' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
rman target /  cmdfile /home/oracle/xtt/rmanincr.cmd
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Mar 15 11:51:38 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: TEST (DBID=2236665980)
RMAN> set nocfau;
2> host 'echo ts::TEST';
3> backup incremental from scn 1817468 
4>   tag tts_incr_update tablespace 'TEST'  format
5>  '/backup/inc/%U';
6> 
executing command: SET NOCFAU
using target database control file instead of recovery catalog

ts::TEST
host command complete
Starting backup at 15-MAR-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=151 device type=DISK
backup will be obsolete on date 22-MAR-17
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/test/test01.dbf
channel ORA_DISK_1: starting piece 1 at 15-MAR-17
channel ORA_DISK_1: finished piece 1 at 15-MAR-17
piece handle=/backup/inc/0qrv6jmc_1_1 tag=TTS_INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
using channel ORA_DISK_1
backup will be obsolete on date 22-MAR-17
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 15-MAR-17
channel ORA_DISK_1: finished piece 1 at 15-MAR-17
piece handle=/backup/inc/0rrv6jmf_1_1 tag=TTS_INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-MAR-17
Recovery Manager complete.

--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------

/backup/inc 目录下面的增量备份
[oracle@dg inc]$ ls -lrt
total 9680
-rw-r----- 1 oracle oinstall  114688 Mar 15 11:51 0qrv6jmc_1_1
-rw-r----- 1 oracle oinstall 9797632 Mar 15 11:51 0rrv6jmf_1_1
0rrv6jmf_1_1 是控制信息文件，大小一致，0qrv6jmc_1_1 是增量备份文件

[oracle@dg xtt]$ cat incrbackups.txt
/backup/inc/0qrv6jmc_1_1
[oracle@dg xtt]$ cat tsbkupmap.txt
TEST::5:::1=0qrv6jmc_1_1

scp   /home/oracle/xtt/tsbkupmap.txt 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/xttplan.txt.new 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/incrbackups.txt 10.10.6.87:/home/oracle/xtt

scp   /backup/inc/0qrv6jmc_1_1   10.10.6.87:/backup/full
scp   /backup/inc/0rrv6jmf_1_1   10.10.6.87:/backup/inc


0srv6v1l_1_1
0trv6v1o_1_1


scp   /backup/inc/0srv6v1l_1_1   10.10.6.87:/backup/full
scp   /backup/inc/0trv6v1o_1_1   10.10.6.87:/backup/inc


【目标端】增量备份文件convert 并且应用到目标端数据文件
--目标端数据文件前滚
export TMPDIR=/home/oracle/xtt
[oracle@dg2 xtt]$  $ORACLE_HOME/perl/bin/perl xttdriver.pl -r

--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------
convert instance: /u01/app/oracle/11.2.0.4/product 
convert instance: test 
ORACLE instance started.
Total System Global Area 1887350784 bytes
Fixed Size    2254344 bytes
Variable Size 1728055800 bytes
Database Buffers  150994944 bytes
Redo Buffers    6045696 bytes
rdfno 5
BEFORE ROLLPLAN
datafile number : 5  
datafile name   : /u01/app/oracle/oradata/test/test01.dbf
AFTER ROLLPLAN
CONVERTED BACKUP PIECE/backup/inc/xib_0srv6v1l_1_1_5
PL/SQL procedure successfully completed.
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
--------------------------------------------------------------------
End of rollforward phase

--------------------------------------------------------------------


 在【源端】执行最后一次增量备份incremental,表空间设置为read only
SQL> update test set job='aaaa';
    insert into t1 values(4,'dd');
SQL> commit;
SQL> conn /as sysdba
SQL> alter tablespace test read only;

export TMPDIR=/home/oracle/xtt
$ORACLE_HOME/perl/bin/perl xttdriver.pl -i 

[oracle@dg xtt]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -i 
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
TABLESPACE STRING :'TEST'
Prepare newscn for Tablespaces: 'TEST' 
TEST::::1862546
 5
TABLESPACE STRING :''
Prepare newscn for Tablespaces: '' 


TABLESPACE STRING :''
Prepare newscn for Tablespaces: '' 


Start backup incremental
Crossed mv 
Crossed mv /backup/inc
Generate /home/oracle/xtt/rmanincr.cmd
rman target / debug trace /home/oracle/xtt/rmantrc_48322_547_incrbackup.trc cmdfile /home/oracle/xtt/rmanincr.cmd
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Mar 15 15:09:35 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
RMAN-06005: connected to target database: TEST (DBID=2236665980)
RMAN> set nocfau;
2> host 'echo ts::TEST';
3> backup incremental from scn 1824552 
4>   tag tts_incr_update tablespace 'TEST'  format
5>  '/backup/inc/%U';
6> 
RMAN-03023: executing command: SET NOCFAU
RMAN-06009: using target database control file instead of recovery catalog

ts::TEST
RMAN-06134: host command complete

RMAN-03090: Starting backup at 15-MAR-17
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=149 device type=DISK
RMAN-06518: backup will be obsolete on date 22-MAR-17
RMAN-06520: archived logs will not be kept or backed up
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00005 name=/u01/app/oracle/oradata/test/test01.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 15-MAR-17
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 15-MAR-17
RMAN-08530: piece handle=/backup/inc/0urv6v9g_1_1 tag=TTS_INCR_UPDATE comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
RMAN-12016: using channel ORA_DISK_1
RMAN-06518: backup will be obsolete on date 22-MAR-17
RMAN-06520: archived logs will not be kept or backed up
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08011: including current control file in backup set
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 15-MAR-17
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 15-MAR-17
RMAN-08530: piece handle=/backup/inc/0vrv6v9k_1_1 tag=TTS_INCR_UPDATE comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-03091: Finished backup at 15-MAR-17
Recovery Manager complete.

TSNAME:TEST
--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------

[oracle@dg inc]$ ls -lrt
total 19240
-rw-r----- 1 oracle oinstall   49152 Mar 15 15:05 0srv6v1l_1_1
-rw-r----- 1 oracle oinstall 9797632 Mar 15 15:05 0trv6v1o_1_1
-rw-r----- 1 oracle oinstall   57344 Mar 15 15:09 0urv6v9g_1_1
-rw-r----- 1 oracle oinstall 9797632 Mar 15 15:09 0vrv6v9k_1_1


scp   /backup/inc/0urv6v9g_1_1   10.10.6.87:/backup/full
scp   /backup/inc/0vrv6v9k_1_1   10.10.6.87:/backup/inc


scp   /home/oracle/xtt/xttplan.txt.new 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/xttdetnewfromscnsrc.sql 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/xttprepare.cmd 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/rmanincr.cmd 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/tsbkupmap.txt 10.10.6.87:/home/oracle/xtt
scp   /home/oracle/xtt/incrbackups.txt 10.10.6.87:/home/oracle/xtt


 在【目标】端应用最后一次增量roll forward
  export TMPDIR=/home/oracle/xtt
  $ORACLE_HOME/perl/bin/perl xttdriver.pl -r
  
[oracle@dg2 xtt]$   $ORACLE_HOME/perl/bin/perl xttdriver.pl -r
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------
convert instance: /u01/app/oracle/11.2.0.4/product 
convert instance: test 
ORACLE instance started.
Total System Global Area 1887350784 bytes
Fixed Size    2254344 bytes
Variable Size 1728055800 bytes
Database Buffers  150994944 bytes
Redo Buffers    6045696 bytes
rdfno 5
BEFORE ROLLPLAN
datafile number : 5  
datafile name   : /u01/app/oracle/oradata/test/test01.dbf
AFTER ROLLPLAN
CONVERTED BACKUP PIECE/backup/inc/xib_0urv6v9g_1_1_5
PL/SQL procedure successfully completed.
Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
--------------------------------------------------------------------
End of rollforward phase
--------------------------------------------------------------------


在【目标端】产生元数据的恢复脚本
[oracle@dg2 xtt]$   export TMPDIR=/home/oracle/xtt
[oracle@dg2 xtt]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -e  
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Generating plugin
--------------------------------------------------------------------

--------------------------------------------------------------------
Done generating plugin file /home/oracle/xtt/xttplugin.txt
--------------------------------------------------------------------


在导入数据前需要注意的是：
传输到目标端的表空间中表所属的schema ，如果在目标中数据库中没有，在导入元数据前，必须新建用户，给予相应权限

SQL> create user test identified by test ;
SQL> grant connect,resource to test;
  
[oracle@dg2 xtt]$ cat  /home/oracle/xtt/xttplugin.txt
impdp directory=<DATA_PUMP_DIR> logfile=<tts_imp.log> network_link=<ttslink> transport_full_check=no transport_tablespaces=TEST transport_datafiles='/u01/app/oracle/oradata/test/test01.dbf'


[oracle@dg2 xtt]$ impdp   boswll/boswll directory= destdir  logfile=tts.log  network_link= tts  transport_full_check=no transport_tablespaces=TEST transport_datafiles='/u01/app/oracle/oradata/test/test01.dbf'

Import: Release 11.2.0.4.0 - Production on Wed Mar 15 15:18:54 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "BOSWLL"."SYS_IMPORT_TRANSPORTABLE_02":  boswll/******** directory= logfile=tts.log network_link= transport_full_check=no transport_tablespaces=TEST transport_datafiles=/u01/app/oracle/oradata/test/test01.dbf 
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "BOSWLL"."SYS_IMPORT_TRANSPORTABLE_02" successfully completed at Wed Mar 15 15:21:15 2017 elapsed 0 00:02:08

SQL> select * From t1;

ID NAME
---------- --------------------
1 a
3 cc
3 cc
3 cc
3 cc
4 dd
6 rows selected.

   
  ---源端TEST表空间可读写  
 alter tablespace TEST read write; 

--目标端TEST表空间可读写    
SQL>  alter tablespace TEST read write; 


Tablespace altered.



 [oracle@dg2 xtt]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 15 15:28:34 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: TEST (DBID=2236665980)
RMAN>  validate tablespace 'TEST' check logical;
Starting validate at 15-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1905 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00005 name=/u01/app/oracle/oradata/test/test01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              12653        12800           1862539   
  File Name: /u01/app/oracle/oradata/test/test01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              11              
  Index      0              0               
  Other      0              136             

Finished validate at 15-MAR-17
wluckdog
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
使用dbms_stats包手工收集统计信息
01-03
ORACLE数据库使用dbms_stats包手动收集关于表的、索引的统计信息。
【迁移】使用XTTS-V3（DBMS_FILE_TRANSFER）数据迁移
数据库学习笔记
05-01 999
生产上遇到一个迁移场景，大概1T数据量左右，由于没用XTTS做过迁移，所以准备尝试一下，本次迁移采用XTTS(增强传输表空间) V3版本的DBMS_FILE_TRANSFER方式。 一、源库及目标库情况 从目标库及源库情况来看，选用XTTS并不是个好选择。XTTS主要还是用在跨平台、跨版本且数据量大的场景下，当前的场景：服务器间网络传输速率高用DataPump的netlink方式最简单，用DG停机时间可以做到最短。 源库 目标库 IP地址 10.0.11.XXX 10.0.14.XXX
Oracle 12C xtts and dbms_file_transfer
01-17 365
1.初始化设置阶段 1.1安装目标数据库软件并创建目标数据库 在目标系统上安装目标Oracle数据库软件，版本应该为Oracle12c,操作系统是Linux,我这里都是12.2.0.1。在源数据库中创建了...
xttdriver.pl
测试0901-1
04-09 596
!/usr/bin/perl $Header: rdbms/demo/rman_xttconvert/xttdriver.pl /main/10 2015/05/18 06:18:23 asathyam Exp $ xttdriver.pl Copyright (c) 2013, 2015, Oracle and/or its affiliates. A...
oracle dbms_file,Oracle10g新增DBMS_FILE_TRANSFER包（二）
weixin_39791349的博客
04-16 117
Oracle10g新增了DBMS_FILE_TRANSFER包，通过数据库的功能实现了文件的传输。这篇介绍GET_FILE和PUT_FILE过程。前面介绍了COPY_FILE，这里介绍这个包的另外两个过程，GET_FILE和PUT_FILE。这两个过程的功能和FTP的get和put命令是否类似，就是利用数据库的功能将文件在两个数据库服务器之间进行拷贝。和COPY_FILE过程唯一不同之处在于，GE...
XTTS简要测试步骤
sqlora的专栏
01-19 496
XTTS基本步骤 源端对表空间做0级备份 目标端提取恢复文件 源端对表空间做1级增量备份 目标端应用1级增量备份 源端设置表空间只读—停机时间开始 源端再做1级增量备份 源端导出创建用户的脚本，导出表空间元数据 目标端应用1级增量备份 目标端创建用户及导入表空间元数据 目标端修改用户默认表空间并设置表空间可读写 源端：测试表空间准备 Microsoft Windows [版本...
[Oracle] dbms_metadata.get_ddl 的使用方法总结
09-10
以下是对Oracle中dbms_metadata.get_ddl的用法进行了详细的分析介绍，需要的朋友参考下
Oracle中使用DBMS_XPLAN处理执行计划详解
12-16
在以前查看SQL执行计划的时候，我都是使用set autotrace命令，不过现在看来，DBMS_XPLAN包给出了更加简化的获取和显示计划的方式。 这5个函数分别对应不同的显示计划的方式，DBMS_XPLAN包不仅可以获取解释计划，它还...
Oracle随机函数之dbms_random使用详解
09-10
dbms_random是oracle提供的一个随机函数包,本文将详细介绍函数的使用,需要的朋友可以参考下
DBMS.rar_dbms_dbms java_dbms_java_plus
09-22
Java连接Oracle数据库实例 实现SQL*PLUS功能 带JDBC驱动 适合初学者学习参考
使用DBMS_FILE_TRANSFER配置DATA GURAD和克隆数据库
congshelei4439的博客
06-03 146
使用DBMS_FILE_TRANSFER配置DATA GURAD和克隆数据库 作者：流云 | 【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】地址：http://rdc.taobao.com/blog/dba/h...
dbms_file_transfer使用简介
Data & Analysis
04-17 1190
dbms_file_transfer这个包可以在两个位置传输文件，分别可以有以下位置：a 从一个asm diskgroup传输到另外一个asm diskgroupb 从一个asm diskgroup传输到本地磁盘文件c 从本地磁盘文件传输到asmd 从一个计算机传输到另外一台计算机分别有三种方法：a copy_file 文件从一个目录拷贝到另外一个目录，只能本地传输b get_file 把远程的文...
转淘宝流云dbms_file_transfer package usage
05-17 168
2008年05月14日 利用DBMS_FILE_TRANSFER传输数据库文件 作者：流云 | 【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】 地址：http://rdc.taobao.com/blog/...
xtts迁移步骤记录
liuzhilong的博客
03-08 1247
使用oracle官方提供的xtts脚本xttsdriver.pl进行迁移 xttsdriver.pl有2中迁移方式，dbms_file_transfer和rman 本篇使用rman的方式 xtts只需要最后一次追增量的停机时间，停机时间较短 一、环境检查阶段============================== --检查当前平台是否为windows --查看源端PLATFO...
深入浅出XTTS：Oracle数据库迁移升级利器（附PPT）
weixin_34375054的博客
05-16 1300
师介绍杨光 新炬网络高级工程师 近十年数据库运维、数据分析、数据库设计以及系统规划建设经验。 长期为国内电信运营商的大型IT系统进行系统软件运维、数据架构规划、设计和实施以及大型IT系统数据建模工作。 在大数据平台技术架构以及大数据资产管理方面有着深入的研究。 演讲大纲： 1.什么是XTTS 2. 适用场景 3. XTTS的基...
ORACLE 使用dbms_file_transfer 包迁移表空间或文件
weixin_34119545的博客
06-23 136
2019独角兽企业重金招聘Python工程师标准>>> ...
使用增量XTTS传输表空间
wll的专栏
03-15 2864
1、使用增量XTTS 传输表空间的前提条件 In addition to the limitations and considerations for transportable tablespaces, the following conditions must be met: The source system cannot be Windows.The source databa
DBMS_BACKUP_RESTORE 包中的 CREATE_FILE_SE 内容
最新发布
06-07
`CREATE_FILE_SET` 是 `DBMS_BACKUP_RESTORE` 包中的一个...在创建备份文件集之后，可以使用 `DBMS_BACKUP_RESTORE.ADD_FILE_TO_FILE_SET` 存储过程向备份文件集中添加数据文件、控制文件、日志文件等备份所需的文件。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值