Hello,

We are using baan IV C4 sp18 IS5 DB-oracle 9i , we are also using Oracle standby database (non-managed).

Please clarify on the following points :
1.In case if the Standby database is made managed (i.e archives/transaction moves automatically from production to standby) then if the Baan Data Dictionary corrupts does it affects the Standby.
2.If yes , then what could be the Solution.
3.What criteria can make the Baan data dictionary corrupt.

Please consider this as Urgent .Thanks in advance.

Regards,
Sushil Kumar Mudaliar
+919845640484

First You need to specify that how did you implemente Your Standby Data Server.

Well DD can be corrupted when you are doing Rebulild DD and still system not in single user mode. or at the time of doing Run time DD & some person accessing the same table . so these are the main reason basically.


Well if your StandBy system is log based kind of replica then its 100% chance that it will be corruped. But its suggestable that you should be in single user mode at time of doing all these activities.

DD corruption happenes when Application and Runtime DD doesnot match.

Shiv

managed or non-managed does not matter in this regards. A corrupt DD for baan means, that the (runtime) DD of Baan in $BSE/dict ir not consistent with the actual table definitions in Oracle.

So if you have this situation in your primary DB, then you also have it on the standby.

HI,


Shiv>> i have made the standby Database by using the Oracle data guard .

please let us know how do i take consistent backup of Baan data dictionary.

Thanx in advance.

Regards,
Sushil Kumar Mudaliar

Probably dictionary replicator or third party utilities (http://www.baanboard.com/baanboard/showthread.php?t=10551) can help in this regard.

sorry to update after so long days.

well you specify what exactly you have done before that incident has happened. YOu directly talk to me on shiv_softengg@yahoo.com.

Regards

Shiv