1

I have a live Oracle Database with Dataguard in placed. I want to migrate live database to new server as tech refresh, but only Primary database. How I can achieve this? I have ideas on how I want to do it but I'm not sure whether it is correct.

  1. Create a full backup, then restore it to new server and update the dataguard configuration. Problem is, SCN in Standby database maybe different than New Primary database due to old Primary database is still running. If this happen, can i apply log from old Primary to New Primary? I'm not sure..
  2. Switch the existing Standby database to be Primary database and create a new standby database in new server. Then switch back Primary role to new database in new server.

PS. I'm not good in English. Thanks in advance.

1
  1. Create a full backup, then restore it to new server and update the dataguard configuration. Problem is, SCN in Standby database maybe different than New Primary database due to old Primary database is still running. If this happen, can i apply log from old Primary to New Primary? I'm not sure..

You can have multiple standby databases for a primary database. Create a full backup and restore it as a standby on the new machine, update the Data Guard configuration and keep that standby too in sync with archivelogs. When the time comes, simply perform a switchover to this new standby database.

  1. Switch the existing Standby database to be Primary database and create a new standby database in new server. Then switch back Primary role to new database in new server.

No, this is just unnecessary risk and extra work.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.