autobcp

[Legacy User]

As we know, we need use autobcp to sync database after one of the servers in dual server mode fail.

But what autobcp do is

- clear target database

- export source database

- import to target database

It takes a long time to complete.

 

Could we use storage technology like IBM SAN Metro-Mirror to speed up the database synchronization?

 

By the way, My database is ORACLE 11g on IBM DS8000 disk and Autosys is R11.3

[Mark_Hanson]

Depending on your version, there is an Oracle Data Pump option which is super fast.

Check out this video for more details.

[Chris Trinidad]

Henry,

At the current Client that I provide support to, I have changed their procedures to eliminate the use of autobcp.

While autobcp is a valuable utility, it takes an extended time to perform the function.

Instead, the procedure I have in place now, is to:

1.back up the database

2. do a dump and copy, as required

3. validate the synchonicity of the two dataabases

4. bring Autosys up.

Voila!

It takes all of 15 minutes for this procedure vs. the 2 hours that autobcp would have taken.

Good Luck.

Chris  <CJ>

[Roya Phamgia-Piroux]

Hi Henry,

 

The latest AutoSys 11.3.x  releases provide "autobcpORAdp.pl" which is much faster than "autobcpORA.pl".

 

You can find the "autobcpORAdp.pl" under $AUTOSYS/dbobj/ORA directory.

 

Otherwise, an alternate solution will be to use "Oracle RAC" to avoid maintaining a Dual database.

 

Oracle 11gr2/RAC is compatible with WAAE AutoSys 11.3.x releases.

 

You can consult the AutoSys Certification Matrix under the following link for more information :

 

https://support.ca.com/phpdocs/7/253/253_WA_AE_Support_Matrix.pdf

 

You can contact me in case of any further question.

 

Thanks,

Roya

[Legacy User]

Hi

For Autosys 11.3, autobcpdp utility comes from patch RO69345 which is available on our support.ca.com server

With 11.3.5 and above, you can find it in directory /opt/CA/WorkloadAutomationAE/autosys/dbobj/ORA and  its name is autobcpORAdp.pl

 

>>>>> New autobcp tool is applicable only for Oracle instances and versions above Oracle 10g <<<<<<

 

 

                  >>>>> This fix is applicable for all CA WAAEreleases above r11.3  <<<<<<

 

                  CA Workload Automation AE autobcpORA.pl uses the

                  imp and exp utilities to move data from one

                  Oracle server to another.  In Oracle versions 10g

                  and later, the vendor supplies datapump programs

                  (impdp and expdp) which are newer,  faster and

                  more flexible alternative to the imp and exp

                  program utilities.

 

                  New utility called autobcpORAdp.pl will utilize

                  impdp to pull data from source instance to

                  destination instance.

 

                  Note:  Please see pre-requisites in the Problem

                  Resolution section before running new tool.

 

Regards

 

Jean Paul

[Chris Trinidad]

Great info here from both Mark and Jean-Paul. Thing is that there is a subset of environments that use SAP's Sybase (remember when that was bundled with Autosys?!). In this type of enviroment, I have not seen a better alternative to the native Sybase dump and copy.

And being naturally suspicious, I always do a select on the process event table after the sync, to ensure just that...the sync!

Chris <CJ>