Skip to main content
Delphix

CLI attachSource force=true (KBA7967)

 

KBA

KBA# 7967

 

Issue

How to resolve AttachSource failure showing - 

action_type: DB_ATTACH_SOURCE
desc_message_desc: Attach source "your_standby_db" to database "your_dsource".
desc_message_id: event.action.db.attach.source
desc_message_params: ["your_standby_db","your_dsource"]
end_time: 2021-08-02 16:56:19.024
fail_message_desc: Cannot attach database "your_standby_db" to container. Validation failed: The original database incarnation (resetlogs SCN 10648185191696, resetlogs time "20161018 174355") does not match the current database incarnation (resetlogs SCN 11533138218114, resetlogs time "20210713 191114") and the resetlogs SCN 11533138218114 is in the past of the latest current SCN when database was detached 11534663660453.
fail_message_id: exception.oracle.dsource.attach.failed.database
fail_message_params: ["The original database incarnation (resetlogs SCN 10648185191696, resetlogs time \"20161018 174355\") does not match the current database incarnation (resetlogs SCN 11533138218114, resetlogs time \"20210713 191114\") and the resetlogs SCN 11533138218114 is in the past of the latest current SCN when database was detached 11534663660453.","Attach is not possible for databases which have gone into a time before the database was detached. Verify that the correct database is being attached. If you are sure this database is the one you want to attach to the original database use FORCE=true, and try the attach operation again, otherwise link the database instead of attaching.","your_standby_db"]
http_session_id: EB8789CD2E17719344E04197A3049A38
origin_ip: 10.54.49.96
parent_action:
parent_job:
start_time: 2021-08-02 16:56:17.161
state: FAILED

 

Prerequisites

1) Verify that this is indeed the correct database to use as the new dsource.

2) Refresh the environment where your_standby_db exists.

3) Verify that refresh had no issue and your_standby_db is discovered

 - this may involve connecting with your DBA team.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Resolution

After the prerequisites have been fulfilled we can use CLI to attachsource

delphix database "dexample" attachSource *> set attachData.type=OracleAttachData
delphix database "dexample" attachSource *> set attachData.config=name-of-dSource-as-shown-in-environment
delphix database "dexample" attachSource *> set attachData.environmentUser=myuser
delphix database "dexample" attachSource *> set attachData.oracleFallbackUser=orauser
delphix database "dexample" attachSource *> edit attachData.oracleFallbackCredentials
delphix database "dexample" attachSource *> set set type=PasswordCredential
delphix database "dexample" attachSource *> set password=orauserpwd
delphix database "dexample" attachSource *> set force=true
delphix database "dexample" attachSource *> commit

 

Troubleshooting

Extremely important to verify this is the correct database to be used for the new dsource.

 


Related Articles

The following articles may provide more information or related information to this article: