使用 dbms_file_transfer 方式测试增量传输表空间XTTS
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
--------------------------------------------------------------------
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