Notifications

1605 views

Description

Overview


This knowledge base article will explain the expected results of the data in a table based on the configuration of the Table Exclusion and Data Preserver when performing a clone.

Note: Clones will read exclude/preserver lists from the source instance during the early stage of the clone. If updates are made to the exclusion/preserver list before clone, the clone will honor it even if the clone does not take on-demand backup.

  

Clone results based on Table Exclusion and Data Preserver configuration


In the six scenarios below, we will be using the following test parameters:


1. source = clone source (ex. production instance)
2. target = clone target (ex. test instance)
3. sys_temp = custom table we will be preserving and excluding data
4. Data Preservers are always setup on source under System Clone > Preserver Data
5. Table Exclusions are always setup on source under System Clone > Exclude Data
6. Default clone settings are used (see screen shot)


IMPORTANT: If 'Exclude audit and log data' is not checked, the list of table exclusions under 'Exclude Data' is ignored! (see KB0751430)




Scenario #1:
Table Exclusion: None
Data Preserver: None

Table Exclusion on source

 

Data Preserver on source

 

 

Results #1:
All records in sys_temp table on target are deleted.
All records in sys_temp table on source are copied to sys_temp table on target

 

Data on source

 

Data on target before clone

 

Data on target after clone


Scenario #2:
Table Exclusion: None
Data Preserver: Yes, plus 'Conditions' field is empty.

 

Table Exclusion on source

 

Data Preserver on source

 

 

Results #2:
All records in sys_temp table on target are preserved.
Records in sys_temp table on source, which do not exist in sys_temp table on target (based on sys_id), are copied to sys_temp table on target.

 

Data on source

 

Data on target before clone

 

Data on target after clone


Scenario #3:
Table Exclusion: None
Data Preserver: Yes, plus 'Conditions' field contains a value.

 

Table Exclusion on source

 

Data Preserver on source

 

 

Results #3:
Records in sys_temp table on target, found by Data Preserver, are preserved.
Records in sys_temp table on target, not found by Data Preserver, are deleted.
Records in sys_temp table on source, which do not exist in sys_temp table on target (based on sys_id), are copied to sys_temp table on target.

 

Data on source

 

Data on target before clone

 

Data on target after clone

 


Scenario #4:
Table Exclusion: Yes
Data Preserver: Yes, plus 'Conditions' field is empty.

 

Table Exclusion on source

 

Data Preserver on source

 

 

Results #4:
All records in sys_temp table on target are preserved.
No records are copied over from sys_temp table on source.

 

Data on source

 

Data on target before clone

 

Data on target after clone


Scenario #5:
Table Exclusion: Yes
Data Preserver: Yes, plus 'Conditions' field contains a value.

 

Table Exclusion on source

 

Data Preserver on source

 

 

Results #5:
Records in sys_temp table on target, found by Data Preserver, are preserved.
Records in sys_temp table on target, not found by Data Preserver, are deleted.
No records are copied over from sys_temp table on source.

 

Data on source

 

Data on target before clone

 

Data on target after clone


Scenario #6:
Table Exclusion: Yes
Data Preserver: None

 

Table Exclusion on source

 

Data Preserver on source

 

 

Results #6:
All records are deleted from sys_temp table on target.
No records are copied over from sys_temp table on source.

 

Data on source

 

Data on target before clone

 

Data on target after clone

 

Applicable Versions


All

Additional Information


Related knowledge base articles on cloning, excluding a table, and data preservers:

System clone

Exclude a table from cloning

Data preservation on cloning target instances

Exclude Option Checkboxes not Being Honored with Clone Request

 

Article Information

Last Updated:2019-08-02 21:01:02
Published:2019-06-20