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: Zhu,Chao <zhuchao_at_gmail.com>
Date: Wed, 18 Apr 2007 22:33:34 +0800
Message-ID: <962cf44b0704180733p3de65cf9i585920aeec7d4343@mail.gmail.com>


Why not build a standby database and do the switch? It should be easy to restore the datafile backup from production, to the ASM disks with rman; and just do a graceful switchover, and it is done! 5 min...
On 4/18/07, Kerber, Andrew W. <Andrew.Kerber_at_umb.com> wrote:
>
> I don't know about using dd, but export/import would work if you have the
> space. IF these are 10g databases, you can use the database_link option and
> copy the schemas directly using datapump (a real nice solution)…
>
>
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *VIVEK_SHARMA
> *Sent:* Wednesday, April 18, 2007 2:10 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Conversion of a 3 TB NON-RAC Database To "ASM" - RAC in 10gR2 ?
>
>
>
> 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***
>
>
> ------------------------------------------------------------------------------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the individual
> or entity intended as the recipient. If you are not the intended recipient,
> any use, copying, printing, reviewing, retention, disclosure, distribution
> or forwarding of the message or any attached file is not authorized and is
> strictly prohibited. If you have received this electronic mail message in
> error, please advise the sender by reply electronic mail immediately and
> permanently delete the original transmission, any attachments and any copies
> of this message from your computer system. Thank you.
>
>
> ==============================================================================
>

-- 
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 18 2007 - 09:33:34 CDT

Original text of this message

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