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

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 18 Apr 2007 07:42:14 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: Wednesday, April 18, 2007 2:10 AM
To: oracle-l@xxxxxxxxxxxxx
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.

==============================================================================

Other related posts: