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?
After a database failure where one or both of the databases were unreachable, you may not be quite sure which database was updated last.
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;