How to determine which Oracle database to use as the source when synchronizing via autobcp

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

How to determine which Oracle database to use as the source DB and which to use as the destination DB when synchronizing via the autobcpORA.pl script?

Environment

Release:
Component: ATSYS

Cause

After a database failure where one or both of the databases were unreachable, you may not be quite sure which database was updated last.

Resolution

A row count of the ujo_proc_event table will help you determine which database to use as the source DB: 
select count(*) from ujo_proc_event;

The database with the higher row count is the one you should use as the source DB.

In addition to this, you can run the following query to verify the source DB has a later date than the destination DB:
SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from ujo_proc_event;