Tools for migrations

[satish]

Dear erman,

We are planning to migrate our existing ebs database 12cr1 to new server with having oracle 19c.
OS versions remain same.
Our databas size is 600gb

Can we use rman restore/duplicate for this migration?
If no,Can you please let us know the limitaions of rman restore/duplication?
Can you suggest any option which we can use for this migration?

Thanks,
Satish

[ErmanArslansOracleBlog]

Can we use rman restore/duplicate for this migration?
-No you can't do that directly. you are on 12cr1, your target db is 19c.

--You must upgrade the database in source and then do the migration using rman
or
--You migrate the database to the new server using rman, and then upgrade the database to 19C there in the target.
or
--Use expdp-impdp and migrate your data from 12cr1 to the new server (19c) -- ref doc: Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c (Doc ID 2554156.1)
--Create a standby 12cR1 on target, guaranteed restore point on 12cR1 target. Switch over to standby Upgrade the 12cR1 target (old standby) to 19C. --less downtime.. no downtime during source-to-target copy phase. If you want to have the old server remain as standby -> once you complete the upgrade on new primary, upgrade the standby using the classical approach that you do in standby enabled environments)

All these operations must be done with an EBS-aware method.. This is an EBS document.. You should follow the relevant MOS notes (written specifically for EBS)

[satish]

Dear erman,

Can you please provide high level steps to perform migration using DataGuard.

Thanks,
Satish

[ErmanArslansOracleBlog]

Dataguard-based EBS DB migration :

high level:

Just create the standby EBS db
Sync it with the primary
Stop the apps services on primary
Do the switchover in the database level
Update the EBS Db tier config in the new primary database (old standby)
Update the Apps Tier config for making the apps services connect to the new database (new primary)
Start the apps services.

That's the high level plan.
Follow MOS documents for the detailed action plans.