Re: ASM question !

We are also in the process of upgrading and re-platforming, including moving from OS based file system for datafiles to ASM and I would recommend working VERY closely with your SAP/BASIS application admins.

The following SAP Notes may help (I believe this requires a support contract and login with SAP):

Note 214995 - Oracle locally-managed tablespaces in the SAP environment Note 646681 - Reorganizing tables with BRSPACE

Also I would recommend browsing the following sites and articles:

http://scn.sap.com/docs/DOC-7888
http://scn.sap.com/community/oracle
http://www.oracle.com/us/solutions/sap/wp-sap-rac-asm-adv-config-oct2012-1875141.pdf
http://www.oracle.com/us/solutions/sap/asm-bestpractices-304655.pdf

hope that helps,
Brent

> We are looking for RAC Implementation for our SAP database instances. I
> have one question about the migration process of File System Datafiles to
> ASM.
> If we do so, the reorg of the objects are automatically done, while
> migrating file system datafiles to ASM. Please let me know, I am new to
> RAC.
> ( The reason behind this question is , our existing SAP database have many
> dictionary managed tablespaces, which need to be migrated to locally
> managed tbs) Thanks in advance.

--
http://www.freelists.org/webpage/oracle-l