Clone results based on Exclusion and Preserver configuration - Support and Troubleshooting

Clone results based on Exclusion and Preserver configuration Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Trouble configuring which items are excluded and preserved during instance clones? Start here for explanations, helpful examples, and additional resources.

About exclusion and preservation 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.

This article explains through six different scenarios the expected results of the data in a table based on the configuration of the Table Exclusion and Data Preserver when performing a clone.

Examples Test parameters used:

source = clone source (ex. production instance) target = clone target (ex. test instance) sys_temp = custom table we will be preserving and excluding data Data Preservers are always setup on source under System Clone > Preserver Data Table Exclusions are always setup on source under System Clone > Exclude Data Default clone settings used as per screenshot: IMPORTANT: If Exclude audit and log data is not checked, the list of table exclusions under Exclude Data is ignored. See KB0751430 for more information.

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

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } }

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } }

Related Links .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } The following are related documentation and articles on cloning and excluding a table:

Exclude a table from cloning product documentation KB0751430: Exclude Option Checkboxes not Being Honored with Clone Request