migration from 12c to 19c

[Roshan]

Source: Oracle DB 12.1.0.2

RHEL 7,9

small indian

target: Exadata 19c

small indian

Hello Team,

I would like to migrate a 4TB database from source to target exadata. Assume both OS and target are same, which method would be fastest and easiest?

If suppose source was AIX(little endian) and target was Linux Exadata(little endian), which method would be best?

Also, could you please advise on a good document I can use to migrate using transportable tablespaces? In which case would transportable tablespace be best?



Thanks,

Roshan

[ErmanArslansOracleBlog]

Hi Roshan,

For; Exa (Intel Linux) to Exa (ıntel Linux) -> Dataguard

For; Cross platform across different endians (Little to Big or Big to Little) ->
Logical methods(like Goldengate)
or XTTS (Accelerated with Cross Platform Incremental RMAN Backup)
or Cross-Platform Database Transport to different Endian Platform with RMAN Backup Sets  (Note that: (This is applicable for tablespace level transport).You can transport a entire database only if the source and destination use the same endian format.. The benefit of this method is that the processing overhead of the conversion operation is offloaded to the destination database.)

--MOS Notes :

V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)
12c How Perform Cross-Platform Database Transport to different Endian Platform with RMAN Backup Sets (Doc ID 2013271.1)

[Roshan]

Thanks.