Oracle 19c Data Pump Test Mode For Transportable Tablespaces
Description:-
- Oracle Database Release 19c New Features
- You can more easily determine how long an export takes, and discover unforeseen issues not reported by the closure check.
- Test mode for Transportable Tablespaces (TTSs) performs a metadata-only export test using TTSs or full transportable export or import. It also removes the requirement for the source database tablespaces to be in read-only mode.
- The resulting of export dump file is not available for use by Data Pump Import.
Syntax and Description
TTS_CLOSURE_CHECK = [ ON | OFF | FULL | TEST_MODE ]
TTS_CLOSURE_CHECK parameter supports the following options:
ON – indicates self-containment closure check be performed
OFF – indicates no closure check be performed
FULL – indicates full bidirectional closure check be performed
TEST_MODE – indicates that tablespaces are not required to be in read-only mode
ON,OFF, and FULL options are mutually exclusive. TEST_MODE is a Data Pump Export option only.
Demo:-
[oracle@dev19c ~]$ export ORACLE_SID=chennai
[oracle@dev19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Oct 20 14:44:09 2019
Version 19.4.1.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.4.1.0.0
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces where tablespace_name=’USERS’;
TABLESPACE_NAME STATUS
—————————— ———
USERS ONLINE
expdp system/oracle directory=DATA_PUMP_DIR dumpfile=users.dmp logfile=users.log transport_tablespaces=users TTS_CLOSURE_CHECK=test_mode
[oracle@dev19c ~]$ expdp system/oracle directory=DATA_PUMP_DIR dumpfile=users.dmp logfile=users.log transport_tablespaces=users TTS_CLOSURE_CHECK=test_mode
Export: Release 19.0.0.0.0 – Production on Sun Oct 20 14:48:29 2019
Version 19.4.1.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Starting “SYSTEM”.”SYS_EXPORT_TRANSPORTABLE_01″: system/******** directory=DATA_PUMP_DIR dumpfile=users.dmp logfile=users.log transport_tablespaces=users TTS_CLOSURE_CHECK=test_mode
Processing object type TRANSPORTABLE_EXPORT/STATISTICS/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Master table “SYSTEM”.”SYS_EXPORT_TRANSPORTABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
/u01/app/oracle/admin/chennai/dpdump/users.dmp
Dump file set is unusable. TEST_MODE requested.
******************************************************************************
Datafiles required for transportable tablespace USERS:
/u01/app/oracle/oradata/CHENNAI/users01.dbf
Job “SYSTEM”.”SYS_EXPORT_TRANSPORTABLE_01″ successfully completed at Sun Oct 20 14:49:39 2019 elapsed 0 00:01:02
Check the dumpfile:-
[oracle@dev19c ~]$ ls -lrt /u01/app/oracle/admin/chennai/dpdump/users.dmp
-rw-r—–. 1 oracle oinstall 2367488 Oct 20 14:49 /u01/app/oracle/admin/chennai/dpdump/users.dmp
- This option is used to obtain the timing requirements of the export operation.
- It is for testing purposes only. The dump file is unavailable for import.
Connect to me:-
Telegram App:https://t.me/oracledbwr
LinkedIn: https://www.linkedin.com/in/hariprasathdba
LinkedIN Page:https://www.linkedin.com/company/orcldbwr/
Facebook: https://www.facebook.com/HariPrasathdba
FB Group: https://www.facebook.com/groups/oracledbwr/
FB Page : https://www.facebook.com/dbahariprasath/
Twitter : https://twitter.com/hariprasathdba
