Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle & SAP
Be always aware that SAP was designed for a flat file system and this was ported to ORACLE without any regard for the inbuilt relational functionality of ORACLE. It was also ported to other relational databases that don't support anywhere near what ORACLE does. Result: it is not in any way optimized for ORACLE (or any other relational database, for that matter).
So, it has some (apparently) silly traits. Amongst them, it needs humongous rollback segments, it generates enormous amounts of redo log material and you will find that SAP will refuse to support you unless you run archive redo log on. Which has the side effect of generating humongous amounts of archived redo logs. Be prepared to handle them. This is because SAP has no inherent logical recovery, it relies entirely on ORACLE recovery to re-set the whole lot to a sensible state.
I still have to see ONE case where recovery of a crashed database up to a point-in-time will work with SAP, although they seem to imply that is the reason they need archive redo log on, but that is another story....
There are a few more gotchas, but these are the main problem areas in SAP/ORACLE installations.
HTH
Cheers
Nuno Souto
nsouto_at_acay.com.au
sanjay_at_oseda.missouri.edu wrote:
> Hi all,
> I have taken over a SAP/Oracle system and while I am comfortable
> with administering Oracle, handling SAP data is new to me.
> Any DBAs out there who can warn me against gotchas or recommend
> some best practices ?
> TIA
> sanjay
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Mar 30 1998 - 00:00:00 CST