RE: suggestion - Non rac database to rac database migration methodology
Date: Wed, 22 Jun 2011 18:33:41 +0000
Message-ID: <DF78EADE484D37419A53F5C898629DB7CD1E04_at_USMAIL2K1001.us.micros.int>
Agree with this and I'd add - if you use OLAP functionality, you will need to drop and recreate OLAP as it is bit-sensitive.
Stephan Uzzell
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Wednesday, 22 June, 2011 14:29
To: krish33moorthy_at_gmail.com; oracle Freelists
Subject: RE: suggestion - Non rac database to rac database migration methodology
Hmm....this is a bit of a broad question, as we don't know much about your configuration.
First, you mention ASM as being configured on the new RAC. You don't mention it on the source database, so, I assume it's currently non-ASM? If so, using RMAN as a migration path may be viable. If you do a Google search for 'oracle migrate filesystem to asm', you should find lots of hits.
If the source is *already* on ASM, and assuming the storage is already SAN based, you could work with the storage team, to remove the devices from the current host, and present them to the new RAC hosts. That would be, by far the quickest, but is dependent on your SAN configuration, and whether you're already on ASM.
Once you've got the database itself moved, you'll need to add a new thread and set of online redo log files, and don't forget to enable the new thread. Then it's off to the init.ora (or, hopefully, spfile) to set instance-specific parameters, like undo_tablespace, thread, local_listener, etc. Finally, set cluster_database to true, and you should be able to start up on both nodes of your new RAC cluster.
Hope that helps,
-Mark
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of KRISHNA MOORTHY
Sent: Wednesday, June 22, 2011 1:56 PM
To: oracle Freelists
Subject: suggestion - Non rac database to rac database migration methodology
Hi,
Currently we are migrating an non rac database to rac database.
Source:
OS :RHEL4
Database Version: 10g R2 32 bit
RAC : No
Target :
OS :RHEL5
Database Version : 10R2 64 Bit
RAC : 2 node ASM database
For the above migration, i have taken expdp/impdp methodology.It takes 15 hours to complete activity.(The data transfer rate from source to destination is 300KB per seconds)
Please suggest as any other methodology for this migration to reduce downtime.
Regards
Krishna
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 22 2011 - 13:33:41 CDT