Application of Note: 948294 - AIX JFS2 mount options to use with Oracle 10g

[Former Member]

Hi guys.

I implemented the backups via SAP BR*Tools and offline backups are working properly, but online gives me problems because I have datafiles more > 2GB.

I will implement the SAP Note 948294 - AIX JFS2: mount options to use with Oracle 10g, Online backup of oracle database not working with JFS2 and Oracle 10g.

I have read several forum post here and see that change the mount filesystems should have no problem taking care before stopping the system and database.

My question is? What other factors should I consider before applying the SAP Note 948 294, I understand that this note will apply to only the following filesystems:

/oracle/SID/origlogA

/oracle/SID/origlogB

/oracle/SID/mirrlogA

/oracle/SID/mirrlogB

/oracle/SID/sapdata1

/oracle/SID/sapdata2

/oracle/SID/sapdata3

/oracle/SID/sapdata4

What other recommendations can give me?

System data:

ERP 6.0

AIX 6.1

Oracle 10.2.0.4

Best regards,

[stefan_koehler · Accepted solution]

Hello Marta,

> What other recommendations can give me?

You have to take care about the filesystem blocksize of the filesystems origlogA, origlogB, mirrlogA, mirrlogB.

If you are using CIO on that filesystems and you have the wrong blocksize, you will get issues with demoted I/Os.

I already wrote a blog about that topic some time ago:

/people/stefan.koehler/blog/2008/11/30/oracle-tuning-log-file-syncs-on-aix-with-diocio

Regards

Stefan

[Former Member · Accepted solution]

Thanks Stefan for the replay.

How to check the block size of the filesystems origlogA, origlogB, mirrlogA, mirrlogB ?

When i´m installing de ERP, the sapint is created the origlogA, origlogB, mirrlogA, mirrlogB in 512 MB size, look:

/dev/lvoraoriga 512.00 401.49 22% 8 1% /oracle/SID/origlogA

/dev/lvoraorigb 512.00 401.49 22% 8 1% /oracle/SID/origlogB

/dev/lvoramirra 512.00 411.59 20% 6 1% /oracle/SID/mirrlogA

/dev/lvoramirrb 512.00 411.59 20% 6 1% /oracle/SID/mirrlogB

Best Regards,

[stefan_koehler · Accepted solution]

Hello Marta,

> How to check the block size of the filesystems origlogA, origlogB, mirrlogA, mirrlogB ?

Described in my blog in chapter "Filesystems and its options".

You have to use the command "lsfs -cq /oracle/<SID>/origlogA" for example.

Regards

Stefan

[Former Member · Accepted solution]

Hi Eric and Stefan

Thank you both for the answers.

I'll follow the blog of the procedure has helped me to understand the change I wish to make on my system.

Best regards

[former_member204746]

adapt file init[SID].sap

change CPIO to DD (in lowercase)

[Former Member]

Thanks Eric, i´m change the file initSID.sap to dd

[former_member204746]

Marta, did the DD change work?

If so, please change the status of this question to answered.

If not, read Stefan Koehler's answer and tell us if that helped.