Konkrétní schéma
[10:44:54 dbserver:e1db1 oradata] $ expdp \'/ as sysdba\' schemas=DBA estimate=blocks estimate_only=y directory=DUMP_PD910 logfile=estimate.log
Export: Release 11.2.0.3.0 - Production on Tue Dec 2 10:46:09 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" schemas=DBA estimate=blocks estimate_only=y directory=DUMP_PD910 logfile=estimate.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. estimated "DBA"."FF31K41" 0 KB
. estimated "DBA"."FF31K42" 0 KB
. estimated "DBA"."FF31K50" 0 KB
. estimated "DBA"."FF31K51" 0 KB
. estimated "DBA"."FF31K52" 0 KB
. estimated "DBA"."FF34R010" 0 KB
. estimated "DBA"."FF34R011" 0 KB
. estimated "DBA"."FF34R012" 0 KB
. estimated "DBA"."FF34R013" 0 KB
. estimated "DBA"."FF34R014" 0 KB
. estimated "DBA"."FF34S001" 0 KB
. estimated "DBA"."FF34S002" 0 KB
. estimated "DBA"."FF34S003" 0 KB
. estimated "DBA"."FF34S01W" 0 KB
. estimated "DBA"."T76B001" 0 KB
. estimated "DBA"."T76B002" 0 KB
Total estimation using BLOCKS method: 117.4 GB
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:44:53
[10:51:00 dbserver:e1db1 oradata] $ expdp \'/ as sysdba\' schemas=DBA estimate=statistics estimate_only=y directory=DUMP_PD910 logfile=estimate.log
Export: Release 11.2.0.3.0 - Production on Tue Dec 2 10:53:37 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" schemas=DBA estimate=statistics estimate_only=y directory=DUMP_PD910 logfile=estimate.log
Estimate in progress using STATISTICS method...
. estimated "DBA"."FF34S01W" 0 KB
. estimated "DBA"."T76B001" 0 KB
. estimated "DBA"."T76B002" 0 KB
Total estimation using STATISTICS method: 97.84 GB
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:53:55
Skutečná velikost databáze
expdp \'/ as sysdba\' schemas=DBA directory=exp_pom_dir dumpfile=PROD_DBA.dmp logfile=PROD_DBA.log
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/TEMP-HDD/export/PROD_DBA.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:53:48
[14:55:37 dbserver:root export] # ls -ltr
total 103020628
-rw-r----- 1 oracle dba 105492729856 Dec 2 14:53 PROD_DBA.dmp (98,24GB)
-rw-r--r-- 1 oracle dba 377859 Dec 2 14:53 PROD_DBA.log
Celá databáze
[10:41:08 dbserver:e1db1 data_pump] $ expdp \'/ as sysdba\' full=Y estimate=blocks estimate_only=y directory=DATA_PUMP logfile=estimate.log
Export: Release 11.2.0.3.0 - Production on Tue Dec 2 10:47:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_FULL_02": "/******** AS SYSDBA" full=Y estimate=blocks estimate_only=y directory=DATA_PUMP logfile=estimate.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. estimated "DBA"."F98870" 0 KB
. estimated "DBA"."F98880" 0 KB
. estimated "DBA"."F98885" 0 KB
. estimated "DBA"."F98887" 0 KB
. estimated "DBA"."F98890" 0 KB
Total estimation using BLOCKS method: 309.1 GB
Job "SYS"."SYS_EXPORT_FULL_02" successfully completed at 10:51:58
[10:52:01 dbserver:e1db1 data_pump] $ expdp \'/ as sysdba\' full=Y estimate=statistics estimate_only=y directory=DATA_PUMP logfile=estimate.log
Export: Release 11.2.0.3.0 - Production on Tue Dec 2 10:53:09 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_FULL_02": "/******** AS SYSDBA" full=Y estimate=statistics estimate_only=y directory=DATA_PUMP logfile=estimate.log
Estimate in progress using STATISTICS method...
. estimated "DBA"."F98880" 0 KB
. estimated "DBA"."F98885" 0 KB
. estimated "DBA"."F98887" 0 KB
. estimated "DBA"."F98890" 0 KB
Total estimation using STATISTICS method: 223.6 GB
Job "SYS"."SYS_EXPORT_FULL_02" successfully completed at 10:57:22
Komentáře
