>> Cumulative Export backsup the tables that have changed since the last cumulative or complete Export.
>> To understand more clearly pls check this scenario in which i took 'Complete' backup first and then i
perform 'Cumulative' backup.
E:\exp_full> exp file=E:\exp_full\newcomplete_bkp log=newcomplete.log full=y inctype=complete
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
EXP-00041: INCTYPE parameter is obsolete
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL 0 rows exported
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
. . exporting table DEF$_DEFAULTDEST 0 rows exported
. . exporting table DEF$_DESTINATION 0 rows exported
. . exporting table DEF$_ERROR 0 rows exported
. . exporting table DEF$_LOB 0 rows exported
. . exporting table DEF$_ORIGIN 0 rows exported
. . exporting table DEF$_PROPAGATOR 0 rows exported
. . exporting table DEF$_PUSHED_TRANSACTIONS 0 rows exported
. exporting table WWV_FLOW_PICK_PAGE_VIEWS 5 rows exported
. . exporting table WWV_FLOW_PLATFORM_PREF 0 rows exported
. . exporting table WWV_FLOW_PLATFORM_PREFS 21 rows exported
. . exporting table WWV_FLOW_POPUP_LOV_TEMPLATE 10 rows exported
. . exporting table WWV_FLOW_PREFERENCES$ 0 rows exported
. . exporting table WWV_FLOW_PROCESSING 45 rows exported
. . exporting table WWV_FLOW_PROVISION_COMPANY 0 rows exported
. . exporting table WWV_FLOW_PROVISION_SERICE_MOD 0 rows exported
. . exporting table WWV_FLOW_PURGED_SESSIONS$ 0 rows exported
. . exporting table WWV_FLOW_QB_SAVED_COND 0 rows exported
. . exporting table WWV_FLOW_QB_SAVED_JOIN 0 rows exported
. . exporting table WWV_FLOW_QB_SAVED_QUERY 0 rows exported
. . exporting table WWV_FLOW_QB_SAVED_TABS 0 rows exported
. . exporting table WWV_FLOW_QUERY_COLUMN 18 rows exported
. . exporting table WWV_FLOW_QUERY_CONDITION 6 rows exported
. . exporting table WWV_FLOW_QUERY_DEFINITION 6 rows exported
. . exporting table WWV_FLOW_QUERY_OBJECT 6 rows exported
. . exporting table WWV_FLOW_RANDOM_IMAGES 42 rows exported
. . exporting table WWV_FLOW_REGION_CHART_SER_ATTR 0 rows exported
. . exporting table WWV_FLOW_REGION_REPORT_COLUMN 7903 rows exported
. . exporting table WWV_FLOW_REGION_REPORT_FILTER 0 rows exported
. . exporting table WWV_FLOW_REGION_UPD_RPT_COLS 439 rows exported
. . exporting table WWV_FLOW_REPORT_LAYOUTS 0 rows exported
. . exporting table WWV_FLOW_REQUEST_VERIFICATIONS 0 rows exported
. . exporting table WWV_FLOW_REQUIRED_ROLES 0 rows exported
. . exporting table WWV_FLOW_RESTRICTED_SCHEMAS 46 rows exported
. . exporting table WWV_FLOW_ROW_TEMPLATES 54 rows exported
. . exporting table WWV_FLOW_WORKSHEET_CATEGORIES 0 rows exported
. . exporting table WWV_FLOW_WORKSHEET_COLUMNS 721 rows exported
. . exporting table WWV_FLOW_WORKSHEET_COL_GROUPS 0 rows exported
. exporting table OWBRTPS 0 rows exported
. about to export OWBSYS_AUDIT's tables via Conventional Path ...
. about to export DAVID's tables via Conventional Path ...
. . exporting table EMP 0 rows exported
. . exporting table INV 0 rows exported
. about to export ROSY's tables via Conventional Path ...
. . exporting table ACC 0 rows exported
. . exporting table DEPT 4 rows exported
. about to export SARA's tables via Conventional Path ...
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table SALGRADE 5 rows exported
. about to export SCOTT's tables via Conventional Path ...
. . exporting table BONUS 0 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table EMPNEW 14 rows exported
. . exporting table SALGRADE 5 rows exported
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.
>> All the tables are exported in this above output.
####################################################
CREATED ONE USER AND ADDED 4 TABLES
####################################################
SQL> create table lab.lab_emp as select * from scott.emp;
Table created.
SQL> create table lab.lab_salgrade as select * from scott.salgrade;
Table created.
SQL> create table lab.lab_bonus as select * from scott.bonus;
Table created.
SQL> create table lab.lab_department as select * from scott.dept;
Table created.
SQL> commit;
Now Take Cumulative Backup
E:\exp_full> exp file=E:\exp_full\labcum_bkp log=labcum.log full=y inctype=cumulative
Username: system
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
EXP-00041: INCTYPE parameter is obsolete
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
EXP-00107: Feature (BINARY XML) of column OPERAND in table ORDDATA.ORDDCM_CT_PRED_OPRD is not supported. The table will not be exported.
. . exporting table ORDDCM_CT_PRED_OPRD_TMP
EXP-00107: Feature (BINARY XML) of column OPERAND in table ORDDATA.ORDDCM_CT_PRED_OPRD_TMP is not supported. The table will not be exported.
. . exporting table ORDDCM_CT_PRED_OPRD_WRK
EXP-00107: Feature (BINARY XML) of column OPERAND in table ORDDATA.ORDDCM_CT_PRED_OPRD_WRK is not supported. The table will not be exported.
. . exporting table ORDDCM_DOCS
EXP-00107: Feature (BINARY XML) of column XML_CONTENT in table APEX_030200.WWV_MIG_RPTS is not supported. The table will not be exported.
. about to export OWBSYS's tables via Conventional Path ...
. about to export OWBSYS_AUDIT's tables via Conventional Path ...
. about to export DAVID's tables via Conventional Path ...
. about to export ROSY's tables via Conventional Path ...
. about to export SARA's tables via Conventional Path ...
. about to export SCOTT's tables via Conventional Path ...
. about to export LAB's tables via Conventional Path ...
. . exporting table LAB_BONUS 0 rows exported
. . exporting table LAB_DEPARTMENT 4 rows exported
. . exporting table LAB_EMP 14 rows exported
. . exporting table LAB_SALGRADE 5 rows exported
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting information about dropped objects
. exporting statistics
Export terminated successfully with warnings.
>> You can observe in both this scenarios output, how 'COMPLETE' option is taking all the tables backup which is nothing but full=y and compare this from the 'CUMULATIVE' output which is exported only 4 tables which we added after complete backup.
Happy Learning....
No comments:
Post a Comment