Re: ASM question !

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Tue, 27 Nov 2012 16:18:20 +0530
Message-ID: <CAEq4C0dBfVH9TKL8g1SaQmyY7ZyGNd0bEadrTMHi0muAhBCgGw_at_mail.gmail.com>



Hi,
I don't have any grounding in SAP. I am assuming that the DB version is going to be as is and you dont have rac presently.

what are your full RMAN backup timings?. you could workout some indicative timings based on the full backup and decide on the strategy

best regards

sriram kumar

On Tue, Nov 27, 2012 at 3:55 PM, Raja Subramaniyan <raja.s28_at_gmail.com>wrote:

> Hi,
>
> Thanks for your reply. Here is version & size information of OS, DB & SAP
> ,
>
>
> HP-UX B.11.23 U ia64
> Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
> DB Size :
>
>
> GB
> ----------
> 15435.7768
>
> Thanks
> Raja Subramaniyan
>
> On Tue, Nov 27, 2012 at 3:39 PM, Sriram Kumar <k.sriramkumar_at_gmail.com>wrote:
>
>> Hi,
>>
>> RAC has no additional role to play in migrating from file system to ASM.
>> ASM is mandatory for RAC but not the otherway around.
>>
>> what is the oracle db version and how big is your database?. approach
>> that you will choose will depend on the size and the down time you will
>> get. you could do a simple RMAN backup and restore to migrate to ASM.
>>
>> RMAN backup would be a byte to byte copy of the original database and
>> would not help you in defragmenting.
>>
>> best regards
>>
>> sriram kumar
>>
>>
>>
>> On Tue, Nov 27, 2012 at 3:20 PM, Raja Subramaniyan <raja.s28_at_gmail.com>wrote:
>>
>>> Hi,
>>> 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.
>>>
>>>
>>>
>>> Regards,
>>> Raja Subramaniyan
>>>
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 27 2012 - 11:48:20 CET

Original text of this message