CLI attachSource force=true (KBA7967)

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

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 *> set attachData.force=true
delphix database "dexample" attachSource *> edit attachData.oracleFallbackCredentials
delphix database "dexample" attachSource attachData.oracleFallbackCredentials *> set type=PasswordCredential
delphix database "dexample" attachSource attachData.oracleFallbackCredentials *> set password=orauserpwd
delphix database "dexample" attachSource attachData.oracleFallbackCredentials *> commit

Troubleshooting

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