Hi,

Has anyone implemented a standby database for a Baan erp system?


Best Regards,
ZL

Hi zaidlaz,

I've implemented many Oracle standby databases - let me know what you need to know.

Cheers,

James

Hi James,

Good day to you.

If standby database is enable for Baan Erp (baan IV c4), I would like to know the following:-
- Does the archive logs need to stop when running processes like MPS/MRP, post integration to finance
- Installing of baan solutions in the primary server, does it automatically synchronise with the standby server.

What are other things that needs to be taken for standby database for Baan erp?


Thank you!

Hi,

In short:

- Archive logging needs to be constantly running when running a standby database environment. Should you need to stop archive logging, then you'd have to completely rebuild your standby database after each stop.

- When you apply Baan solutions, Baan tables in the database will get updated as well as the Baan software under your $BSE directory. So the answer of course is that the Baan Tables in the standby database will also been updated with the identical solution info.


In the event of a problem with your Production Database, you simply open up the Standby database then point your Baan environment to the standby database.

Also, a common concept is to run the Standby database with say a 2hr lag behind the Production Database. In the instance when an erroneuos Delete/Insert command is issued, it is possible to quickly recover from this situation.

A small factor in standby databases is the slight network overhead while the archived logs are copied across to the standby server. Normally this overhead is insignificant. Also, its good to put some monitoring in place to check the standby database is always up-to-date.

If you need more info then let me know.

James

James,

We are using a standby database as well. However, every once in a while an archive log doesn't get transmitted to the standby server correctly. We just get the first 1024 bytes. Any ideas why??

Hi ciavaglia,

Let me know:

* Your operating system
* Database type and version
* Method for copying logs to standby server (rcp, ftp, brarchive, arch_dest2 )

My first guess is that the remote file system on the standby server would be near 100% full.

I have seen the same problem when the copy process is running against a file that has not been closed by Oracle yet.

As far as the synchronization of the directories go, you can use a NFS mount for the $BSE directories, use a NetApp or similar cifs/NFS appliance for the shared drive, use rdist or other supplied file distribution tool, use a tool like Veritas Volume Replication (overkill for this application), or the samba rsync product that in my book is better than rdist...

I have used all of these and they all solve the Baan directory sync problem.

-- Jim