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:

  1. Use time-based recovery on the database that had the failure.
     
  2. After recovering the database, open it using the RESETLOGS option. Look in the ALERT file of for the RESETLOGS message.

    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.
     

  3. Recover all other databases in the distributed database system using change-based recovery, specifying the SCN from Step 2.