RE: suggestion - Non rac database to rac database migration methodology
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: "'Mark.Bobak@xxxxxxxxxxxx'" <Mark.Bobak@xxxxxxxxxxxx>, "krish33moorthy@xxxxxxxxx" <krish33moorthy@xxxxxxxxx>, oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2011 18:33:41 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bobak, Mark
Sent: Wednesday, 22 June, 2011 14:29
To: krish33moorthy@xxxxxxxxx; 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
