Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Conversion of a 3 TB NON-RAC Database To "ASM" - RAC in 10gR2 ?
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-lReceived on Wed Apr 18 2007 - 06:37:50 CDT