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

book

Article ID: 106925

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

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?

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.

Environment

Release:
Component: ATSYS

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;