Re: SAP on Oracle doubts

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: niall.litchfield@xxxxxxxxx
  • Date: Wed, 10 Feb 2010 10:00:09 -0800

On Wed, Feb 10, 2010 at 5:20 AM, <niall.litchfield@xxxxxxxxx> 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.



Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: