Re: SAP on Oracle doubts
Date: Wed, 10 Feb 2010 10:00:09 -0800
On Wed, Feb 10, 2010 at 5:20 AM, <niall.litchfield_at_gmail.com> wrote:
> SAP mandates a number of initialisation parameters (that vary by Oracle and
> SAP release) including undocumented ones, and sometimes also including ones
> that make no difference at all (FILESYSTEMIO_OPTIONS is mandated on Windows
> for example). The recommendations that you have below are almost certainly
> sourced directly from a note from the SAP support knowledge base.
You will find that the SAP support folks are very much on top of Oracle bugs If there are SAP recommendations for parameter settings, it is usually a good
idea to set them unless you have proof otherwise.
> Clearly there are security implications here so it might be worth doing a
> SAP knowledge base search around SOX compliance to see if these requirements
> can be removed. I'd leave the SAP dba in the DBA group though because most
> all database administration is likely to end up being done by them through
> the SAP admin tools for Oracle. In recent releases these tools have got
> reasonably smart - so for example just because you use BRTOOL to backup your
> database that doesn't mean that the backup can't be an RMAN hot backup -
> these advances have not always been appreciated by BASIS consultants.
Ugh. I don't trust anyone else with backup and recovery because it is MY responsibility and I am not going to delegate it.
So, I don't use the BR tools for backup or recovery.
The BR tools are a morass of command line options. Much simpler to just use RMAN and skip the brbackup tools IMO.Received on Wed Feb 10 2010 - 12:00:09 CST