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.
- 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..
- 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.