Description:-
Oracle 21c datapump checksum parameter to confirm that an Oracle Data Pump dump file is valid after a transfer to or from the object store and also after saving dump files on on-premises. The checksum ensures that no accidental or malicious changes occurred.
The checksum is calculated at the end of the job, so the time scales according to the size of the file. Multiple files can be processed in parallel. You can use this parameter to validate that a dumpfile is complete and not corrupted after copying it over the network to an object store, or using it to validate an old dumpfile.
To confirm an old dumpfile that is completed properly and not corrupted during the transfer from one system to another system
Demo:-
Step:-1 Taking expdp using oracle 21c new feature datapump parameter – Checksum
[oracle@oracle21c ~]$ expdp scott/tiger@oradbwrpdb1 dumpfile=sal.dmp logfile=sal.log directory=data_pump_pdb tables=salgrade reuse_dumpfiles=y checksum=yes
Export: Release 21.0.0.0.0 – Production on Thu Sep 15 21:22:46 2022
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 – Production
Starting “SCOTT”.”SYS_EXPORT_TABLE_01″: scott/********@oradbwrpdb1 dumpfile=sal.dmp logfile=sal.log directory=data_pump_pdb tables=salgrade reuse_dumpfiles=y checksum=yes
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “SCOTT”.”SALGRADE” 5.953 KB 5 rows
Master table “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
Generating checksums for dump file set
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
/u01/datapump/sal.dmp
Job “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully completed at Thu Sep 15 21:23:09 2022 elapsed 0 00:00:20
Step:2 validating the checksum of a dumpfile is corrupted or not using the VERIFY_ONLY parameter
[oracle@oracle21c ~]$ impdp scott/tiger@oradbwrpdb1 dumpfile=sal.dmp directory=data_pump_pdb verify_only=yes
Import: Release 21.0.0.0.0 – Production on Thu Sep 15 21:23:31 2022
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 – Production
Verifying dump file checksums
Master table “SCOTT”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
dump file set is complete
verified checksum for dump file “/u01/datapump/sal.dmp”
dump file set is consistent
Job “SCOTT”.”SYS_IMPORT_FULL_01″ successfully completed at Thu Sep 15 21:23:37 2022 elapsed 0 00:00:04
Step:3 importing the data after verified the dumpfile
[oracle@oracle21c ~]$ impdp scott/tiger@oradbwrpdb1 dumpfile=sal.dmp directory=data_pump_pdb remap_table=scott.salgrade:oracledbwr verify_checksum=yes
Import: Release 21.0.0.0.0 – Production on Thu Sep 15 21:23:59 2022
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 – Production
Verifying dump file checksums
Master table “SCOTT”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “SCOTT”.”SYS_IMPORT_FULL_01″: scott/********@oradbwrpdb1 dumpfile=sal.dmp directory=data_pump_pdb remap_table=scott.salgrade:oracledbwr verify_checksum=yes
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported “SCOTT”.”ORACLEDBWR” 5.953 KB 5 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job “SCOTT”.”SYS_IMPORT_FULL_01″ successfully completed at Thu Sep 15 21:24:27 2022 elapsed 0 00:00:26
Connect with me on:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr
