Oracle 10g on AIX with JFS2

[Former Member]

Anybody running this setup? We have just upgraded our oracle to 10g. Then there was an issue with our online backup and dbverify shows some file cannot be read. The OSS and note 948294 are suggesting the same thing which is to mount our sapdata with 'cio' option.

Thus said, we only encounter this problem on our production system. Our DEV and QAS doesn't have this problem. So I would like to know if anybody running this setup without problem?

The problem with this mount option for me is because the setup of my oracle filesystem. All of my oracle filesystem is mounted in one filesystem( lv) which is /oracle/PRD. All of my oracle binaries, config files and sapdatas are in there. In order to use the cio mount option I've to create new separate filesystems ( lv) for my sapdatas. ...sigh

[stefan_koehler]

Hello Mohammad,

> So I would like to know if anybody running this setup without problem?

Yes we are running the oracle file systems (sapdata, origlog<X>, mirrlog<X>) with the cio mount option.

If you don't use RMAN you have to mount the file systems with the cio option, because of oracle accesses the JFS2 file systems with cio by itself, if the file system options parameter is set to "SETALL" (which is recommended by SAP).

You can verify this by running the following command:

lsof +fg <FILESYSTEM>

The problem is that you can get problems while performing a backup (or dbverify, etc.), but this depends on how the files are accessed at this moment.

> I've to create new separate file systems ( lv) for my sapdatas

Yes i would also recommend this. Create seperate lvs for the sapdata and redolog file systems.

Please read my blog about the redolog file systems and CIO (it explains how you should create the file systems and why):

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

Regards

Stefan

[former_member227600]

Hi,

I have also worked on same environment. There are no problem to mount datafiles with cio option. your problem will resolve ,when you mount your datafiles with cio option.First of all stop sap & DB & than unmount all data files. & than mount all datafiles with cio option.

mount -cio /oracle/<SID>/sapdata1....n

Regards

Karan