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.