Has anyone recreated an on-premise Oracle Database in the cloud and specifically an Azure Database(Oracle) Instance?
The total size of the database I want to recreate as backup in the cloud is around 260GBs and the version is Oracle 10G.
The two options I can see it's either RMAN(via tape) or a database dump(exp or expdp). What is the most efficient and trouble-free way out of these two? My opinion is that a database dump could be a better option, however I am worried in terms of performance and running all those insert statements from scratch. Any thoughts?
Any help gladly appreciated! Thanks!