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: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Wed, 18 Apr 2007 07:42:14 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB307EEFFDD@x6009a.umb.corp.umb.com>


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


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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 18 2007 - 07:42:14 CDT

Original text of this message

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