Log-In to post
If a complete recovery is performed on one database of a distributed system, no other action is required on any other databases. If an incomplete recovery is performed on one database of a distributed system, a coordinated time-based and change-based recovery should be done on all databases that have dependencies to the database that needed recovery.
Coordination of SCNs among the nodes of a distributed system allows global distributed read-consistency at both the statement and transaction level. If necessary, global distributed time-based recovery can also be completed by following these steps:
If the message is, "RESETLOGS after complete recovery through change scn," you have performed a complete recovery. Do not recover any of the other databases.
If the message is, "RESETLOGS after incomplete recovery UNTIL CHANGE scn," you have performed an incomplete recovery. Record the SCN number from the message.