Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Conversion of a 3 TB NON-RAC Database To "ASM" - RAC in 10gR2 ?

Re: Conversion of a 3 TB NON-RAC Database To "ASM" - RAC in 10gR2 ?

From: arun chakrapani rao <arunchakrapanirao_at_gmail.com>
Date: Wed, 18 Apr 2007 07:37:50 -0400
Message-ID: <a85d265d0704180437n13152116o7809a873b4122aef@mail.gmail.com>


use ASM to take a back from ufs to asm file system and use the switch command in RMAN to switch the database files to the new file system. u do not have to restore it to the new file system. Just the switch will take care of the whole thing once u have backed it up. While backing up just take care as to which diskgroup ur files have to go. once the backup is done.
create multiple redologs in the ASM fle system and then drop the one which are in the UFS
once all these have been done then use the switch command.

in R2 it is much easier to switch between file systems.

On 4/18/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> Folks
>
>
>
> What could be the approach to Convert a Large *3 TB* NON-RAC *Production*Database with Datafiles existing on cooked/Mounted Filesystem (
> *UFS*) to a 3 instance RAC using "*ASM"*?
>
>
>
> NOTE Production Database is Near 24*7 with Minimal Downtime.
>
>
>
> *Can the Datafiles be copied using "dd" Command from the Mounted FS to the
> RAW Device Space of ASM?*
>
> * *
>
> *Need the basic approach Steps for conversion.*
>
> * *
>
> *Any Docs, pointers, Links will help. (*Did search Oracle Documentation,
> but could NOT find a practical *Hands-On Note*)
>
>
>
> Config:-
>
> ---------
>
> Solaris 10
>
> Oracle 10gR2
>
> 3 instance RAC
>
>
>
> Thanks indeed
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

-- 
thanks
Arun

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 18 2007 - 06:37:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US