SAP and Oracle configurations

[Former Member]

Hi...

i'd like to know which kind of configuration recommended to use Oracle database while it involving with SAP

say... in which mode Oracle DB is supposed to run.. (archivelog mode or not archive log mode)...what are the backup policies recommended to use... (whether it is RMAN backups/user managed backups...)

like wise what are the recommended settings....

Is there any link to learn those basic stuff, that relates to SAP-Oracle configurations..

NewBeee

(in this environment it uses Oracle 10.2 ver )

[Former Member]

Hi Ushan Pathiratne,

Document ADM51 will help you.

Regards

Ashok

[Former Member]

hi Askok...

whats meant by Document ADM51

any url

thanks

[Former Member]

ADM51 is the sap education training for sap on oracle, distributing the training materials is not allowed.

You can start browsing here:

[Oracle on SDN|]

[Note 830576 - Oracle FAQ|https://service.sap.com/sap/bc/bsp/spn/sapnotes/index2.htm?numm=830576]

Best regards

Michael

[Former Member]

Hi,

Please check this, there is a lot of useful information about Oracle.

Best Regards,

Erick Ilarraza

[Former Member]

Hi,

The best configuration is to put the system in Archive log mode so that we can recover the system in case of a system crash.

Regarding the backup it will be good if you schedule it as a cronjob which will run at os level in the background with out any miss.

I dont have any specific document for the configuration .... sorry ...

Thanks,

Deepthi