Microsoft Sql Server Technical Track

Favorite way: migrating to exadata

Fahd Mirza
by Fahd Mirza
1 min read
Sep 9, 2015

There are lots of considerations to be taken into account when migrating databases to the Exadata. It's like any other migration. DBAs and other stakeholders of the system have to evaluate what to migrate and what not to, physical and logical settings, versions and many other things. I'm not delving into migration preparation or strategies and methods here, instead I want to mention which method I like the best to migrate databases to the Exadata. By doing it this way you can make the source database primary in Dataguard configuration and creating a physical standby on the Exadata, and then switch-over the primary to Exadata. How's that? Neat, simple, quick and beautiful. Generally, these steps would be followed to accomplish this physical approach of migration:
  • At source database, enable the force logging, put it in archivelog mode, set secondary archive destination, add TNS entries and add standby redo logs etc.
  • At Exadata, make sure ASM instances are up and running.
  • At standby side, create a simple parameter file, make entries in TNS, and then start standby instance in nomount.
  • Then from primary, in RMAN, connect to the source database and with target auxiliary standby and run duplicate target database for standby from active database.
  • Then after making sure that standby is in sync with primary, switch-over to the standby.
  • Using srvctl register this database to clusterware at all nodes of Exadata and configure database as RAC.
  • Point your applications to the new Exadata database.
Of course, the devil is in the detail and proper planning, testing and execution is needed just like any other migration project. As a side note, my second favourite method for migration is with Oracle GoldenGate. :)   Learn more about our expertise in Cloud technologies.
Previous story
← Oracle EBS R12.2: Restarting online patching enablement patch
Next story
Amazon S3 to Glacier - Cloud ILM →
Bulk Loading Options for Cassandra
Microsoft Sql Server

Bulk Loading Options for Cassandra

Sep 24, 2012 3 min read
Fix: The Instance ID 'MSSQLServer' is Already in Use by SQL Server Instance 'MSSQLServer.Inactive'
Microsoft Sql Server

Fix: The Instance ID 'MSSQLServer' is Already in Use by SQL Server Instance 'MSSQLServer.Inactive'

Sep 27, 2023 2 min read
Amazon database migration service - first try
SQL Server

Amazon database migration service - first try

Mar 28, 2016 6 min read

Get Email Notifications

No Comments Yet

Let us know what you think

Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.