14 Replies Latest reply on Jul 6, 2018 1:53 PM by User569011-OC

Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 25, 2018 3:56 PM

Hi Friends,

I have a 12.1.0.2 (Jan 2018 PSU Applied) 2 Node RAC Non Container Database on Linux 64 Bit. I would like to Migrate this Database to our Exadata X6-2 Machine with 12.1.0.2 (April 2018 PSU Applied) using Data Guard ( Create a physical Standby for the database on Exadata and perform a switchover) . Is this method possible?

Thanks.

1. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

SPA09 Jun 25, 2018 5:54 PM (in response to User569011-OC)

Hello,

of course is this possible.

It is the preferred way to do a Migration.

Keep in mind that the new X6 must habe the Oracle Release 12.1.0.2 + Jan 2018 PSU.

So if you have newer Oracle Software installed on the X6 for example 12.2.0.1 you need to
clone your Oracle Release to the new Cluster.

regards
Like Show 1 Likes(1)

Actions
2. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 25, 2018 5:57 PM (in response to SPA09)

Hello SPA09,

Thanks for the reply.

Source Database on Linux 64 Bit is 12.1.0.2 ( Jan 2018 PSU)

Target Oracle Home on Exadata is 12.1.0.2(April 2018 PSU)

Thanks.
Like Show 0 Likes(0)

Actions
3. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

SPA09 Jun 25, 2018 6:01 PM (in response to User569011-OC)

Hello,

yes, that is no problem for the Data Guard Setup.

But if you have the possibility install also on the Source Apr 2018 PSU.

regards
1 person found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 25, 2018 6:16 PM (in response to SPA09)

Hi SPA09,

In case I do not have an option to patch the source to April 2018, what can be done?

Thanks.
Like Show 0 Likes(0)

Actions
5. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

robinsc Jun 25, 2018 6:54 PM (in response to User569011-OC)

As long as both source and target are 12.1.0.2 for the same platform or a compatible platform you are good to go ( compatible platform is like Intel linux 64 bit and intel solaris 64 bit). the PSUs generally have bug fixes and so as long as you are not hitting one of the specific bugs that the later psu fixes the dataguard instantiation and sync should work fine.
1 person found this helpful
Like Show 1 Likes(1)

Actions
6. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 25, 2018 8:06 PM (in response to robinsc)

Hi Robinsc,

Can both the source and target be 12.1.0.2 Non Container Databases? I read one MOS Notes where the per-requisites was "12c databases must be container databases" ? Is it true?

Thanks.
Like Show 0 Likes(0)

Actions
7. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

SPA09 Jun 25, 2018 8:24 PM (in response to User569011-OC)

Hi,

it is no problem to do the migration with different PSU's.

regards
Like Show 0 Likes(0)

Actions
8. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

SPA09 Jun 25, 2018 8:27 PM (in response to User569011-OC)

Hi

again don't get panic.
Yes both can be non container DB's.

Data Guard is one of the best and robust Products from Oracle. It works in Version 12.1.0.2 perfect.

regards
1 person found this helpful
Like Show 1 Likes(1)

Actions
9. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

robinsc Jun 26, 2018 3:05 AM (in response to User569011-OC)

Hi - dataguard can be used with non container databases in 12c no problem. up to a short while ago ebusiness suite did not support pdbs so there are thousands of installations around the world of ebusiness suite that use dataguard with non cdb 12c databases for DR purposes.
1 person found this helpful
Like Show 1 Likes(1)

Actions
10. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 26, 2018 1:05 PM (in response to robinsc)

Hi robinsc,

Thank you!
Like Show 0 Likes(0)

Actions
11. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 26, 2018 1:05 PM (in response to SPA09)

Hi SPA09,

Thank you !
Like Show 0 Likes(0)

Actions
12. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jun 29, 2018 2:52 PM (in response to User569011-OC)

Hi Friends,

Thank you all for your inputs. I was able to create the 2 Node RAC Physical Standby Database on Exadata for my Standalone Primary Database, configured Data Guard Broker.

Primary and Standby are in Sync.

But, now RMAN is not working on Primary.

RMAN> show all
2> ;

starting full resync of recovery catalog
ORA-20079: full resync from primary database is not done

doing automatic resync from primary
ORA-20079: full resync from primary database is not done

doing automatic resync from primary
ORA-20079: full resync from primary database is not done

doing automatic resync from primary
ORA-20079: full resync from primary database is not done

doing automatic resync from primary
ORA-20079: full resync from primary database is not done

doing automatic resync from primary
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 06/29/2018 10:43:26
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 06/29/2018 10:43:26
RMAN-20079: full resync from primary database is not done

RMAN> exit

Any ideas?

Thanks.
Like Show 0 Likes(0)

Actions
13. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

SPA09 Jul 1, 2018 6:17 PM (in response to User569011-OC)

Hello,

Have you configured the DB_UNIQUE_NAME in RMAN persistent configuration?

CONFIGURE DB_UNIQUE_NAME '<db unique name Primary>' CONNECT IDENTIFIER '<tns to primary>' ;

CONFIGURE DB_UNIQUE_NAME '<db unique name Sstandby>' CONNECT IDENTIFIER '<tns to standby>' ;

Show us the rman show all output.

You are connected to a rman catalog DB?

regards
Like Show 0 Likes(0)

Actions
14. Re: Migrate 12c Database to Exadata X6-2 using Data Guard

User569011-OC Jul 6, 2018 1:53 PM (in response to SPA09)

Hi SPA09,

I unregistered and registered the database from Recovery Catalog.

It resolved the issue.

Thanks.
Like Show 0 Likes(0)

Actions

Go to original post